How can I print the workbooks full path and filename in a page header?
Amazingly, Microsoft continues to ignore what must amount to thousands of requests per year for this feature. The only way to print a workbook’s path in a header or footer is to use VBA. The best approach is to take advantage of the WorkbookBeforePrint event. For example, place the following subroutine in the code module for the ThisWorkbook object to print the workbook’s full path and filename in the left header of each sheet.
