scheduled events

[ridgetown_rick]

Is there a way to have Excel open and run a macro unattended on a daily basis?

 

[oldham94l]

you could use windows task scheduler to open the workbook, you will need to put the macro in the work book code,

Private Sub Workbook_Open()

'enter code here


ThisWorkbook.Close SaveChanges:=True

End Sub

note you will need to set macro security to low or it will ask to enable macros each time it opens

 

[straus]

Private Sub Workbook_Open()

'enter code here


ThisWorkbook.Close SaveChanges:=True

End Sub

could this code be changed to get the macro to run at 7:00 a.m. daily?

thanks