Open Excel 2003 workbook run macro save workbook
Posted on 2013-01-17
I have over 1,000 Excel 2003 workbooks that I need to open and then run a macro that is already in a personal.xls file and then save the file with the same name. The workbooks contain multiple worksheets.
The macro in the personal.xls file is named "Database_query" this macro is huge and makes calls to numerous other macro's that all reside in the personal.xls file. Its also writes to the "thisworkbook" in the workbook being opened.
Is there a way to do this in a batch so I do not need to open each files and do it?