autosave before close

[J_J]

Hi,
Can someone please remind me the VBA code for autosaving the active workbook
with the same name without beeing prompt by windows ("do you want to save
the changes you made to "aaa.xls") ?
TIA
J_J

 

[Guest]

hi,
In the workbooks before close event put
private sub
ActiveWorkbook.Save
end sub

 

[J_J]

Thanks anonymous,
Unfortunately now when I use the below code
--------
Private Sub Workbook_BeforeClose()
ActiveWorkbook.Save
End Sub
--------
I am getting a Compile error with
"Procedure declaration does not match description or event procedure having
the same name"
Hope we can correct this.
J_J

 

[Guest]

hi again,
I just posted your code in a blank workbook and tested it.
open and closed it 3 times and adding non-sense data to it
and each time it auto saved.
the command ActiveWorkbook.save i use in many many file
without flaw.
i am at a loss.
i don't know what the error message means nor what to do
about it.
repost the code. maybe someone else can explain it. I
would like to know myself.