Re: Excel-RS232 via Cheapcomm: Where?

antedeluvian51 wrote:

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.


I am not a fan of .NET. It seems to have serious backwards compatibility issues. Case in point: New scope SW came, must have .NET. Installed 2.0, did not work. Inquired -> Must use 1.1 because 2.0 is not compatible. Great. <shaking head>

What I am trying to do is access instruments via RS232, mostly through a virtual serial port on a USB connection. But it has to run at other places and many are using older Excel licenses. So it has to work all the way back to '97. It is possible since several instrument makers provide exactly that. However, their SW is not open and so it cannot be adapted to any instruments other than what they are selling. Technically yes, of course, but it would violate their copyright. I guess they are going directly via the API.

--
Regards, Joerg

http://www.analogconsultants.com
.

Relevant Pages

  • 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)
  • RE: Usage of serial port in VBA ( exel )
    ... communications control (Microsoft Communications Control, ... Unfortunately Excel makes it almost impossible to do serial ... Software Wedge is an executable program that can pass serial data back ...
    (microsoft.public.excel.programming)
  • RE: URGENT- Form design and field tab-order problems
    ... creating an Excel User Form, but this would require you to get into the ... there is a TabIndex property for each control you could set. ... A requester sent several Excel files that have been formatted to print ... The reason the forms are in Excel is that all service techs already ...
    (microsoft.public.excel.misc)
  • Re: Word doc in VFP
    ... Or maybe you need revision control system, ... Just save the Word.doc or Excel. ... command button on a form that calls that Word file and opens it up in ... in the begining and then changed to OleBound with general field. ...
    (microsoft.public.fox.vfp.forms)