BusinessQuery Automation

system · July 28, 2005, 2:19pm

Hi,

We’ve had Business Query for a couple of years but have only just got around to using it (Can’t believe we left it so long, seems like an excelent piece of software).

I have two questions relating to it’s automation:

Can I use vba to automate a query to refresh when the excel do containing it opens (as part of the auto open routine)?

I believe it’s possible to use the value of a cell as a query prompt, how do i do this?

Thanks in advance for any assistance…

funkmonsteruk (BOB member since 2002-09-20)

system · July 28, 2005, 6:19pm

See this topic for the VBA stuff.

When you create a condition to read from Excel, you can either point to a specific cell (e.g., Sheet1!C2) or range (e.g., Sheet3!G3:G10) , or to a range name (e.g., EntryDates). When you choose the Operand in the condition, you select either “Select an Excel Range”, “Type an Excel Range” or “Select an an Excel Name”.

KSG (BOB member since 2002-07-17)