How can you set up the search to look in CURRENT directory where the EXCEL
workbook you are using is located?

If you put an workbook on a shared server, the queries assocated should be
located with it. The workbook should know to look there and use that. Not
something maybe but probably not located somewhere on someones C drive.

MS please stop forcing all files, documents, workbooks, queries etc into
unknown unwanted folders when the associated files are located somewhere else
or on a netdrive.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...ic.excel.setup