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

Hi Ken,

One way,

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

---
Regards,
Norman



"Ken Loomis" <winken@u-b-kool.com> wrote in message
news:ulo6ERdfFHA.2152@TK2MSFTNGP14.phx.gbl...
>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
>
>

> Reset date/time (!)


As you see, I did not!!

---
Regards,
Norman



"Norman Jones" <normanjones@whereforartthou.com> wrote in message
news:%23zAwoZdfFHA.2472@TK2MSFTNGP15.phx.gbl...
> Hi Ken,
>
> One way,
>
> Change your system date/time
> Run your routine
> Reset date/time (!)
>
> ---
> Regards,
> Norman
>
>
>
> "Ken Loomis" <winken@u-b-kool.com> wrote in message
> news:ulo6ERdfFHA.2152@TK2MSFTNGP14.phx.gbl...
>>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
>>
>>
>
>