Am simply looking for the code to update all linked workbooks as listed in
the Edit Links dialog box.

Am able to automatically open them, and then close them.
But once they're closed, need the sub-routine to Update [all] Links.

This should be simple, but have made many attempts to no avail.

Does anyone have the solution?

Thanx,
- Mike

Look at VBA's help for UpdateLink

MikeF wrote:

Am simply looking for the code to update all linked workbooks as listed in
the Edit Links dialog box.

Am able to automatically open them, and then close them.
But once they're closed, need the sub-routine to Update [all] Links.

This should be simple, but have made many attempts to no avail.

Does anyone have the solution?

Thanx,
- Mike

--

Dave Peterson

Actually found the same via Google, after an hour of searching.
Stumbled on it though. My problem was searching for "UpdateLinks", in plural.

Nevertheless Dave, thanx, that was exactly it.

- Mike

"Dave Peterson" wrote:

Look at VBA's help for UpdateLink

MikeF wrote:

Am simply looking for the code to update all linked workbooks as listed in
the Edit Links dialog box.

Am able to automatically open them, and then close them.
But once they're closed, need the sub-routine to Update [all] Links.

This should be simple, but have made many attempts to no avail.

Does anyone have the solution?

Thanx,
- Mike

--

Dave Peterson