MSComm Timeout

Posted on 2003-12-02
Last Modified: 2008-02-01

I have an VBA application that talks to a serial device, which acts as a converter and talks to another device. I would like a way for the application to timeout if it doesn't recieve a response in a certain period of time.

The trouble with the timeouts built in to mscomm (that I know of) is that they will only detect if the serial device is there when the app is transmitting, but I need to know if the third device is not responding.

Thanks and sorry if I wasn't clear enough.
Question by:Dormouse31
  • 2

Accepted Solution

mazfar earned 125 total points
ID: 9862756
I dont know if it answers your question but its a kind of work around.

Put a timer control and set it to whatever is your max waiting time at the port. Whenever you do a serial port open, activate the timer. When the specified interval passes, the timer event will fire and you can close the port (or do whatever u want to here). In the MSCOMM oncomm event, reset the counter (so as whenever you receive anything timer starts again).

I hope I was able to explain my solution.


Author Comment

ID: 9863085
I thought of the timer idea, but there isn't a timer in the VBA toolbox. How do you use a timer in a VBA App?

Expert Comment

ID: 9869740
Check this link to use timer API to replicate timer functionality in VBA.

Have a nice day.
LVL 29

Expert Comment

ID: 10212185
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Answered mazfar
Please leave any comments here within the next seven days.


EE Cleanup Volunteer

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VBA saving file message display 5 72
Adding to a VBA? 6 77
vb6 connector to SQL Server 2 37
Copy a range from 1..n excel sheets to one destination sheet 2 56
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question