The following header and footer data codes are defined by Microsoft and can be used in any Excel workbook:
Code  | 
  | 
Data  | 
&[Date]  | 
  | 
Date printed  | 
&[File]  | 
  | 
File name  | 
&[Page]  | 
  | 
Page number  | 
&[Pages]  | 
  | 
Total number of pages printed  | 
&[Path]  | 
  | 
File path  | 
&[Picture]  | 
  | 
Image file  | 
&[Tab]  | 
  | 
Sheet name (text on its tab)  | 
&[Time]  | 
  | 
Time printed  |