We're migrating a large amount of files from one storage
system to another due to capacity constraints. We have a
set of excel files that contain VB macros with hard coded
links to the full URL path of some other files that are
also being moved. Does anyone know if there is a way to
do a global search and replace of text within Excel VB
macros for multiple Excel Spreadsheets?

I.E., original macro may contain text:
\\server1\directory\subdir\file.xls

We want to change any instances of that reference to:
\\server2\directory\subdir\file.xls

Thanks!
Mike