SAPSETVARIABLE to pass the range

[former_member374291]

Hello Experts,

I have a requirement in the project to pass the variable for a query through the macro.

I am able to pass the single values to the query but my requirement is to pass the range i.e. From and To value to the query.

For example: i have calender year as variable and i want to pass 01012017 and 12312017 to that variable so that it gets me data between those dates.

Analysis Office - 2.4 version

[Former Member]

Hi,

Hope it is not too late...

Anyway :

lResult = Application.Run("SAPSetVariable", "SAPOBJECT", "001.2018 - 012.2018", "INPUT_STRING", "DS_1")

The range should be "VALUE1 - VALUE2"