Live Office Macro Refresh w/ Prompts

[system]

Hi all
I’ve been using code very simillar to the code here:

Live Office Auto Refresh via VBA

I know some others have already come up with the “one line of code” that does this “refreshing of a document” using Live Office with Microsoft Office 2003 but as I discovered during a recent customer visit this platform is becoming fast obsolete and many people need another solution. Therefore I attach the following 2 spreadsheets in the attached ZIP archive file which are based on the Efashion universe which allow the user to refresh a Live Office report using a VBA macro. Instead of using th…

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

---

dermotcarey (BOB member since 2014-09-18)

[system]

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 (BOB member since 2004-03-23)