Macro for saving an Excel file as Text (.txt)

[collierd]

Hello

I am using MS Excel 2003

with vb I have a macro the key part being:

ActiveWorkbook.SaveAs "c:\Benchmark_Gross_Profit_Feed.txt"

This saves the excel spreadsheet as Benchmark_Gross_Profit_Feed.txt in my c directory

The problem is, when I open this, it's complete garbage!

Yet, if I manually save the spreadheet as Benchmark_Gross_Profit_Feed specifying Text (Tab Delimited) as the format the resultant file is perfectly legible

Any ideas what causes this?
Are there some additional parameters I should be using?


Thanks

Damian.

 

[fredericofonseca]

yes.

Use your macro recorder to see what the code created looks like when you perform the save manually.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[longhair]

collierd,

   ActiveWorkbook.SaveAs Filename:="C:\test\Book1.txt", FileFormat:=xlText, _
        CreateBackup:=False

regards,
longhair

 

[collierd]

Thanks

Problem lay with xlText

Fixed now