| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Custom Header
Is it possible to reference just part of the file name or use a formula in
the custom header field? I want to make part of the Custom Header so that it references the Month from the file name. For example: File Name - InvoiceUploadDec04Roch Custom Header: Invoice Upload Dec 04 |
|
#2
|
|||
|
|||
|
Only through a macro. Record one to get the syntax for setting a header
through code. -- Jim Rech Excel MVP "Josh O." wrote in message ... | Is it possible to reference just part of the file name or use a formula in | the custom header field? | | I want to make part of the Custom Header so that it references the Month | from the file name. | For example: File Name - InvoiceUploadDec04Roch | Custom Header: Invoice Upload | Dec 04 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting custom chart causes plot area to collapse | Charts and Charting in Excel | |||
| How do I create a custom scroll bar on a 3D Pivot Chart? | Charts and Charting in Excel | |||
| One header for all worksheets in workbook | Excel Discussion (Misc queries) | |||
| Shortcut for Filter- Custom Autofilter | Excel Discussion (Misc queries) | |||
| Same Cell Header For Every Page | Excel Discussion (Misc queries) | |||
Hybrid Mode
