Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with SaveAs
the fileformat includes the delimiter in this case.
-- Regards, Tom Ogilvy "Glen Mettler" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with SaveAs
The default for xlText is a Tab, so you do not need another parameter. Try
it and take a peek at the file using a wordprocessor. -- Cheers Nigel "Glen Mettler" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SaveAs - VBA | Excel Discussion (Misc queries) | |||
SaveAs - VBA | Excel Discussion (Misc queries) | |||
SaveAs | Excel Worksheet Functions | |||
Saveas | Excel Programming | |||
SaveAs | Excel Programming |