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&FReplacing Page and Pages macros in Excel Headers and Footers
Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators
-
DataMystic Support
- Site Admin
- Posts: 2227
- Joined: Mon Jun 30, 2003 12:32 pm
- Location: Melbourne, Australia
- Contact:
Replacing Page and Pages macros in Excel Headers and Footers
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: