Thread: Office97
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Borja Borja is offline
external usenet poster
 
Posts: 1
Default 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