Results 1 to 13 of 13

ChangeLink error

Threaded View

  1. #1
    Registered User
    Join Date
    07-14-2015
    Location
    Hartford
    MS-Off Ver
    Professional Plus 2010
    Posts
    3

    ChangeLink error

    I have this macro that worked last week now it does not? I am not sure what has changed

    Run-time error '1004';
    Method'ChangeLink' of object'_Workbook' failed

    code:
    Sub ChangeLink()
        
    'Changes Link to Trial Balances
        
        Dim OldLink As String
        Dim NewLink As String
        Dim ws As Worksheet
        Set ws = ThisWorkbook.Worksheets("Woodbury")
        OldLink = ws.Range("K1").Value
        NewLink = ws.Range("K2").Value
        ThisWorkbook.ChangeLink Name:=OldLink, NewName:=NewLink, Type:=xlExcelLinks
    Any ideas???
    Last edited by JBeaucaire; 07-14-2015 at 04:41 PM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 08-16-2013, 12:04 PM
  2. ChangeLink Command Not Working
    By Dina in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-23-2012, 03:57 PM
  3. ChangeLink with variable new name
    By DeeCeeL in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2012, 01:58 PM
  4. ChangeLink Name Issues
    By alex_spun in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2011, 03:11 PM
  5. ChangeLink with remote file
    By JackL in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-11-2008, 10:51 AM
  6. ChangeLink - What's wrong with following?
    By daliano71@yahoo.com in forum Excel General
    Replies: 1
    Last Post: 04-15-2006, 03:03 AM
  7. [SOLVED] ChangeLink - What's wrong with the following?
    By daliano71@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-13-2006, 11:20 AM
  8. changelink with the name and new name as strings is failing
    By whylite in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2006, 01:15 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1