| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i directly edit a connection string in an Excel workbook q.
i need to edit a connection string due to a corporate change in servers.
this change does not allow the query editor(s) to open the query through the standard Excel defaults. i'm hoping someone will know a way to edit the connectstring. thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i directly edit a connection string in an Excel workbook q.
The QueryTable.Connection property contains the connection string; I have
never tried changing the connection db this way but it should be possible, I would go into the immediate pane and try this: ? Sheets("SheetName").QueryTables(1).Connection - to see what the current string looks like Sheets("SheetName").QueryTables(1).Connection = "... " To reset the connection parameters "SteveCarlston" wrote: i need to edit a connection string due to a corporate change in servers. this change does not allow the query editor(s) to open the query through the standard Excel defaults. i'm hoping someone will know a way to edit the connectstring. thanks! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how do i directly edit a connection string in an Excel workboo
Thanks,
this did allow me to reconnect. this allowed almost all queries to run again. the only one that didn't just needed to be relinked. "K Dales" wrote: The QueryTable.Connection property contains the connection string; I have never tried changing the connection db this way but it should be possible, I would go into the immediate pane and try this: ? Sheets("SheetName").QueryTables(1).Connection - to see what the current string looks like Sheets("SheetName").QueryTables(1).Connection = "... " To reset the connection parameters "SteveCarlston" wrote: i need to edit a connection string due to a corporate change in servers. this change does not allow the query editor(s) to open the query through the standard Excel defaults. i'm hoping someone will know a way to edit the connectstring. thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I edit directly in a cell - previously F2 | Excel Discussion (Misc queries) | |||
| Pivot4U Excel Add-in - Edit Pivot Tables in Excel Directly | Excel Discussion (Misc queries) | |||
| edit directly in cell in Excel 2007 | New Users to Excel | |||
| Hiding an SQL connection string in an Excel macro | Excel Programming | |||
| ado connection string for excel 2002 | Excel Programming | |||
Linear Mode
