Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
ebook!
Our Top 15 Excel Tutorials
Instant Access!
E-mail:
Subscribe for Free Excel tips & more!
E-mail:
Advertisements



How Do I Insert The Date Modified In A Spreadsheet Footer?

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

I'm trying to create an Excel report footer that contains the date that the
file was last modified. Does anyone have any suggestions?


View Answers     

Similar Excel Tutorials

Print the Current Date or Time in Excel
How to print the current date and or time on an Excel spreadsheet. This is a simple technique that allows you to di ...
Quickly Enter the System Date in Excel - Keyboard Shortcut
You can insert the system Date by holding the Control (Ctrl) key and pressing the colon or semicolon key. (Ctrl+;) ...
Get the Current Date in Excel
How to get the current date using Excel.  This method updates the date every day so that it is always accurate. To ...
Dates in Excel Explained
I'll explain how dates in Excel work and then point you to many useful tutorials on how to use dates and also time ...

Helpful Excel Macros

Format Cells in The Short Date Number Format in Excel
- This free Excel macro applies the Short Date number format to a selection of cells in Excel. This number format display
Return the ISO Standards Start of the Year in Excel - First Monday of the Year - UDF
- Return the date of the first Monday of any year with this UDF ISO Year function in Excel. This is a really simple and e
Create a 12 Month Calendar With The Current Day Highlighted in Excel
- Create a 12 month formatted calendar on a new tab in Excel with the current day highlighted. This macro creates a nicel
Format Cells in The Long Date Number Format in Excel
- This free Excel macro formats a selection of cells in the Long Date number format in Excel. The Long Date number format
Return the ISO Week Number from a Date in Excel - UDF
- Return the ISO Week Number in Excel with this UDF. This is a simple to use UDF (user defined function) that returns the

Similar Topics







I have a footer that I place in all my Word documents it goes a little something like this:

Created by (insert name) on (insert dated) - Last modified by (insert name) on (insert date)

I would really like to design an excel footer that does the same thing but I can't work out how.

Any suggestions?


How do I enter the date last modified in the footer of an Excel document?
I want to be able to distribute a monthly or weekly report in Excel to users
and have it automatically update the date last modified in the footer each
time I update the report.



Hi,

I am after a macro that i can use on and spreadsheet to add a footer that shows:
Name of file, date & time printed, date last modified

Thanks in advance

Antony


I'm using Excel 2007.
I use a certain footer format frequently.
Date, filename, Page x of y.
When I go to Print Preview: Header/Footer there is a drop down box for Footer:. I was wondering if I could create my own definition and have it appear in that drop down box?

I've modified my Sheet & Book Templates to use this kind of footer. Which works fine when I create a new sheet. The problem I'm having is that I often use an application that has the ability to generate Excel sheets. Whenever I use that application to generate the sheet it appears that my Templates are ignored. So that is why I thought I might need to have my own footer definition.

Well, thanks for any ideas!


I am using the following code in a workbook:

Private Sub Workbook_Open()
ActiveSheet.PageSetup.CenterFooter = _
"Last Modified: " & ThisWorkbook.BuiltinDocumentProperties("last save time").Value
End Sub

It does a great job of changing the "Last Modified: " footer for each worksheet based on the last time I saved the document. However, I am seeing that the footer message on other worksheets will not change if I am not viewing those worksheets while I save.

Is there any way to modify this code so that the footer messages on all worksheets will change when I save the workbook?


Hello.

I'm having problems trying to get some uniformity in our documents. The problem is that all of our company Winword documents (thousands of documents) already have a table in the footer in which the following information is listed in sequential order:

Machine no.:
Filename:
Version:
Date:
Page x of x

The table is made up of 2 rows and 5 columns.
The bottom row is updated by the worker that processes the file.

Furthermore, we do not edit the winword footer but instead edit the document properties because there are fields in the winword footer that are connected to the document properties. In other words machine no., version and date are edited in the document properties and this changes the footer.

Can this be done in Excel with a footer?

I have found out how to insert the properties into the footer (in Excel), but not how to create a table in the footer.


I have three questions and I am hoping I haven't reached limitations of Excel.
1. I am setting up custom headers and footers on my worksheet. Is there anyway to adjust the space to the left of the left Header & footer and to the right of the right header and footer? Even with my margins set for .25 around the outside edge, if moves the left header in to about .7 or so and same from the right edge.
2. In my custom footer, is there any way to get around the 255 character limit in the center footer? I am trying to fit in a disclaimer and we all know how long disclaimers can be!
3. I would like to put a File Created date in my custom footer on the left. Not a modified or updated field, does anyone know the code I would need to do this?

