renee Posted March 22, 2006 Report Share Posted March 22, 2006 I've created a macro that is 266 lines long. The macro is exactly the same except that it chooses different items from a drop down menu. Basically it opens a reports menu, goes to the particular report and prints it. If it is not available it the program throws up a dialogue box that says "report not available". I have a macro that is an if statement that makes it proceed to the next report if it gets this message. It will run fine 26 times then stalls... or acts like it has found a report and then makes the mouse moves to print it. This happens after a document is not found. There are reports not found all thru the macro. It only happens when it gets to the end. I took where it was stalling and created a new macro with just those lines of script. Again, it starts running fine. Continues thru a "not found report" and goes correctly then suddenly it stalls again. If I write a macro exactly the same and run that macro over and over again, how can this be happening? Any help would be greatly appreciated. Its making me nuts! - Renee Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.