ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Date Modified (https://www.excelbanter.com/excel-programming/376491-date-modified.html)

tom[_10_]

Date Modified
 
I'm sure this has been previously address, but I've been unable to find
a good answer.

I have a macro that will:

1) Open a file;
2) Change the Title, Category, Comments, etc. under Properties;
3) Save the file, and then
4) Close 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



All times are GMT +1. The time now is 01:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com