changelink

  1. D

    ChangeLink in Workbook

    I'm having a minor but annoying hiccup on a patch of code. I have cobbled it together from various googlings, but it doesn't function. The goal is to select a file and then to replace the existign file link with the new file selected. If replace 'ExistingLink' in the last line of code and...
    • dsl145
    • Thread
    • changelink link between workbooks link sources xlexcellinks
    • Replies: 0
    • Forum: Excel Questions
  2. A

    VBA Changelink method returns error when variables are used.

    Hi ALL. I am getting method failed error when running the following; ActiveWorkbook.ChangeLink OldLink, NewLink, xlExcelLinks OldLink = "D:\Ash\Planning\Forecast20130601.xls" NewLink= "C:\Temp\Planning\Forecast20130815.xls" OldLink and NewLink are string variables. They compile OK but error...
  3. D

    Edit Link Macro - Run-time Error

    Hello, I am trying to create a macro that will allow me to change the source file everytime I want to view a specific account. I scoured the web to find out how to do this and here is the code I've written Option Explicit Sub EditLink() Dim OldLink As String Dim NewLink As...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top