Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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:

http://www.forumtopics.com/busobj/viewtopic.php?t=198349

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

BobJ.Logon "UserName","Password"

' --> SET MY PROMPT/PARAMETERS HERE

BobJ.LiveObjects.Refresh

BobJ.LogOff

'Usual Excel clean up down here

Thanks in advance.

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question