I do think using workbook.open can solve my problem

I don't think it can do what you want. You want all the links that are
available to be silently updated, with no error message if links are
missing. All you can do with a macro is control whether links are updated
or not.

This updates links:

Workbooks.Open "C:\file.xls", True

and this doesn't:

Workbooks.Open "C:\file.xls", False

But if you choose the first and a link is missing, Excel will alert you.
Sorry.

--
Jim
"RAZA" wrote in message
...
|
| thanks Jim
|
| I am using excel 2000, I do think using workbook.open can solve my
| problem but don't know what codes would be required.
|
| Regards
| RAZA
|
|
| --
| RAZA
| ------------------------------------------------------------------------
| RAZA's Profile:
http://www.excelforum.com/member.php...o&userid=34186
| View this thread: http://www.excelforum.com/showthread...hreadid=540223
|