| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Business Object in excel
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Business Object in excel
diepvic wrote:
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Business Object in excel
diepvic wrote:
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. 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating 10 Business Days from the Last Business Day of the Mon | Excel Worksheet Functions | |||
| Excel 2003 - Business Explorer - Missing object or reference error | Excel Discussion (Misc queries) | |||
| BUSINESS DAYS - Need function that will list next 3 business days. | Excel Programming | |||
| WHERE CAN I GET A BUSINESS PROPOSAL OR A BUSINESS EXPENSE SHEET? | New Users to Excel | |||
| Confusion about how the Window object fits into the Excel object model | Excel Programming | |||
Hybrid Mode
