This is a collection of frequently asked questions about ExcelPipe.
Questions
Q. How do I disable AutoRun macros while I run ExcelPipe?
A.
ExcelPipe does this for you.
Q. How do I search inside Text boxes? A. Check the 'Shapes' Look In location.
Q. How do I remove carriage returns within a cell, entered with
Alt+Enter? A. You can't - this is an Microsoft Excel limitation. If you can File\Save As
the file as CSV (Comma delimited format), then you can apply our
TextPipe Pro
tool.
Q. I am trying to replace a date but it is never found. A. If you open Excel and put your cursor in the date cell, you will find
that the date data (which is what ExcelPipe scans through) is different
to the formatted date displayed. E.g. 28-Feb-07 is displayed, but the
data in the cell is 28/02/2007. You must be very careful to match the
actual cell content exactly.
Q. Why does ExcelPipe occasionally appear to hang? A. This occurs when Microsoft Excel is trying to display a dialog
box, such as for a missing linked document (note: ExcelPipe does NOT
pause for missing passwords. If you have not specified the correct
password, these files are logged for manual handling). Simply press [Alt+Tab]
to get to Microsoft Excel, then clear the dialog box. Once this is done,
ExcelPipe will resume at normal speed.
Home
Buy Now
