Macro to Update Links

[howard]

I have a macro to update links but want it to use a Wildard "Stock*.xls" when the dialog box opens

 Sub UpdateLinks()
      ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources, Type:=xlExcelLinks
End Sub

It would be appreciated if someone could kindly amend my code

 

[howard]

I have also posted today on link below

dialog Box Opens when running update Links Macro

When running the macro below a name dialog box Open I then select "Sales Debtors Ver 1.4.xlsm" which is the active workbook and links are updated I would like thee name "Sales Debtors Ver 1.4.xlsm" to be automatically selected instead of having to find the workbook Sub UpdateLinks()

www.excelforum.com