cyberchief Posted October 4, 2007 Report Share Posted October 4, 2007 I am trying to create a extremely simple macro. Launch an excel file and navigate a couple options. Problem is that the excel file is incoded with macros and coding. I am using the program launch command. But it appears that macro sits and waits for the window title... but the excel document is programmed to prompt a user with a yes/no option box (run the imbeded excel macro or not). Macro will not continue running due to the fact that the excel file has not fully launched. The purpose of the macro I am building in ME is to select one of the options in that prompt box. But, again, ME sits and waits for the excel file. Anyone know of a way around this? To get macro to NOT wait for the file? Basically to blindly launch it? Quote Link to comment Share on other sites More sharing options...
Cory Posted October 5, 2007 Report Share Posted October 5, 2007 Try Launch Program Only. I think that without a window title it won't wait for it. Then you can wait for a control in the popup box or whatever. And if Excel is already open it will just open to that instance of Excel. Quote Link to comment Share on other sites More sharing options...
cyberchief Posted October 5, 2007 Author Report Share Posted October 5, 2007 Try Launch Program Only. I think that without a window title it won't wait for it. Then you can wait for a control in the popup box or whatever. And if Excel is already open it will just open to that instance of Excel. I was trying that yesterday before I posted this, but no go. Still didn't work. I created a work-around by activating the start/run command and using text type with the full file path. That will work I guess. Quote Link to comment Share on other sites More sharing options...
floyd Posted October 5, 2007 Report Share Posted October 5, 2007 Have you tried setting the Continue Macro choice on the Advanced tab of the "Activate/Launch Program" dialog? Quote Link to comment Share on other sites More sharing options...
Cory Posted October 7, 2007 Report Share Posted October 7, 2007 Dude, I've never noticed that before! Kewl. I knew I hung around here for a reason, learn something new every day! UDa Man Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.