populate BEx date variable dynamically from VB
We've a requirement to use SAPBEXsetVariables from within VB to automate a workbook that needs to run on dialy basis & this is on BW 3.0.
Everything works perfect except variables can't be populated dynamically.
As pete mentioned in other thread, on sheet2, I created variables range & running the workbook that needs to 2 variables and these are always "current date-1" & "current date-2"
If i hardcode values like '20071010 & '20041009 which are of format (number stored as text), it works great.
but, if i include excel formulas like today()-1 & today()-2 error message is coming with " Variables Contain Invalid Values"
Is there a way, I can get this workbook working with formulas to have dynamic values populated to BEx variables.
Appreciate your help.
SEM BW Analyst