Sleeper: Serial Port and Timer (sleep or delay)

[venkyhyd]

Hi ! ! !

I am new to VBA and to this forum as well. I am stuck with some probs in my VBA with Excel based application. Here I have got a requirement where in should open a serial port and keep sending the data continuously, for every 1 sec or more. I am able to open the port but unable to find proper help on sending data in intervals, like setting the Sleep or delay times. Hope I can get some guidance in achieving my task.

Thanks in advance
venky

[Jacob Hilderbrand]

One method.

Option Explicit
 
Sub Macro1()
Dim MyTimer         As Double
MsgBox "Step 1"
    MyTimer = Timer
    Do
    Loop Until Timer - MyTimer > 1
MsgBox "Step 2"
    MyTimer = Timer
    Do
    Loop Until Timer - MyTimer > 1
MsgBox "Step 3"
    MyTimer = Timer
    Do
    Loop Until Timer - MyTimer > 1
End Sub

[venkyhyd]

One method.

Option Explicit

Thanx shall try this suggested method.

Thanks once again
venky

[MOS MASTER]

Welcome to VBAX Venky.

I moved your question to the Excel Forum.

[Killian]

Hi venky

I did a similar thing once to read in data from a GPS using a couple of WinAPI functions to set up an accutare timer. I've attached a file with the basis of the code I used for it. Hope it helps