Business Object in excel

diepvic

Guest

Posts: n/a

23rd Jun 2009

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.

« Prevent user from changing font color (Excel 2003) | Office 2003 and 2007 »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel 2003 - Business Explorer - Missing object or reference error	Mallasch	Microsoft Excel Misc	1	5th Sep 2008 02:31 PM
Passing an object to a Business Object	Andy	Microsoft ASP .NET	1	19th Aug 2008 03:24 AM
OT: What is a business object?	jehugaleahsa@gmail.com	Microsoft C# .NET	9	24th May 2008 08:31 PM
return generic object rather strongly-typed business object?	hazz	Microsoft C# .NET	4	2nd Nov 2005 01:21 AM
Object Data Source and Custom Business Object	=?Utf-8?B?S2h1emVtYQ==?=	Microsoft ASP .NET	0	27th Jun 2005 08:03 AM