View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marc Miller Marc Miller is offline
external usenet poster
 
Posts: 3
Default turn off link resolution?

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