Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try replacing "02:00:00" with .0833333333 or (1/12)