but not the workbook that is open - that always has the date and time when
it was opened. It you open it read only I believe it will have its last
saved time.
Using a FileSystemObject, the GetFile method will return a File
object, from which you can query the DateLastModified property.
Bob
--
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.