Link to home
Start Free TrialLog in
Avatar of mustish1
mustish1

asked on

Timer Control

Hi: I try to find Timer Control or Microsoft Timer control in the component window but i didnt find any thing like that. Can any one please tell me how to i find the timer control also is this code is correct?

Private Sub Form_Load()
'Timer1.Interval = 1000
End Sub

Private Sub Timer1_Timer()
    If Time = #8:00:00 AM# Then
      'readExcelFile
   End If
End Sub
Avatar of sirbounty
sirbounty
Flag of United States of America image

Code is correct- the timer is on your tool box - looks like a stop watch.
You need to remove the apostrophe to uncomment and make the code valid, of course...
Avatar of mustish1
mustish1

ASKER

Thanks. I try to find in the components
1.Microsoft Timer Control
2. Timer Control
I didnt find any of them in it
Are you working in VB6 or one of the Office applications?  It doesn't exist in Office VB...
In VB6
ASKER CERTIFIED SOLUTION
Avatar of sirbounty
sirbounty
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Ah. Thank You Sir Bounty.
Glad I could help! :^)