+ Reply to Thread
Results 1 to 2 of 2

changing the links from one workbook to another

  1. 03-06-2018, 10:04 PM #1
    bhupender.bhakuni
    bhupender.bhakuni is offline
    Registered User
    Join Date
    11-26-2012
    Location
    delhi
    MS-Off Ver
    Excel 2003
    Posts
    2

    Unhappy changing the links from one workbook to another

    Hello friends,
    can someone suggest me the vba code for fixing my issue below.

    I have one workbook which is linked to some other workbook. (that's the only link in this file)
    I have an active workbook as well for which I have got the full path.
    I wanted to update the first workbook link to this active workbook.

    I am using the below code
    ThisWorkbook.ChangeLink OldLink, NewLink, xlLinkTypeExcelLinks

    I have the NewLink address but I am not sure how to get the name of OldLink which is the only link this file is having.

    any suggestions?
    Reply With QuoteRegister To Reply
  2. 03-08-2018, 06:12 PM #2
    dflak
    dflak is offline
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: changing the links from one workbook to another

    This should give you the syntax you need to get current links
    Please Login or Register  to view this content.
    Attached Files Attached Files
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find the links for the message "This workbook contains links to other data sources."
    By 111StepsAhead in forum Excel General
    Replies: 24
    Last Post: 03-21-2022, 08:01 AM
  2. Need help with two issues: 1) Not updating links and 2) breaking links in workbook
    By mmayo713 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-23-2018, 11:55 AM
  3. Linking from one Workbook to another Workbook - Changing Links is Way too slow!
    By The Exceller in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-25-2016, 04:06 PM
  4. Update links to other workbook changing text in cell
    By Albermar in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-19-2015, 06:03 PM
  5. Edit Links showing links which are not in workbook
    By Bishonen in forum Excel General
    Replies: 4
    Last Post: 03-11-2013, 05:29 AM
  6. Changing Links
    By nevmorfo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-28-2006, 07:24 AM
  7. Edit Links: Changing links on a protected worksheet
    By Halibut68 in forum Excel General
    Replies: 0
    Last Post: 04-28-2006, 06:10 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1