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!
Joachim Van den Bogaert - 26 May 2006 08:38 GMT
For C# there is a property of the _Workbook interface that is called
UpdateLinks.
If you switch it off before you start editing the Workbook and on
before you save it +
call the method UpdateLink()
http://msdn2.microsoft.com/en-us/library/microsoft.office.tools.excel.workbook.u
pdatelink.aspx
It shouldn't be too difficult to put this into VB
Cheers