Variable Values through VBA

[Former Member]

What is object name in VBA to get query variable values? Is it possible at all?

[Former Member]

Hi,

I am not sure why you would want to do this in VBA, since you can turn on the Display for the Variables and it will show up with your Query.

But having said that here is the 3.5 VBA API

Run "SAPBEX.XLA!SAPBEXshowTextElements", "V"  

Hope this helps

Datta.

[Former Member]

Hi,

To get the variable values using vba code ....

try "SAPBEX.XLA!SAPBexGetData"

Thanks

Edited by: RAJESH DAS K on Sep 26, 2008 9:24 AM

[Former Member]

I tried to put varibale info into Sheet.Cell(2,2) range :

Run "SAPBEX.XLA!SAPBEXshowTextElements", "V" , Sheet.Cell(2,2)

but it didn't work

[Former Member]

Hi,

I am, not sure why you have the function run there but here is the correct syntax and some help comments.

Function SAPBEXshowTextElements(Optional selectGroup As String, Optional atCell As Range) As Integer

u2022 Use this to automate documentation of query in the workbook.

u2022 Return value of zero indicates that no errors were encountered. Otherwise, function returns number of errors encountered.

u2022 If atCell is not specified, the active cell is used to determine which query to return Text Elements for.