Custom Header

G

Guest

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
 
J

Jim Rech

Only through a macro. Record one to get the syntax for setting a header
through code.

--
Jim Rech
Excel MVP
| 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
"&" in Custom Header 3
How can I use custom properties in an Excel header or formula? 5
How do I get the "&" to show in a name in a header in Excel? 3
Custom Header - poss to link to contents of cell? 7
can I use a cell's contents as part of a custom header? 1
File path not working correctly 2
Custom Footer 10

Top