ExcelPipe is a simple to use utility that enables users to search and modify content from Microsoft Excel files.
You can change hyperlinks and UNC paths when servers get renamed, update contact details such as names, addresses and phone numbers. Users are enabled to translate spreadsheets with find/replace lists and update Microsoft SharePoint documents or Microsoft Namespace Server mappings.
Using ExcelPipe is simple. 1) Drag and drop files from Windows Explorer to ExcelPipe, or right-click the files or folders to process in Windows Explorer and choose ExcelPipe. 2) Add one or more search/replace pairs. 3) Go! ExcelPipe can change thousands or millions of spreadsheets, and can make multiple changes simultaneously to save time.
It automatically handles read-only files, passwords and other protection, and it can be automated to run overnight or over a weekend. No user interaction is required. It even includes restart recovery in case Microsoft Excel crashes.
ExcelPipe offers many more search and replace options than Microsoft Excel such as hyperlinks, text boxes, shapes, document properties (such as Title, Subject, Author, Company etc) and more. EasyPatterns and Perl regex patterns can also be used. VBA Code Modules can be updated - even if protected with a password.
ExcelPipe is fully Unicode compliant (allowing Find and Replace with international character sets), and can handle an unlimited number of spreadsheets and find and replace pairs. Now it can alter the Connection strings of Query Tables and Pivot Tables - ADO, DAO, OLEDB and ODBC database queries and Web queries.
Limitations:
· 30 days trial
· Nag screen
What's New in This Release:
· Fixed range check error on loading replace highlight color fields from import
· files.