I have made a loop to open files in a directory but cannot figure out how to run the macro using the workbook variable I have created for the newly opened workbook. In the App.Run line it gives error because it can't find "DataWkbk.xls" but DataWkbk is workbook variable i've defined as the one I just opened not the actual filename. Maybe it should be something like DataWkbk"!Macro". Dunno. Thanks for the help.
Please Login or Register to view this content.
Bookmarks