I have a macro to update links but want it to use a Wildard "Stock*.xls" when the dialog box opens
It would be appreciated if someone could kindly amend my code
Code:
Sub UpdateLinks()
ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources, Type:=xlExcelLinks
End Sub
It would be appreciated if someone could kindly amend my code