Results 1 to 2 of 2

Changing Multiple Links with VBA

Threaded View

  1. #1
    Registered User
    Join Date
    04-26-2011
    Location
    New Orleans, LA
    MS-Off Ver
    Excel 2011
    Posts
    13

    Changing Multiple Links with VBA

    Hello,
    I have 60 workbooks, each containing 16 charts and each linked to the same 17 workbooks. There is a separate workbook for each chart and the 17th workbook is used for naming purposes. I have duplicated these 60 workbooks for another project. The second project has a different set of 17 workbooks, so i have been opening each of the 60 workbooks individually and changing the links. I was wondering if it is possible to write a macro to change all 17 links. I have researched it, but i could not figure out how to specify the old link that needs to be changed.
    Last edited by TSMIII; 07-18-2011 at 09:02 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1