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


--
buzzharley
------------------------------------------------------------------------
buzzharley's Profile: http://www.excelforum.com/member.php...o&userid=35886
View this thread: http://www.excelforum.com/showthread...hreadid=558952