LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
DuncanG
 
Posts: n/a
Default Moving / Sharing excel files with queries


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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import data from files with different names to EXCEL D'base. thunderfoot Excel Discussion (Misc queries) 2 June 10th 05 11:05 AM
Automatically opening several Excel Files at startup Peo Sjoblom Excel Discussion (Misc queries) 0 June 8th 05 05:20 PM
Making files with excel Mike C Excel Worksheet Functions 1 March 18th 05 06:15 PM
sharing/using/saving Excel 2002 files in Excel 2003 maze2009 Excel Discussion (Misc queries) 0 January 20th 05 07:27 PM
Why do my links break when I burn multiple Excel files to a CD? akrr-rasmussen Excel Worksheet Functions 1 November 17th 04 02:39 AM


All times are GMT +1. The time now is 02:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"