Run a macro in another file

[sdear]

Is it possible for a macro to open a file on a network drive & then run a macro attached to it?
I.e., I run Macro1 from my Daily.xlsm file, which opens K:\Daily\Daily1.xlsm & then run Macro2 from that file.

I'm assuming the macros would need to be separate names (hence the Macro1/Macro2 above).

Thank you in advance.

Excel 07

 

[tlowry]

   Workbooks.Open "c:\temp\abc.xls"
    Application.Run "abc.xls!macro2"

 

[sdear]

That's beautiful.
Thank you very much