| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change database in Excel
Hi.
I have two databases that are similar, and i have created an Excel document that imports data from one database. My problem is that i want to change the database of the document programatically. I think that creating a macro in VBA the problem is solved. But i don't know how to do it. Anyone have any idea? Thanks Catarina |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Change database in Excel
dim qt=Activesheet.querytables(1)
qt.connection = blah qt.sql = blah HTH -- AP "Catarina" a écrit dans le message de ... Hi. I have two databases that are similar, and i have created an Excel document that imports data from one database. My problem is that i want to change the database of the document programatically. I think that creating a macro in VBA the problem is solved. But i don't know how to do it. Anyone have any idea? Thanks Catarina |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
| Excel 2002 Add-in: Open Database Connectivity available for Excel | Excel Discussion (Misc queries) | |||
| Database and Excel | Excel Discussion (Misc queries) | |||
| Force format change in excel | Excel Worksheet Functions | |||
| Open Access Database under and Excel window using a Macro | Excel Worksheet Functions | |||
Hybrid Mode
