Remote accessing a macro

Hi Peri

Sorry for the delay in replying to this question.

As long as the book containing the required macro is open on your computer you can access all macros in it using the following syntax:

Application.Run "MacroBook!MacroName"

So a macro created in the Personal Macro Workbook can be called using the following code:

Application.Run "Personal.xls!MyGreatMacro"

The problem is that, if you then use this workbook on another computer it will cause an error as the macro won't be accessible.

Hope this helps

Carlos