Macro VBA Help

Wed, 27 Nov 2013 11:10:31 GMT

Hi All

I have a macro that reloads the data when the QV is opened.

What I now want to do, is make the VBA macro initialise only if the time is < 02:00:00. Otherwise I want want the code to run.

what am I doing wrong? see below

sub AutoReload ()

IF time() < "02:00:00" THEN ActiveDocument.Reload

END IF

End Sub

Re: Macro VBA Help

m_woolf — Wed, 27 Nov 2013 14:58:54 GMT

Try replacing "02:00:00" with .0833333333 or (1/12)