Business Object in excel

D

diepvic

Hi,
I'm using Business Objects (BO) as an add-in in excel.
I create a refresh macro so that the BO query will be updated to the date I
key in.

'Refresh BO'
Windows("BO Queries.xls").Activate
Sheets("Data1").Select
Application.Run ("BQ_UpdateWorkbook")

I have 5 queries to be updated with the same date (Data1 to Data5). However,
I just want to type the date once only. Does anybody help me with a macro to
meet this requirement?

Thanks so much.
 
S

smartin

diepvic said:
Hi,
I'm using Business Objects (BO) as an add-in in excel.
I create a refresh macro so that the BO query will be updated to the date I
key in.

'Refresh BO'
Windows("BO Queries.xls").Activate
Sheets("Data1").Select
Application.Run ("BQ_UpdateWorkbook")

I have 5 queries to be updated with the same date (Data1 to Data5). However,
I just want to type the date once only. Does anybody help me with a macro to
meet this requirement?

Thanks so much.
Click to expand...
 
S

smartin

diepvic said:
Hi,
I'm using Business Objects (BO) as an add-in in excel.
I create a refresh macro so that the BO query will be updated to the date I
key in.

'Refresh BO'
Windows("BO Queries.xls").Activate
Sheets("Data1").Select
Application.Run ("BQ_UpdateWorkbook")

I have 5 queries to be updated with the same date (Data1 to Data5). However,
I just want to type the date once only. Does anybody help me with a macro to
meet this requirement?

Thanks so much.
Click to expand...

You might have better luck in a Business Objects group. E.g.

http://www.forumtopics.com/busobj/index.php

Does the BQ_UpdateWorkbook method have any way of accepting a parameter
to pass to the BO query prompt?
 
Top