LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 542
Default Updating links to external files using macros

Hi all

I have a file which contains links to data in an external file. Every week I
need to update the link to a new file that is created. So for example, at the
moment the link goes to a file called "Sales Firm 2010 2009-11-12", next week
there will be a new file called "Sales Firm 2010 2009-11-19" which I will
want to change this link to. The following week yet another external file
will be created which I will want to change the links to again. All the
external files are the same i.e. format, where the data is located, etc it's
just new data.

At the moment I just go into "edit" then "links" and update from there but I
want to pass this job on to other users who can just update at the push of a
button i.e. I don't want to teach them all how to update links!

Is this possible?


--
James.
 
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
Calculate *without* updating external links Stuart[_2_] Excel Programming 1 November 28th 07 03:20 PM
Updating external links Al Links and Linking in Excel 1 May 30th 06 07:41 AM
Problem with updating external links ChrisN Excel Discussion (Misc queries) 1 April 2nd 06 06:05 PM
Updating External Links DCSwearingen Excel Discussion (Misc queries) 1 January 25th 06 12:57 AM
External Links not updating Lou Di Pietro Excel Discussion (Misc queries) 0 September 15th 05 09:48 AM


All times are GMT +1. The time now is 06:26 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"