Skip to Content

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

populate BEx date variable dynamically from VB

Hi,

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

http://immadi.com

SEM BW Analyst

Former Member

Helpful Answer

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