| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using ado db connection in different workbook
Is it possible to use an ADO connection that has been established in one
workbook in another workbook? Simplified the connection has been set like this: Public ADOConn As ADODB.Connection Sub CreateADOConnection() If ADOConn Is Nothing Then Set ADOConn = New ADODB.Connection End If End Sub And in another Sub: strConn = "DSN=System 6000;" & _ "UID=" & Username & ";" & _ "PWD=" & Password ADOConn.Open strConn Thanks for any advice. RBS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to store a connection with parameters into a workbook | Excel Discussion (Misc queries) | |||
| reconnecting a workbook connection from Access-Excel | Excel Discussion (Misc queries) | |||
| Pivot chart loses data connection when copied to new workbook | Charts and Charting in Excel | |||
| how do i directly edit a connection string in an Excel workbook q. | Excel Programming | |||
| Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming | |||
Threaded Mode
