I am using a procedure that creates a file and copies my workbook (xlsm) and saves as a xls workbook to the created file, and this is working well.
I need to remove all Macros and vba when the save as is exacuted, i.e I need to remove the Macros/vba from the workbook being saved NOT the original workbook.
I know I could save it as a xlsx workbook to remove all Macros and vba but I need the workbook to be a Macro/vba free xls workbook.
I have Google'ed but did not find anything I could use, will continue to look and post back if I get this figured out.
Best Answer
I found this here:
http://enholm.net/index.php/blog/vba-code-to-transfer-excel-2007-xlsx-books-to-2003-xls-format/
It searches through a dirictory looking for xlsx files and changes them to xls files
I think though it can be changed to look for xlsm files and change them to xls files as well.
When I run it I get:
I do not know enough about vba to figure out what is not working. Thanks