Getting the date from my left footer
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.
|