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