Skip to Content
avatar image
Former Member

SAPSETVARIABLE to pass the range

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 30 at 03:26 PM

    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"
    Add comment
    10|10000 characters needed characters exceeded