updating link command button

[tjb]

What's the code to use a command button to update links
on an Excel sheet?

I think it's something like:

Private Sub MSG_UPDATE_Click()
Application.Dialogs(xlDialogUpdateLink).Show
End Sub

but I can't figure out the rest of it.

Thanks!

 

[Dave Peterson]

Are you Joe User?



Take a look at UpdateLink in VBA's help for a nice example:

ahhh. From xl2002's help:

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources