Replacing Page and Pages macros in Excel Headers and Footers

Discuss WordPipe, ExcelPipe and PowerPointPipe. Get help with installation and running, notify us of bugs, request new features and enhancements.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
User avatar
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

Post 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
Post Reply