Long Shot !!
 

I suspect this isn't possible...but you never know!

I have a lot of Excel reports which use the results of SQL server
queries as their input data.
Using the ADO in VBA, or Excel's import external data, are not viable
options as the queries can take 2hrs to run.

So I have hyperlinks to the .sql files, and go into SQLServer, and set
the query running manually.

Unfortunately we have 7 or 8 servers, so I'm always having to "change
the connection" just after pressing the hyperlink, as SQLServer
doesn't know which server the query should be connected to.

Is there a way of adding some code so that each Hyperlink will know
which Server to connect to ?

Any help much appreciated,
Jason.

Long Shot !!
 

You may be able to do something with an event tied to a Worksheet_Follow
Hyperlink event. You can read more about events here

http://www.mvps.org/dmcritchie/excel/event.htm

The FollowHyperlink is found here
http://www.mvps.org/dmcritchie/excel/event.htm#ws_fh

Barb Reinhardt




"WhytheQ" wrote:

I suspect this isn't possible...but you never know!

I have a lot of Excel reports which use the results of SQL server
queries as their input data.
Using the ADO in VBA, or Excel's import external data, are not viable
options as the queries can take 2hrs to run.

So I have hyperlinks to the .sql files, and go into SQLServer, and set
the query running manually.

Unfortunately we have 7 or 8 servers, so I'm always having to "change
the connection" just after pressing the hyperlink, as SQLServer
doesn't know which server the query should be connected to.

Is there a way of adding some code so that each Hyperlink will know
which Server to connect to ?

Any help much appreciated,
Jason.