Pressing Shift-F5 when you open a document will take you to the last edit. You don't need vba for this.
IIRC, Office 2007 didn't originally support that, but it was fixed with a service pack. If not, see:
http://www.vbaexpress.com/forum/cont...you-re-open-it