ExcelBanter - running a Database Query

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - running a Database Query (https://www.excelbanter.com/excel-programming/287907-running-database-query.html)

Tom S[_3_]

running a Database Query

XP Home
Excel 2002

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

Tom S.

K. Dales

running a Database Query

-----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.

.

Look in Excel VBA Help under QueryTables Collection - the
basic form is:
Sheets("SheetName").QueryTables("TableName").Refre sh
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).

All times are GMT +1. The time now is 05:09 AM.