LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How to cancel a find & replace command "midstream"?

Once a month I need to update a dozen or so files that contain around 500 or
so external links. For reasons I cannot go into, I cannot simply use the
Edit-Links-Change_Source solution. Instead I have to use the "find & replace"
function.

As long as I have not made any filename typos in the "find & replace" query,
this works fine. But as the filenames are complex, occasional typos are
inevitable. In such cases, a dialog box appears prompting to either locate
the non-existent file, or to cancel.

The problem is that with 500 links, I appear to be forced to click the
"cancel" button 500 times in order to then be able to "undo" and correct the
filename in the "find & replace" command. The only way I seem to be able to
avoid this laborious is to kill the Excel application/process using Task
Manager. Of course this means that any other unsaved Excel files that I have
open are also killed.

As the Esc key doesn't seem to work, is there a more efficient way of
halting the bad "find & replace" order from continuing?
 
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
Find comment replace cell value [email protected] Excel Discussion (Misc queries) 3 July 5th 06 09:42 PM
find and replace macro strange behaviour Nicawette Excel Discussion (Misc queries) 3 June 13th 06 08:49 PM
How do I find and replace the " mawmawball Excel Discussion (Misc queries) 8 December 22nd 05 01:19 AM
Find and Replace blakrapter Excel Worksheet Functions 3 December 15th 05 12:25 AM
Problem with Find and Replace mjhill01 Excel Worksheet Functions 1 August 18th 05 04:12 AM


All times are GMT +1. The time now is 11:51 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"