Running Macro
You need to have the other workbook open
Application.Run "'B.xls'!ABC_Load"
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"James8309" wrote in message
...
Hi everyone,
I have a macro called "Load" in workbooks("A".xls) which works
perfectly. I am just trying to run different macro "ABC_Load" in
workbooks("B".xls) before I run macro in workbooks("A".xls)
How do I call this macro from current workbook A?
Workbook B is located C:\My Documents\
Macro name: ABC_Load
Thank you in advance
|