Hi all
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.
Here is where I am so far:
Set BobJ = XLApp.COMAddIns("CrystalOfficeAddins.CrystalComAddin.7").Object
BobJ.Logon "UserName","Password"
' --> SET MY PROMPT/PARAMETER HERE
BobJ.LiveObjects.Refresh
BobJ.LogOff
The post seems quite old, but if you’re still wondering how to perform this operation, have a look at this topic, you’ll see some explanations to solve your problem : Fill LiveOffice prompt with VBA (vb.NET)