On Feb 20, 9:42 am, "Karti" wrote:
I have two worksheets on different servers and because they have links
you are asked to update the links before you continue.

Is there a way to use VBA to automatically update this link without
the message window opening up?

I need to remove the message window because it confuses my users!

Any and all help is appreciated!

Regards

Karti
;)

create an OpenWorkbook() macro that sets UpdateLinks:=1 when the
workbooks open...

-thatdude