If between the times of.....

[ermccarthy]

I have a workbook that I am having MS Scheduler open every night at 3:00 am, which triggers an auto_open macro that runs.

I want to put some code in the macro that says if it is between 2am and 6am according to my system clock then run macro, if not then the macro ends. This will allow me to enter the workbook during business hours without the macro preforming its duties and uploading various information in it.

Any ideas? Any help would be greatly appreicated!

 

[Nimrod]

Private Sub Workbook_Open()
If Time > #3:00:00 AM# And Time < #6:00:00 AM# Then
MsgBox "this is a test"
End If
End Sub


NOTE:
Another idea would be to open the workbook while calling a particular macro within it , at the same time
example "'Demo.xls'!Hiderows"

The above line opens a workbook called Demo and acitvates it's macro called "hiderows at the same time.

Then you don't have to put your code in the On Open event code :wink:

 

[Yogi Anand]

I have a workbook that I am having MS Scheduler open every night at 3:00 am, which triggers an auto_open macro that runs.

I want to put some code in the macro that says if it is between 2am and 6am according to my system clock then run macro, if not then the macro ends. This will allow me to enter the workbook during business hours without the macro preforming its duties and uploading various information in it.

Any ideas? Any help would be greatly appreicated!

Hi Russell:

How about incorporating something like ...

if TiMe <#3:00# or Time >#6:00# then exit sub

I hope this helps