I'm programming Excel from VB.NET, so maybe I don't know how to
express my problem correctly. Forgive me.
I need to programmatically update links in cells that refer to workbooks
on a network share. However, the share in the update does not yet
exist. I can successfully update a link however, if it doesn't exist yet,
Excel
pops up a dialog that expects the user to locate the new link.
Is there any way to suppress that behavior until I can update all my links
and close the workbook? I save the original workbook to a new workbook
after updating.
TIA Much!
Marc Miller
Bookmarks