Refreshing web report during macro execution

    Refreshing web report during macro execution

    Hi

    When executing a job via macro, the demo spreadsheet returns last status ("Completed Successfully","Failed" etc.). Is there a way to indicate "Running..." until job status is returned? It seems the spreadsheet won't refresh until job execution is completed...
    (Jedox 5.1SR5, 6SR1)

    Thanks
    -Evgeni
    Hello ehasin,

    you can use a cell that includes some information about the macro's status for example.
    You can change the cell's value during macro execution to "starting", "running 30%" or "finished" for example.

    Inside the macro you can write content to the cell via

    Source Code

    1. activesheet()->range("C3")->value = "done 30%"


    Maybe this helps a bit.