Office97
 

Hi,

I hace an Excel 97 spreadsheet and when I record a macro to save it as text
file, it works, but put the text between quotation marks... If I do it by
hand there is no quotation mark...

Do you know why ?

If not, I would customize macro: excel made this:

ActiveWorkbook.SaveAs Filename:="G:\myfile.txt", FileFormat:=xlTextMSDOS,
_
CreateBackup:=False

Is there a way to save ActiveWorkbook content to a string and save the
string 'manually' ?

TIA