ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   turn off link resolution? (https://www.excelbanter.com/excel-programming/362335-turn-off-link-resolution.html)

Marc Miller

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




All times are GMT +1. The time now is 03:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com