I have the following macro to update link, but when running this macro it opens up the folder and I need to then select the workbook
I would like to incorporate the workbook within the code so I do not have to search for the workbook and click on it in order for the links to be updated
The workbook is in C:\my documents and called "Sales Report Ver 1.1.xlsm"
Your assistance is most appreciated
I would like to incorporate the workbook within the code so I do not have to search for the workbook and click on it in order for the links to be updated
The workbook is in C:\my documents and called "Sales Report Ver 1.1.xlsm"
Code:
Sub UpdateLinks()
ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources, Type:=xlExcelLinks
End Sub
Your assistance is most appreciated