running macro from another excel

[rnl0085]

i have two large excel files open, in seperate excel windows / versions because of the high load of the files and possibilities of crashing and then not losing the other file.

but i was wondering..is it possible to run a macro from one file by a macro in the other (and then copy some values from one file to the other). normally i would use Application.Run (filename & "!macroname") but this doesn't seem to work because the file is openen in another excel.

does anyone have another solution for this problem?

 

[Andrew Poulsom]

You won't be able to copy/paste between workbooks that are in different instances of Excel. Formulas and formatting won't be preserved.

 

[rnl0085]

also not by using a macro? by setting some numbers in a variable..

but i only have to reach the other instance of excel through the macro from the other instance

 

[Andrew Poulsom]

If you can't do it maunually you can't do it with a macro.