Insert file name into header

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need a macro or something that automatically insert the file name of the
excel file into the header or footer, does not matter which, i dont need the
directory path.

Either this or automatically insert into the header or footer the contents
of a specific cell in the worksheet. the cell address will never change., if
i create a new worksheet, same cell address needs to go into the header

thanks

pat
 
The ability to add the filename was added in xl2002. If you're using xl2k or
below, you can use a macro like Bernard suggests to put the filename in the
header/footer.

If you want to put the filename in a cell, you could use a formula:
http://contextures.com/xlfaqFun.html#SheetName
(From Debra Dalgleish's site)
 

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

Insert defined names in header/footer 9
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
Post contents of a cell in the header/footer 2
VBA - retrieve data on last create named range from previous inserted named range 0
filter on excel table with msquery and replaced header 1
Paste Cell Contents into Custom Header 2
What does the Header Footer add to filesize? 1
Insert Picture into header 2

Back
Top