Cory Posted March 3, 2007 Report Share Posted March 3, 2007 Again I’m being lazy here and asking if anyone has a solution for me before I burn up too many brain cells thinking of a solution. I have several macros that repetitively plow thru thousands of records or files in a program extracting data. ME excels at this. Normally they run pretty smooth but often I have to baby sit them as something like 1 in 100 bomb out for unknown reasons. It’s only been a mild inconvenience and I usually structure my macro so that I can easily restart it from where I left off. But it annoys me and I would like to handle this better. Now the kind of advice I’m looking for is broad in scope and generalized and would focus on how to design the program than technicalities. I have many things like this but I’ll make a simple example. My client uses some government form software and I find a need sometimes to manually extract a bunch of records. Unfortunately the software vendor’s QC is scary and the export facility is broken and they don’t seem to have much interest in fixing it. Now I use timing commands like Wait for Window and Wait for Control but once in a blue moon it fails. The window or control pops right up and for whatever reason ME doesn’t see it. So after 20 seconds of displaying the window or whatever it bombs out. The problem is now the macro is still running and doing nothing. If it errors I would like to be able to do something like send me an SMS message or maybe even close the record and reopen. But the only thing ME will do is display the error box. I’ve thought of a couple of solutions but they’re ugly, add a lot of complexity and usually slow the run tie down a lot. So if anyone has an idea of how better to deal with this I would love to hear it. 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.