| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find internal connection
I've got an excel sheet that has a connection to an external source.
However, I have the wrong DSN, apparently on my machine. No one in my department remembers the DSN name, etc..... How can I go into an excel workbook and find out what connection is supposed to be there, in order, to fix it on my system? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to find internal connection
go to a person who has a working connection and check its parameters.
-- Regards, Tom Ogilvy "Trust Me; I'm from the government" wrote: I've got an excel sheet that has a connection to an external source. However, I have the wrong DSN, apparently on my machine. No one in my department remembers the DSN name, etc..... How can I go into an excel workbook and find out what connection is supposed to be there, in order, to fix it on my system? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to find internal connection
the point is - this is a sheet that's been newly resurrected, and no one we
know, in our group has a working connection "Tom Ogilvy" wrote in message ... go to a person who has a working connection and check its parameters. -- Regards, Tom Ogilvy "Trust Me; I'm from the government" wrote: I've got an excel sheet that has a connection to an external source. However, I have the wrong DSN, apparently on my machine. No one in my department remembers the DSN name, etc..... How can I go into an excel workbook and find out what connection is supposed to be there, in order, to fix it on my system? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to find internal connection
msgbox Activesheet.QueryTables(1).Connection
-- Regards, Tom Ogilvy "Trust Me; I'm from the government" wrote: the point is - this is a sheet that's been newly resurrected, and no one we know, in our group has a working connection "Tom Ogilvy" wrote in message ... go to a person who has a working connection and check its parameters. -- Regards, Tom Ogilvy "Trust Me; I'm from the government" wrote: I've got an excel sheet that has a connection to an external source. However, I have the wrong DSN, apparently on my machine. No one in my department remembers the DSN name, etc..... How can I go into an excel workbook and find out what connection is supposed to be there, in order, to fix it on my system? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Connection to SQL 2007 can't find stored procedure message | Excel Discussion (Misc queries) | |||
| always recheck data connection library for latest connection strin | Excel Discussion (Misc queries) | |||
| find internal links in mutliple spreadsheets? | Excel Discussion (Misc queries) | |||
| Internal links | Excel Programming | |||
| Find the contents of a Connection property of the QueryTable objec | Excel Programming | |||
Linear Mode
