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!

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!

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!