All,
I have a master excel patch file with which I can make changes in excel files in a specific folder.
This works fine.
Now, I'm looking for a solution to run marcos of the source files via the patch macro.
This works good when I enter the absolute file name plus macro name:
Application.Run "ade - file145.xlsm'!Update2"
but not if I use the variable for the file name which is needed in my case because the patch marco loops through all files in the source folder and should run the update2 macro in every source file.:
Application.Run "theopenworkbook!Update2"
I think I got something wrong with the "" settings around the variable theopenworkbook.
Do you have any idea how to fix this?
Thanks
freeman
Bookmarks