LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Working with XL and another not related application Excelfan Excel Discussion (Misc queries) 6 December 21st 08 02:45 AM
Application.DisplayAlerts not working NickHK Excel Programming 0 November 15th 06 02:28 AM
Application.Run not working Lokutus Excel Programming 2 March 9th 06 08:21 PM
Working with application path Nirmal Singh[_2_] Excel Programming 3 December 15th 05 09:59 AM
application.displayalerts is not working will lam Excel Programming 2 April 30th 04 08:21 PM


All times are GMT +1. The time now is 12:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"