Converting unc to mapped

[Kim]

All,

We have over 250 workbooks with references to UNC. We
are moving servers - which will in turn change the UNC
required. Does anyone know of a programmatic way to
either change the UNC reference of the workbooks (in
bulk) to a mapped drive reference -OR- change the UNC
reference to refer to the new server name.

Thanks
Kim

 

[Bob Phillips]

Have you tried find and replace (Ctrl-H)?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

That would be great if I had only a handful of workbooks,
but, as I mentioned, we have over 250 that we need to
do. If the find and replace could be used in conjunction
with VB or something like that, that would work.

K

 

[Bob Phillips]

If you record a macro and do the search and replace on one workbook, then
you could assign that macro to a button.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)