LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A change in Excel worksheet and all my link turn into #value! Fabrice Excel Discussion (Misc queries) 0 October 6th 06 05:12 PM
Screen Resolution Jason Zischke Excel Programming 2 February 15th 06 05:36 AM
Screen Resolution Sheldon Excel Programming 1 November 2nd 04 05:52 PM
xlVeryHidden Resolution kevin Excel Programming 1 June 2nd 04 01:08 AM
Code to automatically turn on and turn off Track Changes John[_46_] Excel Programming 1 October 7th 03 02:22 AM


All times are GMT +1. The time now is 10:09 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"