Scheduling a Macro to Run
 

I know that i can set up Windows to run Excel at a certain time everyday or
week or what ever. I am wondering if there is a way to schedule excel to
open a file and execute a macro at a certain time each week.

Thanks,

Tim

Scheduling a Macro to Run
 

You can have windows open the excel file and have a macro in that excel
file that executes upon openning:

Private Sub Workbook_Open()

End Sub

Lost and Looking for Help Wrote:
I know that i can set up Windows to run Excel at a certain time everyday
or
week or what ever. I am wondering if there is a way to schedule excel
to
open a file and execute a macro at a certain time each week.

Thanks,

Tim


--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
View this thread: http://www.excelforum.com/showthread...hreadid=542515

Scheduling a Macro to Run
 

Hi Tim,

See:

http://www.cpearson.com/excel/ontime.htm


---
Regards,
Norman



"Lost and Looking for Help"
wrote in message
...
I know that i can set up Windows to run Excel at a certain time everyday or
week or what ever. I am wondering if there is a way to schedule excel to
open a file and execute a macro at a certain time each week.

Thanks,

Tim

Scheduling a Macro to Run
 

the workbook_Open event will fire when a workbook is opened, so put your code
in the workbook_open event and use the windows scheduler to have excel open
and open the workbook

Excel.Exe "C:\MyFolder\Myfile.xls"

runs excel and opens Myfile.xls

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"Lost and Looking for Help" wrote:

I know that i can set up Windows to run Excel at a certain time everyday or
week or what ever. I am wondering if there is a way to schedule excel to
open a file and execute a macro at a certain time each week.

Thanks,

Tim

Scheduling a Macro to Run
 

I would like to schedule the event to run at about 4:00 am. How can i have
it set up to run automatically if the time is between 4am and 5 am and run
manually if it is any other time? I just made up this code but it obviously
doesn't work

Sub Workbook_Open()
If Time 3 and Time < 5 Then Call CommandButton1_Click
Else
End Sub


CommandButton1_Click is the Sub that runs the program


"Tom Ogilvy" wrote:

the workbook_Open event will fire when a workbook is opened, so put your code
in the workbook_open event and use the windows scheduler to have excel open
and open the workbook

Excel.Exe "C:\MyFolder\Myfile.xls"

runs excel and opens Myfile.xls

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"Lost and Looking for Help" wrote:

I know that i can set up Windows to run Excel at a certain time everyday or
week or what ever. I am wondering if there is a way to schedule excel to
open a file and execute a macro at a certain time each week.

Thanks,

Tim

Scheduling a Macro to Run
 

I would like to schedule the event to run at about 4:00 am. How can i have
it set up to run automatically if the time is between 4am and 5 am and run
manually if it is any other time? I just made up this code but it obviously
doesn't work

Sub Workbook_Open()
If Time 3 and Time < 5 Then Call CommandButton1_Click
Else
End Sub


CommandButton1_Click is the Sub that runs the program

"Ikaabod" wrote:


You can have windows open the excel file and have a macro in that excel
file that executes upon openning:

Private Sub Workbook_Open()

End Sub

Lost and Looking for Help Wrote:
I know that i can set up Windows to run Excel at a certain time everyday
or
week or what ever. I am wondering if there is a way to schedule excel
to
open a file and execute a macro at a certain time each week.

Thanks,

Tim


--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
View this thread: http://www.excelforum.com/showthread...hreadid=542515

Scheduling a Macro to Run
 

Sub Workbook_Open()
If Time TimeSerial(3,0,0) and Time < TimeSerial(5,0,0) Then
MyMacro
End if
End Sub

? timeserial(3,0,0)
3:00:00 AM

I would put the code in a general module and have the commandbutton call
that macro as well.

Private Sub commandButton1_click()
MyMacro
End Sub


--
Regards,
Tom Ogilvy



"Lost and Looking for Help" wrote:

I would like to schedule the event to run at about 4:00 am. How can i have
it set up to run automatically if the time is between 4am and 5 am and run
manually if it is any other time? I just made up this code but it obviously
doesn't work

Sub Workbook_Open()
If Time 3 and Time < 5 Then Call CommandButton1_Click
Else
End Sub


CommandButton1_Click is the Sub that runs the program


"Tom Ogilvy" wrote:

the workbook_Open event will fire when a workbook is opened, so put your code
in the workbook_open event and use the windows scheduler to have excel open
and open the workbook

Excel.Exe "C:\MyFolder\Myfile.xls"

runs excel and opens Myfile.xls

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"Lost and Looking for Help" wrote:

I know that i can set up Windows to run Excel at a certain time everyday or
week or what ever. I am wondering if there is a way to schedule excel to
open a file and execute a macro at a certain time each week.

Thanks,

Tim