UNC in Exel

Discuss WordPipe, ExcelPipe and PowerPointPipe. Get help with installation and running, notify us of bugs, request new features and enhancements.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply

UNC in Exel

Post by TKopelke »


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
User avatar
DataMystic Support
Site Admin
Posts: 2227
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

Post by DataMystic Support »

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

Just search for


and replace with

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