Business Objects Data Provider Edit

xVikesh

New Member
Joined
Nov 27, 2014
Messages
9
Hello,

I am operating Business Objects from an excel spreadsheet using VBA. I have managed to get to the stage of opening BO, logging in, opening a report and then opening the query panel (data provider) as shown below.





However, how do I edit the data provider from VBA. For example, if I wanted the product code to equal the value of a certain cell within the spreadsheet. Or the start date to again equal a value from cell A1 in my spreadsheet, I am absolutely flummoxed on this situation so any help would be great!

Thank you!
 
Last edited:

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Watch MrExcel Video

Forum statistics

Threads
1,118,121
Messages
5,570,303
Members
412,318
Latest member
angoeyuan
Top