Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Serial I/O
Duane - I'm definitely interested in your sample Excel
with serial VBA. Could you send it to me? I have Ofiice 2000 Professional edition - how do I know I have the license to use MSComm? Cheers Karl -----Original Message----- Actually you can do serial I/O is Excel pretty easily using VBA as long as you have a license to use the MSComm Control. I wrote an application and created an InstallShield Installation to install the MSCOmm ActiveX Control. I have an example Excel spreadsheet with VBA code for managing serial I/O. Drop me an email if you are interested and I'll email it to you. I've used this technique for a number of project for serial communications to PIC and Atmel processor, and simulations of these processors on other PC's. I've even used it for multiple serial ports (two). Works with USB virtual comm ports are well. Duane Mattern Boston, MA USA - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - On Wed, 28 May 2003 21:57:26 GMT, (Thomas Lutz) wrote: There is no easy way to do serial I/O directly in Excel without using a 3rd party tool. The easiest tool for doing simple RS232 serial I/O directly in Excel would be a product called WinWedge from TAL Technologies. For more information on WinWedge visit: http://www.taltech.com - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - On Sun, 25 May 2003 00:23:36 -0700, "Dave Y" wrote: Can anyone point me in the direction of some VBA code that will allow me to send strings of characters to a Serial port and read strings (or single bytes) back please? I have done a lot of searching adn other than commercial packages, have found little of use. Thanks Dave Y Brisbane downunder . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
serial no | Excel Discussion (Misc queries) | |||
serial numbers | Excel Worksheet Functions | |||
Time Serial | Excel Discussion (Misc queries) | |||
Auto Serial No | Excel Discussion (Misc queries) | |||
Serial No. | Excel Discussion (Misc queries) |