run a macro in the open workbook

[khalid79m]

Please Login or Register  to view this content.

Each file this code opens has a macro in named "updateraa" i need it to run this before it runs "SET1" how can I do this. IF it type Run "updateraa" macro cannot be found as it is not the workbook the above macro is running in. the updater aa is in the workbook that has been opened by the macro above.
is it application.run ? or somwthing like that,

[paulmezick]

I just came to this forum to post the same exact question... funny

[paulmezick]

I did a little searching and found a solution

Try this:

Application.Run(wb.Name & "!updateraa", 1, 2)

where 1,2 are your parameters. Remove them if not needed.