Hi !
I want to create several worksheets in BEx each with a different query. I want to run these different queries with the same variables, one of which I want to calculate automatically (based on the date the report is run).
Is there a way I can automatically set the variables in the queries either directly from values in excel cells or via visual basic ?
Thanks in advance,
Richard