Update Links

J

Joe User

I have a macro in an excel workbook. After the macro is
done I would like to update all links that are in each
sheet. What is the propper syntax for that?
 
D

Dave Peterson

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

ahhh. From xl2002's help:

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources
 
Top