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. :hi:

I moved your question to the Excel Forum. :moosegrin

[Killian]

Hi venky :hi:

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