| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference a VBA Query from Access
That was exactly what I was looking for. Thanks
"Tim" wrote: Try setting BackgroundQuery to False for the querytable. Tim "Andy" wrote in message ... In one macro I would like to get external data from Access, and use that data. I am able to perform an Access query on its own, but it doesn't seem to update until the macro is finnished. This means that I cannot reference the data the I am calling. While the macro is running (and the external data have not come yet) there is a message: ExternalData_23: Getting Data... Is there a way to force the external data to come in before the program moves on. Here is the basic structure of the macro (varConn and varSql are strings that have connection and SQL information). Sub query() Dim varQuery As QueryTable Set varQuery = ActiveSheet.QueryTables.Add(Connection:=varConn, Destination:=Sheet1.Range("A1"), Sql:=varSql) varQuery.Refresh Dim i As Integer i = 2 Do Until Sheet1.Cells(i, 1) = "" 'Do Something Loop End Sub Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query from Access into Excel cause Access to go to read only | Excel Discussion (Misc queries) | |||
| Can I use MS Query in Excel like an Append Query in Access | Excel Discussion (Misc queries) | |||
| Run Access query from Excel, input value to query being value in c | Excel Programming | |||
| Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Hybrid Mode
