Backup mode

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

Keep the original file date

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

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.

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.

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.

Microsoft Excel Control

The following options are used for controlling Microsoft Excel - in particular, how Microsoft Excel errors are handed. This settings should be left alone unless you know what you are doing!

Version of Microsoft Excel to invoke (use ONLY with multiple Microsoft Excel installations)

If you have more than one version of Microsoft Excel installed, you can use this field to determine which version ExcelPipe interacts with.

If you only have one version of Microsoft Excel installed, leave this set to the 'Automatic' setting.

Restart Microsoft Excel after this many documents

Microsoft Excel's performance and reliability can be improved (especially for large documents, and large numbers of documents) if it is restarted periodically.

A value of 0 disables this option, 100 documents is a useful default.

Restart Microsoft Excel automatically if unresponsive for this many seconds

Microsoft Excel can sometimes get stuck when opening a document, for example, if it detects that an error occurred last time it opened a document, it will ask for confirmation. This kind of message can interrupt ExcelPipe's processing, so you can force ExcelPipe to restart Microsoft Excel after a given number of seconds of inactivity.

A value of 0 disables this option, 30 seconds is a useful default.

Location of EXCEL.EXE (to restart from catastrophic failures)

Sometimes when Microsoft Excel is restarted it corrupts its own settings in the System Registry, making it impossible to restart using normal methods. By specifying the path to Microsoft Excel, you can get ExcelPipe to attempt to restart Microsoft Excel directly. Use the browse button to locate EXCEL.EXE, possibly in C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE.

[Start replacing (F9)]

When you click this button or press [F9], ExcelPipe will begin making replacements.

[Start searching (F5)]

When you click this button or press [F5], ExcelPipe will begin searching for the search text. No replacements will be made.

 Contact Us   Support   Community   Tutorials and User Guides (online)
 Copyright © 1999-2008 DataMystic. All rights reserved.