![]() ![]() I'm slowly working through a site, a number of MicroSoft Knowledge Base articles, and code samples provided by Expert Exchange members, to get started writing actual subroutines. Now that I am familiar with the controller protocol, I'm moving on to VBA code. The controller resonds with an 'acknowledge' symbol, a 'negative acknowledge' symbol, or numeric data. The body of PC transmissions may have 1- or 2-letter commands, sometimes followed by numeric parameters. The controller responds with data, followed. Commands from the PC begin with a 'start of text' character and end with a 'carriage return'. ![]() ![]() The controller has its own serial protocol using ASCII characters. Since then, I have established communication with the controller using Hyperterminal. The work PC is actually hooked up to the serial device, a pump controller. I have succeeded in getting it on my home Windows XP machine where I write code, and a PC at work running Win' 98. Recently, I got helpful advice on how to install and register MSComm32.ocx for a serial communication project I am working on. For more information about WinWedge please visit. It also supports sending data out a serial port as well. WinWedge is an executable program that runs in the background and feeds serial data directly to other programs either by stuffing the keyboard buffer or by passing the data to other programs using Dynamic Data Exchange (DDE). The easiest way to get serial data into an Excel spreadsheet would be to use a 3rd party tool like WinWedge from TALtech. If you have it on your system but do not have Visual Studio 6 installed, it also will not work because you do not have a license to use it. Possible Hardware Sources USB to serial and/or parallel ports can be found at.Įxcel does not come with the MSComm ActiveX control- it is provided with Visual Studio 6. Download ZaberExcelVBdemo for some examples on MSComm in Excel. Well if you have Visual Basic (probably VB6) then bypass the next few attempts. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |