View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default the first event that occurs after a file is done saving?

hi,
try something like this. just change the file path to your file path.
Sub macTimer()

' Macro written 11/8/2006 by FSt1

Range("A1").FormulaR1C1 = "=NOW()"
Range("A1").NumberFormat = "h:mm:ss"
ActiveWorkbook.SaveAs Filename:= _
"C:YourFilePathGoesHere\deleteme.xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False _
, CreateBackup:=False
Range("B1").FormulaR1C1 = "=NOW()"
Range("B1").NumberFormat = "h:mm:ss"
End Sub

regards
FSt1

"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