Replacing Page and Pages macros in Excel Headers and Footers
Posted: Mon Jun 18, 2018 7:20 am
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:
The text behind the scenes that can be searched/replaced is:
If the user-visible text is set to:
Code: Select all
&[pages]&[Page]&[Date]&[Time]&[File]&[Tab]&[Path]&[File]Code: Select all
&N&P&D&T&F&A&Z&F