Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 1
Default How to Search For a URL in a Large Number of Excel Files?

I would like to find a way to search all the Excel Files in a hard
disk to look for a specific URL. We are in the process of moving a
shared network folder from one server to another server (such as from \
\FileSrv1\IS_Dept to \\FileSrv2\IS_Dept). Unfortunately, many people
have embedded the URL of the shared network folder in Excel and Words
documents. I am afraid that after the move, those links will not
work. Therefore, I am looking for a way to identify those files that
have embedded that specific URL; then I can ask the users to change
the URL after the move.

I have tried using Windows Search function (in My-Computer) and the
FIND command in command prompt. None work.

Please help. Thanks.

Jay Chan
  #2   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 473
Default How to Search For a URL in a Large Number of Excel Files?

I can send you a LinkManager utility which will locate such references
and optionally change them. To request a copy, email me at Bill
underscore Manville at Compuserve dot com


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply
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
Large excel files gboll Setting up and Configuration of Excel 1 October 18th 08 04:49 AM
Converting Large XML Files into CSV File via Excel DaleB Excel Discussion (Misc queries) 2 December 5th 07 03:14 PM
Converting Large XML Files into CSV Files for Excel DaleB Excel Discussion (Misc queries) 0 December 3rd 07 09:17 PM
Searching large excel files mthakershi Excel Discussion (Misc queries) 1 June 13th 07 06:31 PM
Using large excel files Tom Trahan Excel Worksheet Functions 1 January 25th 05 08:35 PM


All times are GMT +1. The time now is 12:14 PM.

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

About Us

"It's about Microsoft Excel"