Hi, I've managed to create a system by which I can start-up a new session of Excel and have it open a file. When the file is loaded I execute a macro in that file. Thanks to member of this site who gave me most of the code required to do this! I have several of these that I "invoke" from a "central / control" workbook. They all work fine except one. The one that doesn't work contains:
...
debug.assert False
Range("A1").Select
...
The debug statement breaks me into the code after the remote invocation. However the Range selection statement does nothing. After this statement there is a sequence that should be copying and pasting some info... none of it executes. The debugger happily shows each statement as being executed, but nothing happens.
If I open this file manually and execute the macro... it works properly!!!
Any ideas??
Thanks in advance,
Vesc
...
debug.assert False
Range("A1").Select
...
The debug statement breaks me into the code after the remote invocation. However the Range selection statement does nothing. After this statement there is a sequence that should be copying and pasting some info... none of it executes. The debugger happily shows each statement as being executed, but nothing happens.
If I open this file manually and execute the macro... it works properly!!!
Any ideas??
Thanks in advance,
Vesc
