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!
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: