Posted to microsoft.public.excel.programming

Glen Mettler[_4_] Glen Mettler[_4_] is offline

external usenet poster

Posts: 70

Help with SaveAs

I need to save and xls file as a tab delimited text file
This is my code:
ActiveWorkbook.SaveAs Filename:=filetosave, FileFormat:=xlText

is the default delimiter a tab or do I need to add another parameter?

Glen

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SaveAs - VBA	Jae[_3_]	Excel Discussion (Misc queries)	4	April 10th 08 08:10 PM
SaveAs - VBA	Jae	Excel Discussion (Misc queries)	0	April 10th 08 06:04 AM
SaveAs	Stan Halls	Excel Worksheet Functions	5	November 28th 06 07:51 PM
Saveas	Dale Levesque	Excel Programming	6	May 5th 04 04:06 PM
SaveAs	Bill[_19_]	Excel Programming	1	January 27th 04 11:11 PM

All times are GMT +1. The time now is 08:02 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us