Set a file's modified date?
 

I found where I had a misspelling in the reports I was generating with VBA
for Excel.

I can write a routine to open each of the reports (there are over 200), and
correct the misspelling, but when I save them, that will modify the date the
file was last modified.

I'd like to:

open the file
read the date modified
correct the misspelling
save the file
reset the file's modified date to the one I read above


Is this possible? And if so, how would I do that?

Ken

Set a file's modified date?
 

Reset date/time (!)


As you see, I did not!!

---
Regards,
Norman



"Norman Jones" wrote in message
...
Hi Ken,

One way,

Change your system date/time
Run your routine
Reset date/time (!)

---
Regards,
Norman



"Ken Loomis" wrote in message
...
I found where I had a misspelling in the reports I was generating with VBA
for Excel.

I can write a routine to open each of the reports (there are over 200),
and correct the misspelling, but when I save them, that will modify the
date the file was last modified.

I'd like to:

open the file
read the date modified
correct the misspelling
save the file
reset the file's modified date to the one I read above


Is this possible? And if so, how would I do that?

Ken