I'm glad you got it worked out. I realized when I saw FSt1's reply that I
left out the cell formatting to show the seconds. Sometimes, when one tried
to answer before anyone else, things get left out.

Best wishes,

Jim
--
Best wishes,

Jim


"Conan Kelly" wrote:

Jim,

Thank you for your help.

After some thinking (before anyone replied) I came up with something similar in its own sub procedure.

(0:01:09 to save to the old server, 0:00:08 - 0:00:09 to save to the new server)

Thanks again for the feedback.

Conan



"Jim Jackson" wrote in message ...
In your sub routine you could use:

Activecell = Now()
ThisWorkBook.Save
Activecell.Offset(1,0) = Now()
--
Best wishes,

Jim


"Conan Kelly" wrote:

Hello all,

What is the first event that occurs immediately after a workbook is done saving?

There is a Before_Save event, but there is no After_Save event.

I have a file that takes a while to save to the server. I wanted to time how long it takes to save. I thought about putting
"Activecell = Now()" in the Before_Save event, then activate the cell below it. Then when it is done saving, put "Activecell =
Now()" in the appropriate event procedure, but I don't know what that is.

If anyone has a better way of doing this or any other suggestions, I'm all ears

--
Thanks for any help anyone can provide,

Conan Kelly