If there are no answers to these I guess I could just not use the custom header and footer options and hardcode this stuff in the worksheet. But I thought I would ask the gurus first!

Thanks you for your help,
Excel Novice
Ryan Kohlbeck




Hi everyone.
I have a PO Template which I wish auto insert below information in the footer.
a) User Name
b) Create date
c) Last modify user
d) Last modify date
e) Print date
f) No of pages (Say Page: 1 of 3)

When the PO is issued, the softcopy will be saved in a Server.
In certain circumstance, the existing PO will required to be revised. Most cases, it might not be the same user who created this.
For tracking on identity, I wish the last modify user, date and print date to be captured and printed in the footer note?
Whether I can lock the footer information as well? So that all user will not be able to edit these information?

Hope someone could help..

Thanks.

Hi I want to use the last row as the footer since the footer has a character limit. So my macro inserts a text to the last row in column A then it hides it so it wont print that. But I get an error. Please help.

Code:

Sub footer()


n = Cells(Rows.Count, "a").End(xlUp).Row + 1
Cells(n, "a").Value = "THIS WILL INSERT THE LAST ROW AS THE FOOTER, MORE THAN 250 CHAR, MORE THAN 250 CHARTHIS WILL INSERT THE LAST ROW AS THE FOOTER, MORE THAN 250 CHAR, MORE THAN 250 CHARTHIS WILL INSERT THE LAST ROW AS THE FOOTER, MORE THAN 250 CHAR, MORE THAN 250 CHARTHIS WILL INSERT THE LAST ROW AS THE FOOTER, MORE THAN 250 CHAR, MORE THAN 250 CHARTHIS WILL INSERT THE LAST ROW AS THE FOOTER, MORE THAN 250 CHAR, MORE THAN 250 CHARTHIS WILL INSERT THE LAST ROW AS THE FOOTER, MORE THAN 250 CHAR, MORE THAN 250 CHARTHIS WILL INSERT THE LAST ROW AS THE FOOTER, MORE THAN 250 CHAR, MORE THAN 250 CHAR"
Cells(n, "a").Font.Italic = True
Cells(n, "a").EntireRow.Hide = True

With ActiveSheet.PageSetup
.LeftFooter = Range(Cells(n, "a"))

End With
End Sub







Searching through the forum, I have found several types of "code" that will make Excel provide the last modified date (not to be confused with the last saved date). However, I am missing the middle step. What do I do with this code to use within Microsoft Excel?

Thus, can anyone provide step by step instruction on how to add the last modified date, as a footer to an excel worksheet, and where in the workbook should the "code" be kept?

These are the hyperlinks to the "code" I have located thus far.
Answer Number One:
Website: http://www.excelforum.com/excel-gene...fied-date.html
Answer:I have the following code in my Book.xlt file, but you can add it to your file. It needs to be in "This WorkBook", not in a module. If the file is new, you might have to save it twice before it appears in the footer. It doesn't mention the User, just the date/time it was last updated.

Answer Number Two:
Website: http://office.microsoft.com/en-us/ex...010218996.aspx
Answer: Create Custom Functions in Excel 2007 using VBA
[U][U]Answer Number Three:
Website: http://www.mrexcel.com/archive/Dates/17403b.html
Answer: You can add this as a User Defined Function:



Please Login or Register  to view this content.



You can insert the date field in the header or footer of the page setup so the current date always appears on the printed report. Go to File > Page Setup > Header/Footer and select the icon for date.

The date is formatted M/D/YY, so today's date would appear as 1/2/08

Can the formatting be changed to any other date formats already available in Excel? For example, "Wednesday, January 2, 2008"

I heard the default formatting for the date can be changed in one place that affects the formatting of the date in headers and footers in all Office applications (Word, Excel, Outlook, etc.) but I have no idea where this global setting might be.


Is there a way to have excel change the name in the footer of a spreadsheet
to the name of the person who last modified the the spreadsheet and also the
time of the last change. Not the time it was last viewed... but specifically
modified.



I want to put the last saved/modified date in a cell within a worksheet. I want this date to represent the last date the file was modified including the current date if I'm about to save the file which has just been modified. Can anyone help. Using Excel 2007.
thks


I would like to automatically insert Date Created & Date Modified into Excel Spreadsheet (Date Created & Date Modified of the same spreadsheet), however I can not find any formula for system type date fields. Any ideas?"




I am creating a spreadsheet with 33 tabs. Each tab represents individual departments.

Each will have data modified at different times and I would like the last date modified to be seen on the spreadsheet. This workbook will be used amongst several people and we need to know when it was last modified to avoid confusion.

