Calling Macro on another workbook!

[annanathan]

Hi All,
I need help on how to call a Macro on a workbook from another workbook. I'm using Excel 97. I think in Excel 4 we could have done something like
Application.Run Macro:="Workbook_name!macro_name"

Does anybody know how to do this in Excel 97
Thank you in advance.

 

[acron]

Try

Application.Run ("Workbook_name!macro_name&quot

A.C.

 

[annanathan]

Hi A.C.

I tried Application.Run ("Workbook_name!Macro_name&quot and it gives me a run-time error (91) saying "Object variable or With block not set.

Do you know how to fix this?

Thank you.

 

[acron]

Do you have the workbook open at the time the code is called ?.

If not you would need to set a reference to the file in the calling workbook.

A.C.