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