Skip to Content
0

SAPSETVARIABLE to pass the range

Jul 13, 2017 at 09:17 AM

69

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

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"
Share
10 |10000 characters needed characters left characters exceeded