If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|