Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import New Database Query (Union Query) in Spreadsheet | Excel Discussion (Misc queries) | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |