Hi All,

Thanks in advance for any help you can offer.

I have a situation where I am trying to run a macro in a different workbook using VBA. I want the macro to run within the workbook in which it sits. The following works:


    Application.Run "'Freed Blogs'!Main"
However it tries to run the macro main on the book I am calling it from when I want it to run on the woorkbook in which it resides. To add to my problems I ABSOLUTELY CAN NOT TOUCH the code in the other book as it belongs to another department. They have not specified any object variables so it means the macro is looking at my sheet.

Does Run have any parameters that you can force the macro to run in it's own book?

Is there another way I can do this?

Many thanks,

Fred!