Good day,
Using VBA,
I want to open a work book and run the macro in the opened file,
From File 1,
Workbooks.Open Filename:= File 2
Run macro in File 2
Since the macro is in a different module, would I have to use application.run rather call ?
Good day,
Using VBA,
I want to open a work book and run the macro in the opened file,
From File 1,
Workbooks.Open Filename:= File 2
Run macro in File 2
Since the macro is in a different module, would I have to use application.run rather call ?
Found my answer,
for those who need it,
the document name goes in single quotes ' '
the name and macro go in double quotes " "
separate the macro name with an exclamation mark !
Application.Run "'documentname'!macroname"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks