I have the following code to update links within the current workbook
when activating the code the folder is opened , I then need to select the workbook C:\my documents Sales report Ver 1.4.xlsm and then select sheets 'Data" to update the workbook
I would like to incorporate this workbook and sheet into my code so I do not have to select this manually
your assistance in this regard is most appreciated[/code]
Code:
Sub Update_Links
ActiveWorkbook.UpdateLink Type:=xlExcelLinks
End Sub
when activating the code the folder is opened , I then need to select the workbook C:\my documents Sales report Ver 1.4.xlsm and then select sheets 'Data" to update the workbook
I would like to incorporate this workbook and sheet into my code so I do not have to select this manually
your assistance in this regard is most appreciated[/code]