Dear community,
does any one of you have an idea how to display status updates to a user during long running macros?
Simple example of what I want to reach:
activesheet()->range('B10')->value ='Copy Process Running..';
$id = integrator_start_job('MyProject','CopyJob',$variables, true);
activesheet()->range('B10')->value =''; //Delete Status Message after Job is finished
In this example an ETL job is started. Before start I want to set a message into a status cell and delete the message afterwards.
Such logic I need for all kind of long running processes (not only ETL jobs) and it might contain several different status steps / messages.
The problem seems to be that during the macro run the spreadsheet is not updated - only at the end of the macro the changes become visible to the user.
Did you experienced the same things? Did I oversee something? Is there a solution / workaround for that?
Thanks a lot for your help
JCO
does any one of you have an idea how to display status updates to a user during long running macros?
Simple example of what I want to reach:
activesheet()->range('B10')->value ='Copy Process Running..';
$id = integrator_start_job('MyProject','CopyJob',$variables, true);
activesheet()->range('B10')->value =''; //Delete Status Message after Job is finished
In this example an ETL job is started. Before start I want to set a message into a status cell and delete the message afterwards.
Such logic I need for all kind of long running processes (not only ETL jobs) and it might contain several different status steps / messages.
The problem seems to be that during the macro run the spreadsheet is not updated - only at the end of the macro the changes become visible to the user.
Did you experienced the same things? Did I oversee something? Is there a solution / workaround for that?
Thanks a lot for your help
JCO