Hi,
I'm using Excel 2013. I'm looking for a VB macro solution.
I have a .xlsm file. I want to export the active worksheet from this .xlsm file to csv. However, after the export, I want the .xlsm file to continue being my active workbook.
What's currently happening is when I export/saveas my .xlsm file to csv, the .xlsm file extension becomes a .csv I don't want the active .xlsm to become a csv
How do I achieve this via a Vb macro?
Thanks a lot.
I'm using Excel 2013. I'm looking for a VB macro solution.
I have a .xlsm file. I want to export the active worksheet from this .xlsm file to csv. However, after the export, I want the .xlsm file to continue being my active workbook.
What's currently happening is when I export/saveas my .xlsm file to csv, the .xlsm file extension becomes a .csv I don't want the active .xlsm to become a csv
How do I achieve this via a Vb macro?
Thanks a lot.