Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Craig Daniels on Sep 12 In MS Office Category.

Save a single sheet in Tab or Text Format

Question Answered By: Sammy Anderson on Sep 12

This worked for me. I just recorded myself saving a workbook in the
text (tab delimited) format.

ActiveWorkbook.SaveAs Filename:=strFN FileFormat:=xlText

This Question has 8 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on Save a single sheet in Tab or Text Format Or get search suggestion and latest updates.

Related Topics:

Save a single sheet as a separate file
Sheet Tabs Text Size prob
Hide sheet tabs
Opening Drill Down Data of Pivot Table in Single Sheet
formatting text which is in text formula
Exporting multiple sheets to .txt format
Need to save new copied sheet
other sheet's active cell
List in one sheet unanswered questions in checklist sheet
UDF Works only in One Sheet, Not in Other Sheets
Retrieve data from Sheet with SQL and put it in Another sheet
unprotect the sheet, insert hyperlink & then protect the sheet
Parsing a text into Excel sheet
MERGE TWO SHEET IN ONE NEW SHEET
Saving a file xls as a txt format
how to getvoice written inthe text format
filedialog for saving text file
Find text in an unselected listbox, then use to format shape in ppt
merged cells formatted by text length for height
saving a worksheet with the name read from a text file

Tagged:save single sheet in tab or text format

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us