Skip to Content
0
Former Member
Dec 15, 2006 at 03:02 PM

Problem refreshing query when opening workbook in VBA

38 Views

I have a report menu in a workbook not containing any queries - only the description, technical name and additional information about the reports.

I use Run ("SAPBEX.XLA!SAPBEXreadWorkbook"), <TECHNICAL_NAME> to open the respective workbooks, which works fine.

However, if I try to refresh the query, BEx displays a message saying:

"Can only refresh this query agains a server of release 2.0 or higher: <QUERY DESTINATION RANGE>"

We're using BW 3.5!

After that, BEx is a complete mess:

- Open workbook dialog is from a previous version (without History, Favorites, Roles buttons)

- All workbooks are displayed, but if I try to open one, BEx claims that "The workbook does not exist in the document store". Then why display it, dear SAP programmers?

Now, if I disconnect and reconnect, the query can be refreshed as if I had opened the workbook directly instead of using VBA.

Our users like the idea of a report menu, so any help would be appreciated!