Hello!

I have struggled with this problem for a while now and I hope this forum can help me.

I have an excel sheet with data which I want to "export" or "savecopyas" to a specific folder so that the current excel file is not affected. I tried "savecopyas" command (ActiveWorkbook.SaveCopyAs "C:\TEMP\XXXX.XLS"

) it saves fine, but the txt file that it saves is not something that is readable for example in notebook.

What I would like get is that I open an excel file, then hit a shortcut key for a macro and then data in that excel sheet is saved as a txt file (Tab-delimited) to a specific folder with a name that is always the same. Also when it saves then it should automatically re-write the previous file without notice.

I really hope somebody can answer this question.

Best wishes

Urmas