Turn off Link resolution?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



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!



.



Relevant Pages

  • turn off link resolution?
    ... I'm programming Excel from VB.NET, so maybe I don't know how to ... I need to programmatically update links in cells that refer to workbooks ... I save the original workbook to a new workbook ...
    (microsoft.public.excel.programming)
  • error in running workbook.close() func. after close excel from win
    ... i am programming excel using PIA. ... close excel document by clicking X top corner of window,after a while ... if (workbook!=null) workbook.close; ...
    (microsoft.public.dotnet.languages.csharp)