Refreshing web report during macro execution

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • Refreshing web report during macro execution


    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)

  • 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.