Re: Excel-RS232 via Cheapcomm: Where?


VBA within Excel is such a great idea. Why did they leave it lacking so
much in connectivity? MS could sell a whole lot of copies for lab and
production PCs if it wasn't so difficult to connect hardware. Right now
everyone defaults to LabView, DAQFactory and SW like that, or they just
don't do anything at all if the expense isn't warranted.

Joerg,

I am ashamed to admit that I don't know if the latest versions of MS Excel
use VB.net. VB.net (at least the free version VB2005 Express) does not
support use mscomm, but has its own serial port control which does not
appear to need additional registration. The control itself is lacking in a
few features, but if Excel now uses VB.net this could be your answer. For
what it is worth I wrote an article on VB2005 Express and the Serial Port
in the December 2006 issue of Circuit Cellar (issue 197).

Actually, I am not sure what you are trying to do. You could turn your
approach around and create your application in VB.net and then control
Excel from VB to achieve your ends. The above article was actually part of
a series in which I created a Modbus interface using the above approach.
The series was completed in issues 200 and 201.

-Aubrey
.

Relevant Pages

  • Re: RS232 problem on HYUNDAI HIT 18-S
    ... You have right with those settings, but the serial port replies too fast. ... If there are wrong transmission settings the hardware should first try and we should feel the delay. ... I set correct transmission parameters from operator's manual and use proper program on PC. ... The control is Sinumerik 840C made for HYUNDAI. ...
    (alt.machines.cnc)
  • Re: Serial Port Problem - Works under Cygwin not under Suse 9.2
    ... data from the serial port on multiple linux machines. ... There's only a three wire RS232 connection, no hardware or software ... control, 8N1. ...
    (comp.os.linux.development.system)
  • Exporting a single app from Win9x to X session
    ... I've got a couple of ancient apps that only run under win9x. ... But they are tied to hardware. ... control of a serial port and the other needs a parallel port. ...
    (comp.os.linux.misc)
  • Re: Userform causes Excel to crash
    ... 1.You may delete the multipage control & recreate new one. ... Shailesh Shah ... If You Can't Excel with Talent, ... Excel does not crash if I include the following code in front of the above ...
    (microsoft.public.excel.programming)
  • Re: Need to use VBA to put image on a form
    ... The embedded OLE object with Excel automation sounds workable. ... Earl Kiosterud ... Note: Some folks prefer bottom-posting. ... the OP can place an Image control, ...
    (microsoft.public.access.formscoding)