VBA Changelink method returns error when variables are used.

[ash.mak]

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 returned on runtime.

this is part of macro, I use in a template. I just copy this template in the any foldery with my forecast file and when opening this template the only link in the template should search for the forecast file in current directory and change links automatically to the forecast file in this folder. Hope I am clear and not confusing.

 

[AlphaFrog]

Define the strings before using them in the .ChangeLink method.

OldLink = "D:\Ash\Planning\Forecast20130601.xls"
NewLink = "C:\Temp\Planning\Forecast20130815.xls"
    
ActiveWorkbook.ChangeLink OldLink, NewLink, xlExcelLinks