VBA code to convert excel file to .txt

[lbl159]

I am currently creating a system to as close to automatically compare two files exported from different places in a database to ensure that everything matches 100%. Right now I have a macro created for each excel file in order to format them identically. I am using notepad++ to compare these two files so I need them to be in tab delimited .txt. I would like to add another portion to the end of each macro that will, after formatting the document, convert it to a .txt file and save that file in a desktop folder. Any ideas?

[nigelbloomy]

Does this help?

Please Login or Register  to view this content.