Page 1 of 1

Replacing Page and Pages macros in Excel Headers and Footers

Posted: Mon Jun 18, 2018 7:20 am
by DataMystic Support
Note that Excel stores macros such as &[Page] different internally (when ExcelPipe is searching and replacing them) compared to what the user sees and edits.

If the user-visible text is set to:

Code: Select all

&[pages]&[Page]&[Date]&[Time]&[File]&[Tab]&[Path]&[File]
The text behind the scenes that can be searched/replaced is:

Code: Select all

&N&P&D&T&F&A&Z&F