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

Post Reply
User avatar
DataMystic Support
Site Admin
Posts: 2280
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 » 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:

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
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

Post Reply