Hi, Ker_01
Getting the revision date is not the problem. The date in the left foot is
not automatically updated with the revision date. So, Im trying to make a
trigger that will fire when saving or closing that will get the date from the
left footer and then compare it with the BuiltinDocumentProperties("Last Save
Time"). If no change than do nothing if different then update the left footer
with the BuiltinDocumentProperties("Last Save Time").

"ker_01" wrote:

I believe that the revision date in the footer comes from:

ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")

That is a date/time field, so you can format it according to how you want to
use it (just date, etc)

HTH,
Keith

"Still_learning" wrote:

Hi,
Im trying to get the date from my left footer. The date in the footer will
change over time.
In the footer it looks like this.
testBook.xls
Revised 7/30/2009
Im using this code to get the information, but now I need a way to either
put the last part of this string (the date) or something else that will get
me there.
textString = .LeftFooter
This is the line I used to get "&8&Fï�¡ï€*Revised 7/30/2009€�. (The square means
return.)
Im using office 2003.