Application.displayalerts = false

Rember that when this is off no display alerts come up
such as do you want to save over that file. It just does
it. So I recomend that as soon as you can yuo should turn
them back on again.

Jase
-----Original Message-----
Hello,

I have a script that changes an Excel link from one Excel
document to
another. How do I supress Excel's link validation
process? The new link
will not be available until after more file migration has
completed.

Example:

File ABC.XLS, cell A1 contains -
='C:\users\mike\[remote.xls]Sheet1'!A1
and I want to change it to - ='D:\mike\[remote.xls]
Sheet1'!A1

But the file D:\mike\remote.xls does not exist at the
time of the change
being made to the file ABC.XLS. All of my automation is
working, but Excel
prompts me with a dialog box asking me to locate
D:\mike\remote.xls. How do
I supress this dialog box?

TIA!

--
Mike Frederick



.