Execute macro periodically

Newbie · Feb 25th, 2002, 11:59 AM

Please help!
I need to accomplish a task, which executes an excel macro automatically every month. Any advice on how to do it? Sample code would be very helpful. Thanks.

Mudface · Feb 25th, 2002, 12:41 PM

You could try this code which would run your macro if the workbook is opened on the first of a month (adapt it to your own needs): -

Private Sub Workbook_Open()

If Day(Now) = 1 Then Call YourMacro

End Sub

To enter it, go into the VB editor, click on the 'Workbook' entry in the Project Explorer in the left pane and paste in the above.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 25th, 2002, 11:59 AM	#1
Newbie New Member Join Date: Feb 2002 Posts: 1	Please help! I need to accomplish a task, which executes an excel macro automatically every month. Any advice on how to do it? Sample code would be very helpful. Thanks.

Feb 25th, 2002, 12:41 PM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	You could try this code which would run your macro if the workbook is opened on the first of a month (adapt it to your own needs): - Private Sub Workbook_Open() If Day(Now) = 1 Then Call YourMacro End Sub To enter it, go into the VB editor, click on the 'Workbook' entry in the Project Explorer in the left pane and paste in the above.