Thank you!

I have a spreadsheet that works as a contract for various clients. In the footer, it shows the current date. That date is also supposed to represent the when the contract was initially offered.

When I send this form to my client or a representative, I would like for the footer to change from &[date] to whatever the date I assigned the contract. So, if I were to open the contract, it would read with today's date. I would assign it. Tomorrow, I want it to still read today's date.

Any ideas?

Thanks.


Hi am using the following macro to insert my footer. It works great, but How can I make it also insert the date and time into the left footer after the workbook name?

Code:

Sub PathFooter()
With ActiveSheet.PageSetup
.LeftFooter = "&""Arial,Regular""&9" & ActiveWorkbook.FullName
End With
End Sub


Thank you.


I have this Excel file that I get periodically and I need to print it in my own printhead letter. Thus, I need to add a fixed header&footer.
Of course, I don't have to do this with every excel file I get, therefore I am thinking about a button in the quicktoolbar that I click when I want to add that specific Header&Footer.

I have 2 issues so far:
1) Although there's no image in my footer & header, The footer is longer than 255 chars, and apparently Excel doesn't allow more than those. I have different fonts & size in the header and footer themselves.
2) I managed to save the header & footer I want as images (from Word) in an Excel file, but then I don't know the VBA code to tell Excel "open this file and copy its footer and header".

I tried to search on the forum and over the internet but no luck so far. Any help?
Thanks guys!




Hi Guys

I want to set Left header,Center header,Left footer,Center footer and right Footer in the sheet that gets printed off when a button is clicked on the userform.
So I want the following header n footer:

Left Header: Recorded Delivery Consignment
Date:

* Now the date in above will come from the userform comboboxes as Format(DateSerial(ComboBox3, ComboBox2, ComboBox1), "dd/mm/yyyy")
Center Header: AXA Company ,London
0789898989898
0777676627672

Left Footer: Total number of records:

* In above footer on each sheet will store total number of records so count function will be used.
Center Footer: Accepting Officer Signatu ........
Right Footer: Date:


Many Thanks

I want that whenever I open a new excel file, current date should be inserted at the Right footer of every sheet.
How can I do so?
I made an Addin and installed the same but nothing is working: ie No date in the footer comes whenever I open new excel file.
Code:

Private Sub Workbook_Open()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Sheets
ws.PageSetup.RightFooter = "&D"
Next
End Sub


How can I do so?


Hello,

I am trying to find a way to insert a custom header and footer that I have to use for all company documents into excel. The current options under the header and footer tools in excel do not achieve this. The header and footer I am using has 3 and 8 fields consecutively, contains a logo, borders, filepath etc, dates, revisions, pages, etc. Does anyone know of anyway to create a truly custom header and footer in excel? I apprciate any help, thanks!!

Joel


My last place of employment had a great footer macro/add-in. When it was run, a dialog box would open with several options that you could select with a check box. The macro would be run simply by pressing a command button that was tied to the macro/add-in. The selections on the dialog box looked something like below:

Sheets to apply footer to:
- Current Sheet
- All sheets in workbook

Left footer:
- File name and path
- Date and time

Center footer:
- Date and time
- Page X of Y

Right footer:
- Company name
- Last saved by
- Page X of Y

I've been able to write some very simplistic macros that accomplish a fixed placement of:
- File name and path
- Date and time
- Page X of Y

But I really liked the flexibility and simplicity of the macro that I had at my last place of employment.

Does anyone have something like this available?

Thx!


Dear All

I want to customise my header Footer by providing Names

as say center header : company name below that Annexure I

Left Footer: Place: aaaa below that Date: 30/05/2007
right footer: Name: abcd below that Designation: aaaaa


I want to provide these names in say a1 to a6 (center header a1 & a2, left footer a3 & a4, right footer a5 & a6)

how can I go about this?

Manoj


I have a custom footer with File Name and File path, my name and the date, I do not want others to change my files and show themselves as the owners of my files.

How can I make my custom footer my default footer?

How can I protect my custom footer from being changed to someone else's name?

Thank you.


I have an Excel document that I want to control the revision in the footer. In the footer I currently have Revised: &[Date] , lks The lks is the initials of the person who changed the document last. The problem with this is the person has to remember to go into the custom footer and add their initials.

Is there a command like &[Date] that pulls the person's username from Microsoft office automatically?

If not could a macro be created that would have a popup window that ask the person to enter their initials and then it would be entered into the footer? It would be really cool if it popped up when the person hit the save button but that might be harder.

Thanks