cancel
Showing results for 
Search instead for 
Did you mean: 

Macro that refresh a query

Former Member
0 Kudos

Hello,

I know how to write a macro that runs when i refresh the query.

Is it possible to write a macro that refresh a query?

Thank you,

David

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member215107
Active Participant
0 Kudos

Hi David,

To refresh a query with a macro:

' Open the tools bex

Workbooks.Open "C:\Program Files\SAP\FrontEnd\Bw\sapbex.xla"

' Refresh the query

Run "sapbex.xla!SAPBEXrefresh", True

Rodolphe.