running a Database Query

  • Thread starter Thread starter Tom S
  • Start date Start date
T

Tom S

XP Home
Excel 2002

How can I force a Database Query, that's already been written, to run when
specified using VBA?

Tom S.
 
-----Original Message-----
XP Home
Excel 2002

How can I force a Database Query, that's already been written, to run when
specified using VBA?

Tom S.


.
Click to expand...

Look in Excel VBA Help under QueryTables Collection - the
basic form is:
Sheets("SheetName").QueryTables("TableName").Refresh
Where SheetName is the name of the worksheet containing
the query results and TableName is the name of the Query
Table Range (i.e., what you see when you look at the Query
Properties).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refresh an Access Query using VBA code in Excel 6
Link, drop link, relink 2
Update MySQL database using Excel VBA 1
Parameter Driven Query 10
Trouble Installing Excel VBA Code Cleaner into Office 365 0
2003 vs 2007 2
query external database 5
Query from Access Database based on user selected parameters in Excel 2

Back
Top