Options Tab

Backup mode

Save a backup of any modified files. If the original file was called test.xls, the backup is saved to test.bak.

Retain file Modified dates

When checked, the original file date of files is retained.

Retain file Last Access dates

When checked, the original Last Accessed date of files is retained. This allows your organization's data retention policy to be maintained, as documents that have not been accessed by a human still retain their original date.

Allow alerts (necessary for mail merge)

Normally ExcelPipe disables alerts from Microsoft Excel, which is fine in most cases as the default choice is selected.

Process longest 'Find what' strings first

Very useful for translators, this option causes the search/replace list to be first sorted in order of the longest (i.e. most specific) Find What strings first. A good example is this:

If the string 'Parent Information' is found in the file, it gets replaced by 'Padre Information', and the second row is never used. This situation is avoided by first sorting the list so that the longest (i.e. most specific) replacements are first.

Process read only files

When checked, if read-only files are encountered, they are first changed to read-write, processed, and then set back to read-only status. When unchecked, read-only files are skipped.

Process hidden rows and columns

By default, hidden rows and columns are not searched. Check this option to search them -> this can be slightly slower.

Keep Microsoft Excel visible while changes are being made

While slower, this option can be useful for debugging and monitoring what ExcelPipe is doing.

Accept Revisions

Accepts revisions before processing - otherwise they can prevent matches from being found.

Disable Addins

Checked by default, this option disables Microsoft Excel AddIns in case they interfere with the search/replace process. If you need an AddIn to remain loaded then uncheck this box.

Prevent overlap of search/replaces

Prevent chaining of search/replaces where a early replace gets changed by a subsequent search e.g. with the following set of replacements:

Imagine the sentence 'A cat bit the dog'. This will be changed to 'A foo bit the foo' because the replacement on one line is found by the search on the next line.

When this option is checked, the replacement becomes 'A dog bit the rat'.

Password for open

If a document requires a password for open, ExcelPipe will open it using this password. The password is ignored if it is not required to open the document. If the password is wrong the document is skipped.

This can be handy if you have multiple password-protected documents sharing the same protection password.

Password to unprotect sheet/workbook

If a sheet or workbook requires a password to modify it, ExcelPipe will provide this password. The password is ignored if not required.

This password is also used if you specify a Code Module search and a VBProject is found to be protected.

ExcelPipe restores the original protection when it saves the file.

ISO-9001 version control

If your company is certified to the international ISO-9001 standard, it's essential that you also update each document's version number when any changes are made.

With ExcelPipe, you can automatically update the version number by 1.0 or 0.1 or any other amount automatically.

'Revision' document property name

This is the name of the custom property that holds the version number in the document, usually 'DocRevision' or similar. For more information, please click here. This field is NOT case-sensitive.

Increment

The amount to increment the revision by, usually 1.0 or 0.1. This value must be a valid floating-point number.