UNC in Exel

TKopelke · Post by **TKopelke** » Sat Jul 30, 2005 12:37 am

Hello

I need to search alot Excel Files for UNC Paths, and later replace them with relative ones.

My Question is, how is the best Search Expression to locate all UNC's?

Thank you
Tobias Kopelke

Post by **DataMystic Support** » Wed Aug 17, 2005 12:19 pm

You'll need to know where the files are moving to.

Just search for

\\servername\path

and replace with

..\..\path , with the number of ..\ depending on the folder depth. This will get very messy.