Another problem with export to TXT

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Hello,
I have interesting problem.....I have some sheets with datas.When I manualy
"Save as" TXT file (and record macro) evrythnig is ok.
Then when I used this record there is problem in exported TXT file. When I
open it there are in some places quotation marks "
I am getting crazy do you know somebady why?

Thanks Tom
 
I find out solution:

ActiveWorkbook.SaveAs Filename:="test.txt", _
FileFormat:=xlTextMSDOS, CreateBackup:=False, Local:=True

Local:=True - this is important.

Tom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export to txt file using VBA 1
SaveAs *.txt - Outputting with Text quantifiers 4
Export only Modified Records 1
Export txt file problem 3
Export Table Records to txt file 1
Sort column without referencing sheet name 4
.txt import + saveas + mkdir 3
Rename a .txt file via Excel macro 4

Back
Top