Is it possible to print the file modification date from excel? 2

[rafe]

Hi,

I need to keep track of the numberous revisions of excel budgets we do around here. What I'd like to do is have a file modification date (not print date) show up in the header/footer/anwhere in the budget. Is this possible? I'm kind of hoping I missed the obvious.

rafe

 

[dsi]

By 'modification date' are you referring to the date the file was last saved?

 

[kathryn]

There are two ways to do this, I believe. There is a FileDateTime Function in VBA, that you may be able to use. Excel also supports version control, which it refers to as tracking changes. You might be able to get the info using that.

 

[rafe]

tclere: Yes. Sorry if i wasn't clear... i'll work on that

kathryn: thanks, i'll look into your suggestions

 

[Caren]

I am not a visual basic programmer. I also want to display the date last modified. How can I do that in Excel? Kathryn, have you been successful in doing this? How? [sig][/sig]

 

[dsi]

Goto the VB editor, add a module, then add this code.

Function LastModifiedDate() As Date
LastModifiedDate = CDate(FileDateTime(ActiveWorkbook.FullName))
End Function

Then, select the cell on the worksheet in which you want the date to appear. Format the cell to the date format of your choice. Select Insert > Function. Pick the LastModifiedDate function and hit OK. OK the next screen as well. This will be updated everytime the sheet is recalculated.

Hope this helps! [sig][/sig]