download25.com

Your free TOP 25 download source!

ExcelPipe Find and Replace for Excel 6.0.2

Search and Replace multiple Microsoft Excel spreadsheets, change links/addresses
Publisher: DataMystic
Category: Spreadsheets
Version: 6.0.2
License: shareware
Cost: buy 49.95$
Size: 7.82 MB
Updated: 15 Apr 2013
Bookmark: Click here
Review
Search and Replace multiple Microsoft Excel spreadsheets. Change hyperlinks and UNC paths when servers get renamed; update contact details such as names, addresses and phone numbers; translate spreadsheets with find/replace lists; 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.

Unlike competing products, ExcelPipe is fully Unicode compliant (allowing Find and Replace with international character sets), and can handle an unlimited number of spreadsheets and find/replace pairs.
Now can alter the Connection strings of Query Tables and Pivot Tables - ADO, DAO, OLEDB and ODBC database queries, Web queries etc.

ExcelPipe can search/replace both .XLS and .XLSX Excel document formats.

NEW! Now can update the connection strings of Query Tables and Pivot Tables - ADO, DAO, OLEDB and ODBC database queries, web queries etc.

Try it today - and see why Microsoft recommends ExcelPipe to its customers!

Changelog:
Version: 6.0.2(13 May 2013)
* Fixed search terms not found.
Version: 6.0.1(02 May 2013)
Dual x32/x64 release
Version: 5.8(24 Apr 2013)
* The files to be processed are now gathered in parallel with document
processing - so processing starts far more quickly, especially for large sets
of files.
* Improved handling of Unicode filenames.
Version: 5.7.1(19 Sep 2012)
When importing a list from .xls, .tab or .csv, ExcelPipe now assumes a highlight color of yellow if the highlight color column is missing.
Updated sample import files.
Version: 5.7(28 Aug 2012)
Now supports Open Document Calc file type .ods
Version: 5.6(08 Feb 2012)
Now can alter the Connection strings of Query Tables and Pivot Tables - ADO, DAO, OLEDB and ODBC database queries, Web queries etc.
Version: 5.3.4(03 Nov 2011)
Added application link to help file for correct import file format.
Version: 5.3.3(15 Sep 2011)
Fixed GUI issue with selecting a cell to edit. Fixed protection passwords not working.
Version: 5.3.2(08 Sep 2011)
Added .xlsx to list of default file types
Version: 5.3.1(15 Aug 2011)
Now handles Unprotecting and Reprotecting sheets with blank passwords.
Version: 5.3(22 Jul 2011)
New option to prevent overlapping of subsequent search replaces. This is very handy when the replace terms appear in subsequent search terms and two replacements would have occurred.
Version: 5.2.1(05 Jul 2011)
Fixed search grid being disabled.
Version: 5.1.1(03 May 2011)
New help options and hints for connecting to SharePoint.
Version: 5.0.8(16 Mar 2011)
Search/replace now continues even if there is an error getting the document protection type under Office 2007/2010.
Version: 5.0.7(10 Feb 2011)
Search-Only mode now works in protected sheets.
Version: 5.0.6(28 Jan 2011)
Defined Names search now searches both Names and Values (previously it just searched Names).
Version: 5.0.3(24 Dec 2010)
Modified file scanning method to minimize network errors
Version: 5.0.2(22 Dec 2010)
OLE and DDE links now included in Link Reports
Version: 4.9.2(22 Oct 2010)
Hidden Rows and Columns can now be search/replaced even if the Last cell in the worksheet is hidden. In this case the first 100 rows and 100 columns are checked.
Version: 4.9(27 Aug 2010)
Can now restart at a given filename, Unicode filename support
Version: 4.8.2(20 Aug 2010)
Protected sheets are now skipped if Options\Protection Password is blank ? this prevents errors with Excel 2007 that cannot be handled automatically.
Version: 4.7.4(07 Jun 2010)
New option to Skip Prompting if the replacement is identical, standardized open/save dialogs
Version: 4.7.3(21 May 2010)
Fixed prompt on replace displaying even non-matching terms.
Version: 4.7.2(12 May 2010)
New option to ignore Prompting if the replacement is identical to the found text. Makes for far easier searching.
Version: 4.7(09 Apr 2010)
New Check All/Uncheck All buttons to set the Look In locations, New Insert row button, Better install under Vista/Windows 7
Version: 4.6.15(18 Feb 2010)
'Prompt on Replace' option now displays the Confirmation dialog even if the found text and its replacement are identical - making search-only far easier.
Version: 4.6.14(02 Sep 2009)
Now opens .XLA files correctly (containing code modules only)
Version: 4.6.12(01 Aug 2009)
Improved handling of Microsoft Excel restarts.
Version: 4.6.10(09 Jun 2009)
Logs now include a sequential file number, various fixes
Version: 4.6.8(15 May 2009)
Now searches inside each shape contained with a grouped shape e.g. for Links/OLE/DDE etc.
Version: 4.6.1(12 Feb 2009)
Now handles search strings longer than 255 characters, which Microsoft Excel does not support (and now has Yes to All option)
Version: 4.5.1(09 Oct 2008)
Now handles sheets protected with no password (as well as those with a password) and re-protects afterwards
Version: 4.5(02 Oct 2008)
Added ability to search/replace inside Code Modules and much more
Version: 4.4.3(17 Jul 2008)
Version: 4.4.2(20 Jun 2008)
Now can search and replace in hidden rows and columns, formulae etc
Version: 4.4(17 Jun 2008)
Now can search and replace in hidden rows and columns
Version: 4.3.2(14 Mar 2008)
Resolved problem with unprotecting a document marking the document as changed
Version: 4.1(08 Aug 2007)
New warning message if backup files have not been deleted or restored at the end of a job.
Version: 3.9.6(27 Jun 2007)
Improved speed for massive Hyperlink changes; Hyperlink changes now automatically check for equivalence between %20 and space
Version: 3.9.4(19 Apr 2007)
Improved speed for massive Hyperlink changes; Hyperlink changes now automatically check for equivalence between %20 and space
Version: 3.9.1(22 Mar 2007)
Improved speed for massive Hyperlink changes; Hyperlink changes now automatically check for equivalence between %20 and space
Version: 3.9(09 Mar 2007) - excelpipe.exe
Improved speed for Hyperlink changes; Hyperlink changes now automatically check for equivalence between %20 and space
Version: 3.8.3(15 Dec 2006)
Increased search/replace speed, new Options Menu item to remove leading and trailing blanks from search and replace terms.
Version: 3.5
Tags: | Search And Replace | Excel Spreadsheets

download (excelpipe2.exe - 7.82 MB)