LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
dac dac is offline
external usenet poster
 
Posts: 4
Default Need Help! Need to Change Linked Source on Several Workbooks.

May need some expert or advanced help here. But this would save me a
tremendous amount of down time.

I have to update links for about 650 workbooks, each workbook is linked to
the same master workbook. The current master workbook is now dated and the
650 workbooks need to be linked to the new master workbook. (Both the new &
old master workbooks are setup same.)
Since all of the workbooks that need to be updated are in the same folder, I
would like a macro that can help automate the process by:
1. Go into this folder and open each workbook (one at a time)
2. Select edit links under the data tab, change its source from the old
master workbook to the new master workbook (which should update my links).
3. Save the updates.
4. Close the file and repeat the process on the next workbook.
5. End the process once it has reached the final workbook.
I would probably group the workbooks into 6 separate folders so I can
perform this process one batch at time and not all 650 at once.

 
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
Linked Workbooks - change in file location MeMe Links and Linking in Excel 1 January 6th 10 08:12 AM
How to change linked source Worksheet K[_2_] Excel Programming 2 April 30th 09 03:53 PM
Change source of linked database query Rob Excel Discussion (Misc queries) 1 September 24th 08 07:17 PM
Linked Workbooks - How to Allow for Growth in source books? Cat[_2_] Excel Programming 2 November 16th 05 05:34 PM
How to change (Excel) source of all linked objects in a word docu. Wheelwater Excel Discussion (Misc queries) 1 April 23rd 05 12:17 PM


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