BusinessObjects Board

Live Office Macro Refresh w/ Prompts

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" 



dermotcarey (BOB member since 2014-09-18)

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)

djikstra :fr: (BOB member since 2004-03-23)