I would like to export a particular sheet in my excel workbook to a tab delimited text file using a macro. My workbook is macro enabled. I have tried to start recording and save the file. When I stop the recording, I am able to see the macro created. Upon closing the xlsm file and opening it again, I do not see the recorded macro in the file anymore.
Any help would be much appreciated in this.
Thanks, Rahul