T
testingguy2007
I have been using Application.run for years, and all of a sudden on this
computer, it has stopped working when I open a file. Note this does not
occur on all machines for some odd reason.
Here is a code snipet.
Code_file = "stl_code.xls"
Workbooks.open FileName:=ATL_Path, ReadOnly:=True
Application.Run Macro:=Code_File & "!Stl_Init"
If I put a stop on Application.run -- and try to step through this,
application.run just never executes. It just sits there every press of
"step into". However if I just press the play button - the code eventually
gets through this, but from what I can see never runs this stl_init procedure,
as there are variable set.
I am running Excel Version 2002 (10.6823.6825) SP3.
I have run into issues like this in the past -- where long files names --
those in code_file are longer than 15 characters -- just reduced the filename
size. But this one I cannot figure out, and I cannot trap on it either.
As inidcated earlier -- it seems to work fine on another machine -- same
Excel version as indicated above.
computer, it has stopped working when I open a file. Note this does not
occur on all machines for some odd reason.
Here is a code snipet.
Code_file = "stl_code.xls"
Workbooks.open FileName:=ATL_Path, ReadOnly:=True
Application.Run Macro:=Code_File & "!Stl_Init"
If I put a stop on Application.run -- and try to step through this,
application.run just never executes. It just sits there every press of
"step into". However if I just press the play button - the code eventually
gets through this, but from what I can see never runs this stl_init procedure,
as there are variable set.
I am running Excel Version 2002 (10.6823.6825) SP3.
I have run into issues like this in the past -- where long files names --
those in code_file are longer than 15 characters -- just reduced the filename
size. But this one I cannot figure out, and I cannot trap on it either.
As inidcated earlier -- it seems to work fine on another machine -- same
Excel version as indicated above.