Skip to Content
0
Former Member
Feb 17, 2009 at 09:04 AM

Setting BEx variables

13 Views

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