Sapbex refresh

[Aviad]

Hello..

Today if i want to refresh a sap bex query in my excel file i need to go to the bex "add in" and click on the "refresh".

Is it posiblle to create a butten than have asighned macro that can refresh the query without enforcing me to go to the relevant "add in" ?

in the past i tried to write code as "sapbex.refresh" but it didn't work..
(i'm using excel 2010).

Thanks,
Aviad

 

[Aviad]

Anyone ? (-:

 

[Jon von der Heyden]

What version of Excel are you using? I only ever used it with Excel 2003.

I used to run it with something like:

Application.CommandBars.FindControl(ID:=[COLOR="Red"]###[/COLOR]).Execute

You need to know the ID or caption of the control though, and this assumes you are not running excel 2007+.

EDIT: Just noticed you are on 2010. I will post back when I work out how...

 

[Aviad]

Thanks!

I'm waiting for the answers.. (-:

meanwhile i think that the first answer might work in 2010 also.. how can i find the command ID ?

Aviad

 

[Aviad]

anyone ?