Tom,
Get the date last modified.
Change the system date to that date.
Save and close the file.
Change the system date back to current.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"tom"
wrote in message
I have a macro that:

1) Opens a file;
2) Changes the Title, Category, Comments, etc. under Properties;
3) Saves the file, and then
4) Closes the file.

Is there some code that I can insert into this macro to keep excel from
changing the "date modified". And if so, where would it be inserted?
Before or after saving?
Thanks for your help!
Tom