VBA Code convert data to tab delimited and write data to text file | Not Working

[lbl159]

I have this VBA code to create a text file, convert my data to tab delimited, and then write the data to the file. This code is added at the end of an 80 line macro that formats the document to be identical to another in formatting to be compared as .txt files through Notepad++.

Everything is working properly except actually writing the data to the file. I see that the file has been interacted with because of the last saved date and time, but it is not writing any of the data.

Please Login or Register  to view this content.

[HaHoBe]

Hi, lbl159,

I would swap some code lines and alter one of them slightly. Please try

Please Login or Register  to view this content.

Ciao,
Holger

[Marc L]

Hi,

why not using SaveAs method ?