Excel XP & Win XP
I have files AAA.xls and BBB.xls open.
I am running code that is in AAA.xls.
I want to run macro MyProc that is in BBB.xls.
For that I use this code:
Application.Run "BBB.xls!MyProc"
I get the error that the macro cannot be found.
I checked the file and macro names and they are right.
Is the Application line syntax not right?
Thanks for your time. Otto
PS: The 2 files reside in different folders. Could that be a problem?