Macro to save excel sheet to a specified location and in txt format

Hello and welcome to the forum,

Maybe try this:

Please Login or Register  to view this content.

abousetta

SaveCopyAs will save the copy as the same format as the original (not as text). Did you want to save it both as a an xlsm file and a txt file? I assumed you wanted to discard any changes so that the template would be the same and only the text files would change.

Ok, I did not know that. Basically I have an excel file that I open and do not want to save. I would like to save the txt file that is generated from the excel data. The current problem is that when I use the macro that you wrote, the txt file is saved correctly, but the excel takes this saved file as template right away. When I used SaveCopyAs command, then it did not touch the original excel fail anyhow.

This is just a minor problem and I can work with the macro you gave. Thank you very much for that!

Urmas

Here is an updated version. What it does is creates a new copy of the workbook using the saveas function >> opens the newly created workbook (thereby making it the activeworkbook) >> saves the newly created workbook as a text file >> Closes the newly created workbook without saving >> deletes the newly created workbook.

Remember to test on a copy of the original as the 'Kill' function has no undo process (also good to backup your work first).

Please Login or Register  to view this content.

abousetta

Glad I could help.

Good luck.

abousetta