Remove VB code from saved Excel file
Posted on 2012-09-18
My excel macro is executed from command line using Workbook_Open()
At the end of the macro, the template file from where the code is running, saves a output file with date time stamp.
But the output file has the code as well, and when I open the output file, Workbook_Open() executes again with error.
How can I save the output file with out copying over the VB code/macro?