Live Office Macro to refresh with prompts?
I've seen this asked a few time on here over the past several years but no answer. So thought I would give it a shout again.
I've been using code very simillar to the code here:
which has been great for refreshing live office dahsboards.
But is there a way to automate if the dasboard is built off of Web Intelligence that has prompts? For example, when I refresh All Objects I get the prompt to select periods. I'd like to supress this. Any examples/documenation or point me to a specific part of the COM object would be great.
Here is where I am so far. The problem is that when it refreshes the the prompt window displays. I'd like to autmate that.
' Usual Excel code for declaring, opening, ect......
Set BobJ = XLApp.COMAddIns("CrystalOfficeAddins.CrystalComAddin.7").Object
' --> SET MY PROMPT/PARAMETERS HERE
'Usual Excel clean up down here
Thanks in advance.