Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro VBA Help

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

1 Reply
m_woolf
Master II
Master II

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