B
buzzharley
I'm using this open_workbook macro-
Code:
--------------------
Private Sub Workbook_Open()
ImportData
End Sub
--------------------
I want it to only import the data if the workbook is opened between
9:30 pm and 9:40 pm
So I've been trying to use all diff types of time iff statements and I
can't figure out the right way to state it?
If Time >= "21:30:00", <="21:40:00"
then
but it won't let me put in the comma? I've also tried ( )'s!! Where
am I going wrong? Do I need to use NowTime or just Now? Any help
would be awesome-- Thanks- Mike
Code:
--------------------
Private Sub Workbook_Open()
ImportData
End Sub
--------------------
I want it to only import the data if the workbook is opened between
9:30 pm and 9:40 pm
So I've been trying to use all diff types of time iff statements and I
can't figure out the right way to state it?
If Time >= "21:30:00", <="21:40:00"
then
but it won't let me put in the comma? I've also tried ( )'s!! Where
am I going wrong? Do I need to use NowTime or just Now? Any help
would be awesome-- Thanks- Mike