taigovinda
Well-known Member
- Joined
- Mar 28, 2007
- Messages
- 2,639
Hi,
I'm trying to automate Bex 7 with pretty much no success. I can log in and refresh a sheet, but I need to be able to change variable values in order to make the 'rubber meet the road' ...
I see that the bexrepositorysheet has xml attached to it and am guessing that I can change my variables by editing this xml. What I'd like to do is access that XML and change '20110315' so that it says something else (e.g., '20110310'). I think that if I do this, then refreshing my query will get the data that I want.
Does anyone know how to use vba to edit that sheet's xml? So far the only thing I've seen in a lot of time spent trying to figure this out is this:
...from here: http://forums.sdn.sap.com/thread.jspa?threadID=1708058
Any help would be appreciated - thanks!
Tai
I'm trying to automate Bex 7 with pretty much no success. I can log in and refresh a sheet, but I need to be able to change variable values in order to make the 'rubber meet the road' ...
I see that the bexrepositorysheet has xml attached to it and am guessing that I can change my variables by editing this xml. What I'd like to do is access that XML and change '20110315' so that it says something else (e.g., '20110310'). I think that if I do this, then refreshing my query will get the data that I want.
Does anyone know how to use vba to edit that sheet's xml? So far the only thing I've seen in a lot of time spent trying to figure this out is this:
Code:
XMLScript = Worksheets("BExRepositorySheet").Scripts(1)
Debug.Print XMLScriptAny help would be appreciated - thanks!
Tai
