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
|