Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
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)