I want this statement to run upon opening my excel file. I have this code
located in the This workbook tab and i want it to call the Sub Main in the
Worksheet info if it is inbetween this time. I know this code isn't right
but can and how can you do this.

Private Sub Workbook_Open()
If Time "12:10:00" And Time < "12:30:00" Then Call Main
End Sub

Private Sub Workbook_Open()
If Time TimeValue("12:10:00 PM") And _
Time < TimeValue("12:30:00 PM") Then Call Main
End Sub

--
Regards,
Tom Ogilvy

"Lost and Looking for Help" wrote:

I want this statement to run upon opening my excel file. I have this code
located in the This workbook tab and i want it to call the Sub Main in the
Worksheet info if it is inbetween this time. I know this code isn't right
but can and how can you do this.

Private Sub Workbook_Open()
If Time "12:10:00" And Time < "12:30:00" Then Call Main
End Sub

Hi

One way among several:

Select Case Time
Case TimeSerial(12, 10, 0) To TimeSerial(12, 30, 0)
Call Main
Case Else
End Select

HTH. Best wishes Harald

"Lost and Looking for Help"
skrev i melding
...
I want this statement to run upon opening my excel file. I have this code
located in the This workbook tab and i want it to call the Sub Main in the
Worksheet info if it is inbetween this time. I know this code isn't right
but can and how can you do this.

Private Sub Workbook_Open()
If Time "12:10:00" And Time < "12:30:00" Then Call Main
End Sub