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!