Please can someone help!

I have a spreadsheet (Excel 2003) that has a number of queries for
sorting data in it. The problem is..........this spreadsheet has been
compiled for use by others. When this file is installed on their
machines - the queries need to be "pointed" to the location of this
file. Is there a way to do this automatically - possibly with VBA code?


Thanking you in advance,

Duncan Glynn :)


--
DuncanG
------------------------------------------------------------------------
DuncanG's Profile: http://www.excelforum.com/member.php...o&userid=16398
View this thread: http://www.excelforum.com/showthread...hreadid=473698