Run a macro from a workbook on an other workbook

[plans]

Hello,

- I have a macro called "MacroInMain" which resides in a module of a macro enabled workbook called "Main.xlsm".

- I have an open Excel File called MyFile.xls.

- I want the "MacroInMain" to perform a task in MyFile.xls, say write the value "test" in cell A1 of the activesheet.

Any ideas?

Thanks

[Artik]

Please Login or Register  to view this content.

Artik

[plans]

Artic,
Thanks for looking into this;
The code you are suggesting, will write the "test" into the "Main.xlsm" file.
I am trying to activate somehow the other file called "MyFile.xls" and write that value into there.
FYI

Thanks

[Artik]

Please Login or Register  to view this content.

Artik

[plans]

Thank you Artik!