Aj,
I read the below attached code
I have some questions about it, as i am keen to learn
application.ontime event
Why did we repeat the following line of code
Application.OnTime TimeValue("20:20:00"), "Close_and_Save"
in both Workbook_Open event and the Close_And_SAve sub?
Is it important to do
Dear Sacha,
Open VBA > ThisWorkbook and paste this code -
*Private Sub Workbook_Open()
Application.OnTime TimeValue("20:20:00"), "Close_and_Save"
End Sub*
Now modify your Close_and_Save module as below -
*Sub Close_and_Save()
Application.OnTime TimeValue("20:20:00"), "**Close_and_Save**"
A
Hello Dear
Please explain briefly or attached sample copy with detailed
comment,so that we can help you accordingly.
What you meant to do with transform.
Hope it Will Help
Happy To Help
:)
Shyam.
On Mon, Mar 8, 2010 at 6:01 PM, Sach1810 wrote:
> Hi,
>
> I would like to transform the following
Hi,
I would like to transform the following macro so that it will work at
a set time
Sub Close_and_Save()
ActiveWorkbook.Close SaveChanges:=True
End Sub
help would be much appreciated
thanks
Sacha
--
--
Some imp
