View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
testingguy2007 testingguy2007 is offline
external usenet poster
 
Posts: 2
Default Application.run is not working

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.