Take a look at the code that runs the Query......you should be able to change
it there......if not, post that section of the code and we'll take a
look......

Vaya con Dios,
Chuck, CABGx3


"Richard" wrote:

OS: XP, Excel 2000, Oracle 8-I

I have written an Excel Dashboard. I am constantly making
changes to it and need to pass it around in the office.

I store it on a shared network drive and dont have any trouble with the
Excel file, however the SQL Query file is stored on my computer and always
defaults to a path ending in the folder Queries.

I must physically go to the recipients computer and complete the process to
get it to work.

The next update to the Excel file requires starting the process over again.

How can I force the Dashboard to always look to the shared drive
for the SQL Query?

Thanks in advance.

--
Richard