| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
And the answer is ... MaintainConnection
I seem to have things working now.
The MaintainConnection property of QueryTable lets my people go. Here is the code that ultimately did the trick: With Selection.QueryTable .Connection = MyConnectString1 & Range("Folder") & Range("FileName") & MyConnectString2 .CommandType = xlCmdSql .CommandText = Array(SqlStatement) .MaintainConnection = False .Refresh BackgroundQuery:=False End With |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Start Excel in Text Import Wizard for data import | Setting up and Configuration of Excel | |||
| Import external data, data includes Excel function | Excel Worksheet Functions | |||
| Import Data / Edit Data / Export Data in Excel | Excel Programming | |||
| PLEASE!! How can I un-grey the 'Data-Import External Data-Import Data' option ??? | Excel Programming | |||
| how to Import data in excel office2003 with data more 65000 rows | Excel Worksheet Functions | |||
Hybrid Mode
