Running BO 5.1.8 Reports VIA VBA Code

[elmarko123]

Hello all,

I'm writing a macro in excel VBA that runs a number of business objects reports, refreshes the data based off a reference on a spreadsheet then loops through each report saving them down.

I can get the model to effectivly open the report, refresh the report, then save the report, but i cannot get the variables to pass to the popup boxes.

Here is my code (apologies if its messy, im self taught)

****************************************

Please Login or Register  to view this content.

****************************************

Any advice of fixing the problem of passing the variables would be greatly appriciated, as then ill be able to automate my 20+ business objects querys to a singular button click on my excel spreadsheet.

NOTE : This code currently runs through without any errors, but the values do not update for the query (on the date ranges from the popup)

Many thanks,

M

[elmarko123]

Ok, ive found out the solution...., this may be usefull to others.

****************************************************************

Please Login or Register  to view this content.

********************************************