Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Links in VBA
- Thread starter rbuttens
- Start date
Hi,
You can try the following which changes the link source of your file;
Hope this helps.
Leigh Moore
Solutions 4 MS Office Ltd
You can try the following which changes the link source of your file;
Code:
Sub ChangeLinks()
Dim strFile As String
Dim strNewFile As String
strFile = "C:\File1.xls"
strNewFile = "C:\File2.xls"
With ActiveWorkbook
.ChangeLink Name:=strFile, NewName:=strNewFile, Type:=xlExcelLinks
.UpdateLink Name:=strNewFile, Type:=xlExcelLinks
End with
End SubHope this helps.
Leigh Moore
Solutions 4 MS Office Ltd
- Status
Similar threads
- Locked
- Question
- Locked
- Helpful tip
