ExcelPipe is here,
and has many new time-saving features to
help you work smarter.
New Features
What's New in ExcelPipe 8.9 - July 28, 2021
*
Fixed periodic reprompting for license key information.
As always, ExcelPipe will read filters from ALL old versions without any
changes being required.
Registered Users / Current Customers
Login and download the upgrade, and/or see if you are
entitled to an upgrade
Related Applications You May Need
TextPipe - search
and replace text files, web sites and more
WordPipe - search
and replace Microsoft Word documents
PowerPointPipe - search and replace
Microsoft PowerPoint presentations
Detailed Changes Log
What's New in ExcelPipe 8.8.3 - January 9, 2021
*
Fixed issue with ribbon disappearing.
What's New in ExcelPipe 8.8.2 - December 2, 2020
*
Resolved license manager connection issues by reverting SSL changes for
license manager.
What's New in ExcelPipe 8.8.1 - 5 November 2020
*
Fixed memory issues with x64 registered versions.
What's New in ExcelPipe 8.8 - 15 October, 2020
*
Fixed issue with HTML help component preventing normal termination.
What's New in ExcelPipe 8.7.1 - 30 September, 2020
*
Fixed file missing from install borlndmm.dll.
What's New in ExcelPipe 8.7 - 24 September, 2020
* License manager now handles key renewal.
Updated ribbon controls.
What's New in ExcelPipe 8.6 - June 19, 2020
*
Fixed issue saving restart files when settings have not been saved.
*
Updated regex component.
*
Fixed file modes for server editions.
What's New in ExcelPipe 8.5 - February 29, 2020
*
Improvements to grid editing.
What's New in ExcelPipe 8.4 - September 26, 2019
*
Improved error handling in license manager.
What's New in ExcelPipe 8.3 - April 17, 2019
*
Retaining last access date now works in Search/Replace mode.
What's New in ExcelPipe 8.2 - March 12, 2019
*
Fixed error on closing running process before end.
*
Added results of Data Sources search/replace to the Hyperlink report.
What's New in ExcelPipe 8.0.1 - March 5, 2019
*
Updated editing grid to be more user-friendly.
*
Fixed error where evaluation files were deleted if backup mode was selected
and the status window was closed without choosing to restore or delete the
backup files.
What's New in ExcelPipe 8.0 - February 16, 2019
*
Updated ribbon to Office style.
What's New in ExcelPipe 7.9 - November 8, 2018
*
Updated license manager code.
What's New in ExcelPipe 7.8 - June 28, 2018
*
New! Data Sources can now be updated (Office 2016+).
What's New in ExcelPipe 7.7 - June 18, 2018
*
Updated status tab warning about MS Excel already running to only display
when no ExcelPipe job is running.
*
Added cleared error messages for EasyPattern and Perl Regex errors.
*
Removed logging warnings.
What's New in ExcelPipe 7.6.2 - September 15, 2017
*
Added more error logging for troubleshooting problems with .xls documents.
What's New in ExcelPipe 7.6.1 - August 21, 2017
*
Added the current filename to error reporting.
What's New in ExcelPipe 7.6 - July 28, 2017
*
Fixed error with non-recognized languages.
What's New in ExcelPipe 7.5 - October 18, 2016
*
Fixed export error.
What's New in ExcelPipe 7.4 - August 16, 2016
*
New warning display if MS Excel is currently running, with a button kill it.
*
Removed numbering from status dialog tabs as this was confusing.
*
Look In field now shows count of number of locations selected.
*
Fixed SharePoint URL dialog not allowing https:// links.
What's New in ExcelPipe 7.3.1 - July 28, 2016
*
Rebuild to remove Look In list not showing correct values.
What's New in ExcelPipe 7.3 - July 11, 2016
*
Rebuild to remove PROGRAMMING ERROR bug.
What's New in ExcelPipe 7.2.1 - June 26, 2016
*
Rebuild to remove PROGRAMMING ERROR bug.
What's New in ExcelPipe 7.2 - June 22, 2016
*
Now can find and replace Excel images in Microsoft Excel or OpenOffice
spreadsheets (*.ods)
*
Enhanced and improved user interface.
*
Updated internal libraries for pattern matching.
What's New in ExcelPipe 7.1.1 - April 26, 2016
*
Fixed SaveAs issue in evaluation version.
What's New in ExcelPipe 7.1 - March 24, 2016
*
Can now use macros in the replacement text: @inputFilename@ or @filename@
@fullInputFilename, @inputPath, @inputExtension
@clipboard
@time, @date, @datetime
@_year, @_month, @_day
@_hour, @_minute, @_second
@randomdigit, @randomletter
@ENV_varname
*
Can now specify which property should be modified or replaced by preceding it
with [fieldname] eg
Search fields for: [Author]Simon Replace With: Lisa
What's New in ExcelPipe 7.0 - March 11, 2016
*
Now allows the subaddress (anchor) part of hyperlinks to be modified.
*
New warning when all Search Locations checked (slows job down).
*
New checks if the hyperlink change does not get saved if the hyperlink is
invalid or the destination cannot be found)
*
Separated the restart controls into a new tab.
What's New in ExcelPipe v6.9.4 - January 22, 2016
*
Added Excel import messages regarding ending at the first blank "Find What"
cell.
What's New in ExcelPipe v6.9.3 - December 22, 2015
*
Fixed Activate error with "Options\Keep Microsoft Word visible while changes
are being made."
What's New in ExcelPipe v6.9.2 - December 18, 2015
*
Fixed handling of updates to Pivot Table caches.
*
Fixed loading of highlight color data from Import file.
*
Updated button enable/disable for grid.
What's New in ExcelPipe v6.9.1 - August 3, 2015
*
Major revamp of user interface.
*
Added Connections to list of places searched during OLE/DDE search, so now
more DB connection string and connection string filenames are replaced.
*
Fixed "List index out of bounds" error on run.
*
Fixed drag and drop and DDE processing.
*
Fixed Language dialog and Job Cancel alert appearing underneath other
windows.
What's New in ExcelPipe v6.9 - May 18, 2015
*
Fixed settings error on startup.
What's New in ExcelPipe v6.8 - March 3, 2015
*
Fixed intermittent XML loading/saving error on x64 systems.
*
Fixed error with /I= command line option not loading the search-replace list.
What's New in ExcelPipe v6.7 - November 26, 2014
*
Fixed Save from removing leading and trailing whitespace.
*
Fixed Recent settings from not appearing in the Recent files history.
What's New in ExcelPipe v6.6 - October 23, 2014
*
Search items can now be sorted by clicking on any of the column headers -
great for translators.
*
Fixed issues with Lite Editions.
*
Improved detection and display of non-English languages.
*
Updated to EasyPattern v2.9 and Perl regex libraries.
*
Incremental search when the search grid is selected - great for large search
lists.
What's New in ExcelPipe v6.5 - September 5, 2014
*
Fixed synchronization bug that caused ExcelPipe to hang.
*
New Ribbon interface.
What's New in ExcelPipe v6.4 - July 15, 2014
*
Files To Process can now set the Start or End date for files to be included.
*
New! Now attach directly to SharePoint sites (evaluation, and SharePoint
Edition only).
*
Fixed problem with invalid EasyPattern/Perl regex search locations being
removed, and then not being processed against valid search locations such as
hyperlinks.
What's New in ExcelPipe v6.3 - March 7, 2014
*
Now can handle search and replace inside embedded tables.
What's New in ExcelPipe v6.2.1 - February 28, 2014
*
Restart control now restarts on the next file AFTER the restart filename -
making it easier to skip problem files without having to guess which file is
next.
What's New in ExcelPipe v6.2 - October 30, 2013
*
Now shows '(more pending)' next to the file count if more files remain to be
counted, so users aren't misled that only 1000 files will be processed.
What's New in ExcelPipe v6.1 - September 3, 2013
*
Options\Import Search/Replace List and Actions Tab\Load A Search/Replace List
From This File now work with multi-line Tab and CSV data.
*
Added new option to Preserve Last Access dates - perfect for compliance with
corporate data retention policies.
What's New in ExcelPipe v6.0.5 - August 7, 2013
*
Fixed range check error on loading replace highlight color fields from import
files.
What's New in ExcelPipe v6.0.4 - July 30, 2013
*
Improved installer for floating version.
*
Better error messages when Microsoft Excel is not available to load external
.xls search/replace lists.
*
Better detection of missing Microsoft Excel object or mis-matching bitness
(x32/x64) between ExcelPipe and Microsoft Excel.
What's New in ExcelPipe v6.0.3 - June 8, 2013
*
Fixed problem with evaluation where it crashed if you gave it more than 20
documents to process, and it also restricted the evaluation to only one file.
What's New in ExcelPipe v6.0.2 - May 13, 2013
*
Fixed search terms not found.
What's New in ExcelPipe v6.0.1 - May 2, 2013
*
Fixed doubling of search terms every time ExcelPipe is closed.
*
Fixed various installer problems.
What's New in ExcelPipe v6.0 - May 1, 2013
*
Dual x32/x64 release.
What's New in ExcelPipe v5.8 - March 19, 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.
*
Faster importing of large search/replace lists.
*
Quicker to cancel operations with large search/replace lists.
What's New in ExcelPipe v5.7.1 - September 18, 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.
What's New in ExcelPipe v5.7 - August 28, 2012
*
Now supports Open Document Calc file type .ods.
*
Fixed bug where the Replacement Text for subsequent replacements is altered
incorrectly when Prompt on Replace is checked, and [Replace (File)] or
[Replace (Job)] is pressed in response to a replacement.
What's New in ExcelPipe v5.6 - February 8, 2012
*
Highlight color can now be set. Your color is matched to Excel 2003's
standard 56 colors, or the actual color used with Excel 2007 and 2010.
*
Status dialog now opens file on double-click of subsidiary search/replace
phrases. Right-clicking on a filename or phrase now gives a menu to open the
file, or its containing folder.
*
Now can alter the Connection strings of Query Tables and Pivot Tables - ADO,
DAO, OLEDB and ODBC database queries, Web queries etc.
What's New in ExcelPipe v5.5 - February 2, 2012
*
Highlight color can now be set (to Excel's range of 56 standard colors).
What's New in ExcelPipe v5.4 - January 24, 2012
*
Now handles shapes that include tables.
*
When Microsoft Excel is restarted, ExcelPipe now re-applies the visibility
settings to show or hide Microsoft Excel.
*
Now skips ~*.* temporary files and .lnk files.
What's New in ExcelPipe v5.3.4 - October 18, 2011
*
Added application link to help file for correct import file format.
What's New in ExcelPipe v5.3.3 - September 15, 2011
*
Fixed GUI issue with selecting a cell to edit.
*
Fixed protection passwords not working.
What's New in ExcelPipe v5.3.2 - September 8, 2011
*
Added .xlsx to list of default file types - not sure how this was missed!
What's New in ExcelPipe v5.3.1 - August 15, 2011
*
Now handles Unprotecting and Reprotecting sheets with blank passwords.
*
Now handles search-only mode on protected sheets.
*
Fixed 'Prevent overlap' replace mode.
What's New in ExcelPipe v5.3 - July 22, 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.
*
When 'Disable AddIns' is NOT checked, ExcelPipe also keeps any workbooks
open, preventing #NAME? errors after the search/replace has occurred.
*
Improved installer to not require Admin user.
What's New in ExcelPipe v5.2.1 - July 5, 2011
*
Fixed search grid being disabled.
What's New in ExcelPipe v5.2 - July 1, 2011
*
New option to disable AddIns - previously AddIns were always disabled, but
this new option allows them to remain enabled so that they can assist with
the replacement process if required.
What's New in ExcelPipe v5.1.1 - May 3, 2011
*
New help options and hints for connecting to SharePoint.
What's New in ExcelPipe v5.1 - May 2, 2011
*
Passwords are now stored encrypted.
What's New in ExcelPipe v5.0.8 - March 16, 2011
*
Search/replace now continues even if there is an error getting the document
protection type under Office 2007/2010.
What's New in ExcelPipe v5.0.7 - February 9, 2011
*
Search-Only mode now works in protected sheets.
What's New in ExcelPipe v5.0.6 - January 28, 2011
*
Defined Names search now searches both Names and Values (previously it just
searched Names).
*
Progress timer is now disabled while opening a file - so Microsoft Excel will
not be terminated when opening a large file.
What's New in ExcelPipe v5.0.5 - January 27, 2011
*
Fixed string list error when using List of files.
What's New in ExcelPipe v5.0.4 - January 26, 2011
*
More Unicode improvements.
What's New in ExcelPipe v5.0.3 - December 24, 2010
*
Modified file scanning method.
What's New in ExcelPipe v5.0.2 - December 22, 2010
*
OLE and DDE links are now included in the Link Report.
What's New in ExcelPipe v5.0.1 - December 13, 2010
*
Limit to the number of import errors shown.
*
Fixed issue with read-only detection of Unicode filenames.
What's New in ExcelPipe v5.0 - December 10, 2010
*
Fixed more issues with SharePoint and File Locking.
What's New in ExcelPipe v4.9.3 - December 8, 2010
*
Now detects Show Repairs dialog for corrupted documents, and closes it.
*
The row number column is now resizable - allowing row numbers larger than 100
to be displayed.
*
Link Reports now ignore empty hyperlinks, making it easier to identify
unchanged links.
*
Errors on final Save are now trapped to prevent errors with File Locking and
SharePoint.
*
Fixed bug where the timer that checks if Microsoft Excel is still responding
did not re-trigger after the first failure of Microsoft Excel.
What's New in ExcelPipe v4.9.2 - October 22, 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 1000 rows and 1000 columns
are checked.
What's New in ExcelPipe v4.9.1 - October 14, 2010
*
Protected sheets are now skipped if Options\Protection Password is blank and
you are using Excel 2007 or later. Excel 2003 and earlier handle this fine.
What's New in ExcelPipe v4.9 - August 27, 2010
*
Now can restart at a specified file.
*
Protected documents are now skipped if Options\Protection Password is blank -
this prevents errors with Excel 2007 that cannot be handled automatically.
*
OLE Links are now included in the Hyperlink report.
*
Hyperlink report is now available in the Save Report option for output types
CSV, TAB and HTML. Previously it was only available for XML.
*
Perl and EasyPattern matches are now allowed inside Code Modules and Sheet
Names.
*
Unicode filename support.
What's New in ExcelPipe v4.8.2 - August 20, 2010
*
Protected sheets are now skipped if Options\Protection Password is blank -
this prevents errors with Excel 2007 that cannot be handled automatically.
What's New in ExcelPipe v4.8.1 - August 17, 2010
*
Hyperlink report is now available in the Save Report option for output types
CSV, TAB and HTML. Previously it was only available for XML.
What's New in ExcelPipe v4.8 - August 16, 2010
*
New option to Accept All Revisions before replacing - these can prevent
phrases from being found.
*
OLE Links are now included in the Hyperlink report.
What's New in ExcelPipe v4.7.4 - June 7, 2010
*
Now shows error dialog if the default save location (in My Documents) cannot
be written to, and exits gracefully.
*
Standardized open/save dialogs now used throughout.
What's New in ExcelPipe v4.7.3 - May 21, 2010
*
Fixed prompt on replace displaying even non-matching terms.
What's New in ExcelPipe v4.7.2 - May 12, 2010
*
New option to ignore Prompting if the replacement is identical to the found
text. Makes for far easier searching.
*
Improved GUI - Check/Uncheck all search locations working properly, grid rows
behave as expected etc.
What's New in ExcelPipe v4.7.1 - May 10, 2010
*
Protected documents are now not flagged as having the search text.
What's New in ExcelPipe v4.7 - April 9, 2009
*
Workaround for horrendous Microsoft Excel bug where text boxes with more than
255 characters do not get processed.
*
New Check All/Uncheck All buttons to set the Look In locations.
*
New Insert row button.
*
Better install under Vista/Windows 7 - no admin required to install or run.
What's New in ExcelPipe v4.6.15 - February 18, 2010
*
Microsoft Excel now kept visible better if 'Keep Visible' option checked.
*
File associations now just for .xls and .xlsx files.
*
'Prompt on Replace' option now displays the Confirmation dialog even if the
found text and its replacement are identical - making search-only far easier.
What's New in ExcelPipe v4.6.14 - September 2, 2009
*
Now opens .XLA files correctly (containing code modules only).
*
Now typing 'excelpipe' in Windows' Run dialog will start ExcelPipe.
What's New in ExcelPipe v4.6.13 - August 31, 2009
*
Better display of multi-line items
*
Now handles replacements in formulae better
What's New in ExcelPipe v4.6.12 - August 1, 2009
*
Fixed minor bug.
What's New in ExcelPipe v4.6.11 - July 31, 2009
*
Improved handling of Microsoft Excel restarts.
What's New in ExcelPipe v4.6.10 - June 9, 2009
*
Fixed connection to help file.
*
Fixed installer not copying files.
*
Fixed settings not being saved in My Documents folder.
What's New in ExcelPipe v4.6.9 - May 27, 2009
*
Now closes all open documents prior to processing each file.
*
Now can recover from an incorrect worksheet password - ExcelPipe skips the
sheets it can't process and continues with the rest.
*
Logs now include a sequential file number.
*
'Microsoft Excel Update Links' dialog now suppressed.
What's New in ExcelPipe v4.6.8 - May 15, 2009
*
Now searches inside each shape contained with a grouped shape e.g. for
Links/OLE/DDE etc.
What's New in ExcelPipe v4.6.7 - April 28, 2009
*
Improved the internal method by which the password is used for Code Modules.
What's New in ExcelPipe v4.6.6 - April 28, 2009
*
Backup files now get the same date as the original file.
*
Fixed problem where two sets of changes were made.
*
Backup Files and Keep File Date option now work with Unicode filenames.
What's New in ExcelPipe v4.6.5 - April 27, 2009
*
Fixed bug in Code Module search.
What's New in ExcelPipe v4.6.4 - April 23, 2009
*
Now can search/replace Sheet Names (e.g. Sheet1, Sheet2, Sheet3).
What's New in ExcelPipe v4.6.3 - April 22, 2009
*
Fixed title of Cancel button in status window.
*
Installer will now force a reboot if redemption.dll is in use.
What's New in ExcelPipe v4.6.2 - April 21, 2009
*
New Edit Menu with Cut/Copy/Paste/Select All
*
Now recommends the use of TextPipe Pro if .CSV or .TAB files are processed,
as it is much faster and more capable with text files.
*
Code Module searches now include all possible modules. A VBProject protection
password can be opened using the Unprotect Password field.
What's New in ExcelPipe v4.6.1 - February 12, 2009
*
Now offers 'Yes to All' for fixing longer search phrases.
What's New in ExcelPipe v4.6 - February 6, 2009
*
Now handles search phrases longer than 255 characters, which Microsoft Excel
does not support.
What's New in ExcelPipe v4.5.1 - October 8, 2008
*
Now handles sheets that are protected with no password - and re-protects them
afterwards as well.
What's New in ExcelPipe v4.5 - October 2, 2008
*
Added ability to search/replace inside Code Modules.
*
Added option to keep Microsoft Excel visible while running to aid debugging.
*
Added button to import the file list from Microsoft Excel's current list of
open files.
*
Added ability to perform search only from command line using /GS.
*
Fixed /REPORT= command line option not working.
What's New in ExcelPipe v4.4.3 - July 17, 2008
*
Added missing Link Report.
*
Fixed error that occurred if job was cancelled and the status form closed
prior to the processing thread finishing.
What's New in ExcelPipe v4.4.2 - June 20, 2008
*
Fixed processing error with hidden rows/columns.
What's New in ExcelPipe v4.4.1 - June 19, 2008
*
Now makes changes in formulae properly.
*
Now detects hidden rows and columns at the edge of the visible range of
cells.
What's New in ExcelPipe v4.4 - June 17, 2008
*
New link report for reporting hyperlinks found or changed.
*
Now can search and replace inside hidden rows and columns.
*
Better reporting of the number of cells actually changed.
What's New in ExcelPipe v4.3.2 - March 14, 2008
*
Resolved problem with unprotecting a document marking the document as
changed.
What's New in ExcelPipe v4.3.1 - March 11, 2008
*
Now handles unprotect passwords in conjunction with OLE links properly.
What's New in ExcelPipe v4.3 - February 15, 2008
*
New option to specify the unprotect password for sheets and workbooks.
What's New in ExcelPipe v4.2 - October 1, 2007
*
New Highlight option when a replacement is made, to make locating changes
easy (note: does not work for all search types).
*
New [Clear All] button below search/replace grid.
*
Removed legacy behavior where contents of search/replace grid were appended
to imported search/replace lists, leading to confusing results.
What's New in ExcelPipe v4.1.1 - September 5, 2007
*
Now prevents the Header or Footer text from being set to a value longer than
255 characters, which Microsoft Excel doesn't support.
What's New in ExcelPipe v4.1 - August 8, 2007
*
Now forces a Microsoft Excel restart when particular error messages are
returned.
*
If errors occur during Import, you can now cancel the Import.
*
Fixed bug with /G command line invocation, and with /Q.
What's New in ExcelPipe v3.9.7 - August 1, 2007
*
AutoRun macros are now disabled to prevent them interfering with document
processing.
*
New warning message if backup files have not been deleted or restored at the
end of a job.
*
Longer timeout while waiting for Microsoft Excel to respond. Timeout disabled
while showing the 'Cancel Job' confirmation window.
*
Fixed bug with Microsoft Excel being terminated at the wrong time.
*
New translations, better form resizing, fixed detection of options changing.
What's New in ExcelPipe v3.9.6 - June 27, 2007
*
Fixed Match Case and Match Entire Cell settings not being retained.
*
Removed incorrect warning for search terms with spaces when 'Entire Cell'
option was checked.
What's New in ExcelPipe v3.9.5 - June 21, 2007
*
Now integrates with Windows Explorer right click menus - 'ExcelPipe this
file/folder'.
*
Now allows a list of files to process on the command line.
*
Previous settings are now saved under Documents rather than Registry.
*
New installer languages.
*
New Japanese and Chinese translations.
What's New in ExcelPipe v3.9.4
*
Fixed incorrect warning for hyperlink longer than 255 characters.
What's New in ExcelPipe v3.9.3
*
Now updates hyperlink Screen Tips as well when the 'Hyperlink addresses'
search location is chosen.
*
Office 2007 file extension of .XLS* now supported.
*
Import assumes defaults if just columns A & B present.
*
Invalid Search Locations are now corrected and you have the option to
continue running the job.
*
Fixed bug with hyperlinks not being updated due to TextToDisplay property not
supported on older versions of Excel.
*
Fixed bug with Prompt on Replace always replacing.
What's New in ExcelPipe v3.9.2
*
Now can optionally handle read-only files.
*
Now warns you if you apply EasyPattern wildcards or Perl regex wildcards to
search locations that do not support them.
What's New in ExcelPipe v3.9.1
*
Now allows files to be drag and dropped.
*
Vista installation support.
*
New Troubleshooting Guide links.
What's New in ExcelPipe v3.9
*
Improved speed when making massive numbers of hyperlinks changes (e.g.
18000).
*
Hyperlink changes now automatically check for equivalence between %20 and
spaces.
What's New in ExcelPipe v3.8.4
*
Fixed assertion failure.
What's New in ExcelPipe v3.8.3
*
New status message when exporting or importing data
*
Added Half Width/Full Width option for Japanese text.
*
Increased search/replace speed.
*
Removed Arabic options - causing problems with English versions.
*
New Options Menu item to remove leading and trailing blanks from search and
replace terms.
*
Status displays now resume if you cancel out of Aborting the job.
What's New in ExcelPipe v3.8.1
*
Status window now shows seconds elapsed and scans in progress to improve
feedback to user.
*
Improved timeout detection.
What's New in ExcelPipe v3.8
*
Auto Recovery is now disabled to prevent them interfering with document
processing.
*
New search types of EasyPattern wildcards and Perl regex wildcards. These can
be used to apply sophisticated pattern matching, replacing and reformatting
inside Hyperlink Addresses, Shapes, Headers, Footers, Built in/Custom
Properties, Links (OLE/DDE), Chart Titles and Defined Names.
*
Prompt on Replace for the search locations above.
*
Processing can now be paused and resumed.
*
Updated Excel/CSV/Tab import and export.
*
Backed-out Windows Vista installation support. Too cumbersome for users.
What's New in ExcelPipe v3.7
*
Now can search multiple locations with one search row.
*
New option to process longest 'Find What' strings first - perfect for
translators.
*
New option to Allow Alerts from Microsoft Excel.
*
Fixed bug with EXE location not being saved, and with prompt for save not
occurring when the settings have been changed.
*
Fixed bug with replace strings longer than 255 characters missing some
characters.
*
Fixed bug where MS Word was restarted, not MS Excel.
What's New in ExcelPipe v3.6.5
*
Fixed division by zero when 'Restart after XX documents' was zero.
What's New in ExcelPipe v3.6.4
*
Was only finding in Values, now finds in Formulae as well.
*
Now processes files with Unicode filenames.
*
List of Files now supports Unicode filenames.
*
Up/Down arrows now work outside of the Grid control.
What's New in ExcelPipe v3.6.3
*
Determination of whether a replacement occurred is now correct.
*
Removed the 'file exists' check.
What's New in ExcelPipe v3.6.2
*
Status dialog now correctly shows Unicode search/replace strings.
*
Changed install to support Windows Vista - Test files and Sample are now
stored under Application Data\DataMystic\ExcelPipe. Default install location
is now Program Files\DataMystic\ExcelPipe.
*
Changed the 'file exists' check to work better on LANs.
What's New in ExcelPipe v3.6.1
*
New button to copy selected rows.
*
Status dialog can now save a report as a Web Page, CSV or Tab data.
What's New in ExcelPipe v3.6 B
*
New option to restart Microsoft Excel automatically after a given number of
documents. This helps to eliminate Microsoft Excel errors.
*
Now checks if Microsoft Excel is not responding, and shows a helpful message
to the end user. Microsoft Excel can be restarted automatically if it is
unresponsive for a given number of seconds.
*
New option to specify the path to the Microsoft Excel executable (.exe) file.
This is used if Microsoft Excel cannot be restarted automatically after a
failure.
*
New option to process a list of files pasted in.
*
Now allows replacements longer than 255 characters (working around a
Microsoft Excel limitation).
*
Backup files can now be restored or removed at the end of the job.
*
Multi-line values can now be edited in the grid.
*
Up/Down arrows now work correctly in fields other than the grid.
*
Error messages reworked to always show the filename first.
*
Status dialog can now copy filenames without messages - very useful for
generating lists of files to reprocess.
*
Fixed error with 'Search' button causing a Replace.
*
Fixed error with 'Cells' search location not working.
What's New in ExcelPipe v3.6
*
New 'File\Send To...' menu item to email settings
*
New Help panel to assist new users
*
New Half width/Full width option for use with Japanese and other Unicode
text.
*
Import from a .XLS replace list now handles trailing spaces and the values
Yes/No/True/False/1/0 for Boolean fields.
What's New in ExcelPipe v3.5
*
Now can replace inside Chart Titles.
*
Now can replace inside Defined Names.
*
Now detects multiple copies of ExcelPipe running - and warns against it, as
it can lead to document corruption.
*
Now shows Unicode search strings in the status dialog.
*
Now warns if no rows are selected when options are clicked on.
What's New in ExcelPipe v3.4
*
New option to update an ISO-9001 revision number field by a pre-defined
amount.
*
Now can display the clipboard contents - very useful when using '^c' to
replace search text with the current clipboard contents.
*
New XML file format - makes it easier to automate ExcelPipe and share replace
lists with WordPipe and PowerPointPipe.
*
Search/replace rows are now restored when the application restarts.
*
Now warns against erroneous backslashes (\) instead of forward slashes (/)
when searching inside hyperlink addresses.
*
New Options tab.
*
Read-Only files are now added to the files tab.
What's New in ExcelPipe v3.3
*
New warning message if the search/replace list filename is blank.
*
New method of connecting to Microsoft Excel allows it to be manually started
if required.
*
New warning if no files were processed.
*
Better detection of changes being made or not.
What's New in ExcelPipe v3.2
*
Now can change the path of embedded OLE and DDE links to databases and other
sources.
What's New in ExcelPipe v3.1.1
*
Now works with an independent copy of Excel to avoid interfering with other
applications.
What's New in ExcelPipe v3.1
*
Now shows the number of changes made or search terms found, both for the
entire job, for each file, and for each search or replace term.
*
EXPORT and IMPORT of replacements list to any common file format (xls, csv,
txt), in Unicode format.
*
New column for the row number - makes the grid easier to work with.
What's New in ExcelPipe v2.9
*
New Backup mode.
*
Now supports drag and drop of rows.
*
Now supports Up/Down/Tab/Shift+Tab in grid.
*
Automatically extends the grid when you Tab or Down Arrow past the end.
*
Fix for 'Search By Rows/Columns' settings - now removed - Excel does not
support this.
What's New in ExcelPipe v2.8
*
Now there is only a single message if the search strings contain leading or
trailing whitespace.
*
Now correctly loads Unicode data from an Excel search/replace list.
*
Now correctly finds and replaces Unicode in hyperlinks, shapes, headers,
footers and document properties.
*
Now handles loading a Tab or CSV search/replace list where the replacement is
blank.
*
Now handles European installations of Excel.
What's New in ExcelPipe v2.7
*
Now includes text files for you to play with.
*
When run in non-interactive mode from the command line, ExcelPipe now
suppresses warning messages for intervention-free execution.
*
Updated help files.
What's New in ExcelPipe v2.6
*
Now can import a list of the files to process.
*
Fixed problem with password-protected files stopping the processing.
What's New in ExcelPipe v2.5
*
Now can perform Unicode search and replace.
*
New Search-Only function, very useful to locate matches.
*
New-style Tips of the Day dialog.
*
New User Interface for easier editing, with row copying and moving.
*
Double-clicking on filenames in the results window now opens the file.
*
Double-clicking on the start folder now opens it in Explorer.
What's New in ExcelPipe v2.4.1
*
Now displays the correct error message if a corrupted spreadsheet cannot be
opened.
What's New in ExcelPipe v2.4
*
Now can search and replace inside the built in document properties such as
Title, Subject, Author, Company etc, and inside custom document properties
defined by the user.
*
Now can search and replace inside the header and footer of each worksheet.
*
New status window options to copy the log to the clipboard.
*
Now checks to see if MS Excel is still functioning and opens a fresh copy if
not.
*
Now displays the number of changes made to each document.
*
Now disables many of MS Excel's alert dialog boxes.
*
Fixed display of wrong error message if MS Excel was opened with open
spreadsheets.
What's New in ExcelPipe v2.3
*
Now can search inside shapes.
What's New in ExcelPipe v2.2
*
Now can search inside hyperlink addresses.
*
Interface now takes advantage of WordPipe-style interface improvements.
*
Removed prompting if the search string is not found.
What's New in ExcelPipe v2.1
*
Initial release!
See http://www.datamystic.com for more details on ExcelPipe
to download the full version upgrade