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
|