Although very new to this program, I am finding it quite fantastic and the opportunities for its use seem endless.
I am wanting to use ME to; open an Excel spreadsheet, run recalculation then save the result, rename, and send email. All is fine except the Excel recalculation can vary in the time (1 to 5 minutes) it takes to finish, so ME can sometimes start the next step before the Excel recalc has finished.
I have tried "wait until file is ready" although I suspect this is not the correct method especially as it doesn't work. I wasn't too keen on setting the waiting time as a set period, as I would have to set this for too long to be sure.
Any suggestions and/or advice very much appreciated.
Waiting For Excel Recalculation
in Macro Express 3.x
Posted
Although very new to this program, I am finding it quite fantastic and the opportunities for its use seem endless.
I am wanting to use ME to; open an Excel spreadsheet, run recalculation then save the result, rename, and send email. All is fine except the Excel recalculation can vary in the time (1 to 5 minutes) it takes to finish, so ME can sometimes start the next step before the Excel recalc has finished.
I have tried "wait until file is ready" although I suspect this is not the correct method especially as it doesn't work. I wasn't too keen on setting the waiting time as a set period, as I would have to set this for too long to be sure.
Any suggestions and/or advice very much appreciated.
Thanks in advance.