billblinn Posted June 8, 2007 Report Share Posted June 8, 2007 Earlier I asked about handling exceptions, but I guess that was a question without an answer. I may now have the answer, but the answer has generated another question. I have a macro that needs to poll data from about 100 retailers. If the process fails on retailer 99, the macro would start with retailer 1 on the next run. So now I think I might operate it this way: A scheduled macro creates a text file containing the number 1. A second scheduled macro opens the file that contains 1 and stores that to a variable. The macro then opens a CSV file with information about all 100 retailers. The macro processes the information for the first retailer. Before stopping, the macro updates the file with the counter to 2. As soon as the second macro finishes, I want it to start again on the next iteration. There must be an easy way to do this, but I don't see it. Hoping this third question is the one that will attract an answer .... Thanks! 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.