Jump to content
Macro Express Forums

cdavidson

Members
  • Posts

    1
  • Joined

  • Last visited

Everything posted by cdavidson

  1. I have a macro to extract data from a program, convert the results from a pdf to excel file, then paste the information I'm interested in to another spreadsheet. Sometimes the pdf window won't activate, maybe after 20 repeats or so. I have a long enough delay, and activate window, and wait for window title which should be more than enough to bypass this issue but sometimes it just doesn't. After the macro waits for the pdf window title to appear after 10 minutes the macro aborts. Is there a way to put an IF command or use the macro in another macro so that if the macro aborts then it restarts itself? This would be helpful as sometimes I leave the macro running after I leave the office to go home and if it aborts there is no one around to restart it manually, losing hours that could have been used to extract the data. Thanks in advance!
×
×
  • Create New...