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

Do a search for "datelastmodified" and look through those posts, I
think that this search will get you closer to the answer. I'm not sure
if you can do it but someone out there might have found a way. I'll
keep looking on my end to see if it's possible. If you do find the
answer make sure to post it so that everyone can benefit.


Sandy

tom wrote:
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

See this post:

http://groups.google.com/group/micro...a273ad6a10a342

If the link doesn't work here search for this header

How to Change the DateLastModified property, or the CreateDate property

From: Marc B. Hankin
Date: Sat, Jan 15 2005 1:55 pm


Sandy

tom wrote:
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

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