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

Post Reply

UNC in Exel

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


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: 2237
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia

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


and replace with

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

Simon Carter, https://www.DataMystic.com
https://www.JadeDiabetes.com - Insulin dose calculator for Type 1 diabetes
https://www.DownloadPipe.com - 250,000 free software downloads

Post Reply