Update linked cells from another workbook with a Macro

[kitackers]

I've trawled through the internet and cannot find anything on this at all.

All I'm after is a macro that will update linked cells once fired, rather thatn having to close a workbook, then open it again, updating the links when prompted!

Anyone got anything?

 

[SkipVought]

Hi,

Check out the UpdateLink Method in VBA Help.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[kitackers]

Much appreciated