Page 1 of 1

UNC in Exel

Posted: Sat Jul 30, 2005 12:37 am
by TKopelke
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

Posted: Wed Aug 17, 2005 12:19 pm
by DataMystic Support
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.