Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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.

Hari Immadi

SEM BW Analyst

Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question