autosave before close
 

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

autosave before close
 

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

-----Original Message-----
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


.

autosave before close
 

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

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

-----Original Message-----
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


.

autosave before close
 

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.


-----Original Message-----
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

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

-----Original Message-----
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


.



.