View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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