Excel save date
 

I need to have a function in Eexcxel that will Automatically capture the save
date (like in Word) for version control. Format would be MMMM/DD/YYYY HH:MM
and would like it to be in footer. Please indicate the steps to program it
into excel as well.

Thank You

Dave

Excel save date
 

Turn on the macro recorder and record yourself setting a footer. Then turn
off the macro recorder. Then just alter the code to concatentate some text

"current text " & format(now,"mmmm/dd/yyyy hh:mm")

You could then move that code to the beforesave event.

See Chip Pearson's page on events.

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

"Dave" wrote in message
...
I need to have a function in Eexcxel that will Automatically capture the
save
date (like in Word) for version control. Format would be MMMM/DD/YYYY
HH:MM
and would like it to be in footer. Please indicate the steps to program it
into excel as well.

Thank You

Dave

Excel save date
 

MsgBox ThisWorkbook.BuiltinDocumentProperties("Last save time")

Note that if the file has never been saved this will throw an error...
--
HTH...

Jim Thomlinson


"Tom Ogilvy" wrote:

Turn on the macro recorder and record yourself setting a footer. Then turn
off the macro recorder. Then just alter the code to concatentate some text

"current text " & format(now,"mmmm/dd/yyyy hh:mm")

You could then move that code to the beforesave event.

See Chip Pearson's page on events.

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

"Dave" wrote in message
...
I need to have a function in Eexcxel that will Automatically capture the
save
date (like in Word) for version control. Format would be MMMM/DD/YYYY
HH:MM
and would like it to be in footer. Please indicate the steps to program it
into excel as well.

Thank You

Dave

Excel save date
 

As I recall, this property was not maintained by xl97. If the file is used
in both xl97 and higher versions, the value could be incorrect (updated in
later versions, but not in xl97). If it is only used in xl97, it would
raise and error.

Of course, the OP could maintain the property.

Chip Pearson's page on Builtin Document properties
http://www.cpearson.com/excel/docprop.htm
--
Regards,
Tom Ogilvy


"Jim Thomlinson" wrote in
message ...
MsgBox ThisWorkbook.BuiltinDocumentProperties("Last save time")

Note that if the file has never been saved this will throw an error...
--
HTH...

Jim Thomlinson


"Tom Ogilvy" wrote:

Turn on the macro recorder and record yourself setting a footer. Then
turn
off the macro recorder. Then just alter the code to concatentate some
text

"current text " & format(now,"mmmm/dd/yyyy hh:mm")

You could then move that code to the beforesave event.

See Chip Pearson's page on events.

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

"Dave" wrote in message
...
I need to have a function in Eexcxel that will Automatically capture
the
save
date (like in Word) for version control. Format would be MMMM/DD/YYYY
HH:MM
and would like it to be in footer. Please indicate the steps to
program it
into excel as well.

Thank You

Dave

Excel save date
 

Just wondering... How do you know/remember all of these things...
--
HTH...

Jim Thomlinson


"Tom Ogilvy" wrote:

As I recall, this property was not maintained by xl97. If the file is used
in both xl97 and higher versions, the value could be incorrect (updated in
later versions, but not in xl97). If it is only used in xl97, it would
raise and error.

Of course, the OP could maintain the property.

Chip Pearson's page on Builtin Document properties
http://www.cpearson.com/excel/docprop.htm
--
Regards,
Tom Ogilvy


"Jim Thomlinson" wrote in
message ...
MsgBox ThisWorkbook.BuiltinDocumentProperties("Last save time")

Note that if the file has never been saved this will throw an error...
--
HTH...

Jim Thomlinson


"Tom Ogilvy" wrote:

Turn on the macro recorder and record yourself setting a footer. Then
turn
off the macro recorder. Then just alter the code to concatentate some
text

"current text " & format(now,"mmmm/dd/yyyy hh:mm")

You could then move that code to the beforesave event.

See Chip Pearson's page on events.

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy

"Dave" wrote in message
...
I need to have a function in Eexcxel that will Automatically capture
the
save
date (like in Word) for version control. Format would be MMMM/DD/YYYY
HH:MM
and would like it to be in footer. Please indicate the steps to
program it
into excel as well.

Thank You

Dave