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.