Open specific workbook and run a macro within

[PaulM100]

Hi,

I am trying to open a specific workbook WorkbookB in a specific folder to run a macro within it. I am planning to call the macro from WorkbookB into another one in WorkbookA. The macro in WorkbookA should do something, then call the one from WorkbbokB, wait for MacroB to do the job, and then to continue to do other things.
My problem lies in the fact that the below macro opens the file, but it doesn't run the macro within it. No errors occured. Any ideas why?

Please Login or Register  to view this content.

ACSessions is the module
CopyFilteredValuesToActiveWorkbookACSessions is the macro

Thanks,
Paul

[rorya]

How are you triggering the OpenAndRun macro?

[PaulM100]

The situation is like this: I have 10 macro in workbookA. I use a master macro to call them in order mostly to keep it simple. This works. In WorkbookB I have 7 macro, and I use a master one as well. I am plannig to set this one in the master macro in WorkbookA. Currently I try to test it using a single macro, the most simple one in WorkbookB.
Application.Run - this should run the macro

[rorya]

That doesn't answer my question though. How are you running OpenAndRun? From the macros dialog, a keyboard shortcut, f5 in the VBE, or something else?

Also, have you tried stepping through the code to see what happens?

[PaulM100]

F5 in VBE.

But I took another approach and managed to fix it. Thank you anyway

[rorya]

Care to share the solution in case it benefits someone else in the future?