I'm trying to determine range of a result area in a 2004s query using the following code :
Dim myrange As Range
Set myrange = Run("BEXAnalyzer.xla!SAPBEXgetResultRangeByID", "ZSKMILESTONESTEST")
I have also tried this using the technical ID of the query as in RZSCOMPDIR.
This causes a VB error and stops inside the SAPBEXgetResultRangeByID function and says "Object Variable or with block not set" on this line :
Set SAPBEXgetResultRangeByID = pAddin.SAPBEXgetResultRangeByID(ActiveWorkbook.Name, queryID, charName)
Can anyone help ?