M
Mike Frederick
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!
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!