calling macro from another instance of excel
Assuming the other workbook is open, you can use
Application.Run, e.g.:
Application.Run "FileName.xls!MacroName"
If it's not open, you can make a reference to it
(menu Tools | References) and call the macro that
way.
Either way, it can be risky. It depends on what the
macro does.
Hth,
Merjet
|