B
Borja
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
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