on 10-11-2007 2:53 PM
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
SEM BW Analyst
May be you can try this:
calculate the date, =TODAY()-1 in cell A1 and =TODAY()-2 in cell A2.
for the cell refering to your variable say V1 and V2 link these cells to A1 and A2.
here we are not calculating the veriable value by excel formula but we are linking the result of this calcualtion to variable.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
thanks for your reply.
I already tried that but it's not working.
even a macro that calculates required date with <b>no excel date format</b> and is not working (though, VB application sees this as a value but not a date).
Hari Immadi
SEM BW Analyst
i forced the cell format to be YYYYMMDD with which excel provides a value of 20071010 for BW variable, but same issue.
Hari Immadi
SEM BW Analyst
User | Count |
---|---|
75 | |
9 | |
8 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.