Excel-RS232 via Cheapcomm: Where?
in [Embedded]
|
Prev: About NXP TDA8007 (smart-card chip controller)
Next: GNUARM multiple definition of AT91F_AIC_ConfigureIt
From: The Real Andy on 23 Sep 2007 06:10 On Fri, 21 Sep 2007 14:33:06 -0400, CBFalconer <cbfalconer(a)yahoo.com> wrote: >antedeluvian51 wrote: >> >> mscomm32.ocx is often a headache. The only sure way is to install >> VB6 (I am not sure if you need the professional or enterprise >> editions for the registration to occur). You can in fact uninstall >> VB6 immediately afterwards without ever having used it, and the >> registration will still stick. I guess you could do this with a >> borrowed copy without violating the copyright. > >I fail to see any reason for anyone to put up with these >shenanigans. Linux is still available, at a reasonable price, with >a reasonable license. What has that got to do with the OP's question? Why is it that linux bigots can never answer the question, but rather just dodge it with some completely irrelevant drivel. If Joerg wanted to use linux, then Joerg would have used linux because Joerg is more than competent to do so, but that is not what was asked. To deal with the original question, the mscomm ocx can be used if the application is packaged, but unfortunately you will need a copy of VB to do this. The other solutions is to track down the registry key that mscomm uses to validate itself buy using a regmon (sysinternals) or whatever the new version is called. Failing all of that, then you can use the win32 api, but this would be a pain in VB if you don't have a great deal of interfacing with the API.
From: Joerg on 23 Sep 2007 20:16 The Real Andy wrote: > On Fri, 21 Sep 2007 14:33:06 -0400, CBFalconer <cbfalconer(a)yahoo.com> > wrote: > > >>antedeluvian51 wrote: >> >>>mscomm32.ocx is often a headache. The only sure way is to install >>>VB6 (I am not sure if you need the professional or enterprise >>>editions for the registration to occur). You can in fact uninstall >>>VB6 immediately afterwards without ever having used it, and the >>>registration will still stick. I guess you could do this with a >>>borrowed copy without violating the copyright. >> >>I fail to see any reason for anyone to put up with these >>shenanigans. Linux is still available, at a reasonable price, with >>a reasonable license. > > > What has that got to do with the OP's question? Why is it that linux > bigots can never answer the question, but rather just dodge it with > some completely irrelevant drivel. If Joerg wanted to use linux, then > Joerg would have used linux because Joerg is more than competent to do > so, but that is not what was asked. > Right, no Linux here. This has to work on client's PCs and their IT staff would roll on the floor holding their bellies if I suggested they change out the OS on a number of PCs. On a side note Linux seems to cause some quirks in cooperation with Windows systems. For example, when I want to unzip a file that resides on the Linux-based LAN drive here I usually receive the error message "not a zip file". After moving it over to a Windows PC the same file unzips just fine. > To deal with the original question, the mscomm ocx can be used if the > application is packaged, but unfortunately you will need a copy of VB > to do this. The other solutions is to track down the registry key that > mscomm uses to validate itself buy using a regmon (sysinternals) or > whatever the new version is called. > That key is given in the link Aubrey posted. However, I am not sure whether this method is fully legit from a copyright POV. At least I could imagine that some IT guys would raise an eyebrow and decline to do that. Usually those are the folks who would have to do a registry edit in many companies. > Failing all of that, then you can use the win32 api, but this would be > a pain in VB if you don't have a great deal of interfacing with the > API. > I looks like it does boil down to using the API. Certainly not something to look forward to :-( 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. -- Regards, Joerg http://www.analogconsultants.com
From: CBFalconer on 24 Sep 2007 01:08 Joerg wrote: > The Real Andy wrote: >> CBFalconer <cbfalconer(a)yahoo.com> wrote: >>> antedeluvian51 wrote: >>> >>>> mscomm32.ocx is often a headache. The only sure way is to install >>>> VB6 (I am not sure if you need the professional or enterprise >>>> editions for the registration to occur). You can in fact uninstall >>>> VB6 immediately afterwards without ever having used it, and the >>>> registration will still stick. I guess you could do this with a >>>> borrowed copy without violating the copyright. >>> >>> I fail to see any reason for anyone to put up with these >>> shenanigans. Linux is still available, at a reasonable price, >>> with a reasonable license. >> >> What has that got to do with the OP's question? Why is it that >> linux bigots can never answer the question, but rather just dodge >> it with some completely irrelevant drivel. If Joerg wanted to use >> linux, then Joerg would have used linux because Joerg is more >> than competent to do so, but that is not what was asked. > > Right, no Linux here. This has to work on client's PCs and their > IT staff would roll on the floor holding their bellies if I > suggested they change out the OS on a number of PCs. I would never have made the comment in another newsgroup, but this is c.a.embedded, and I fail to see any reason for Windows fragilities to impede things. > > On a side note Linux seems to cause some quirks in cooperation > with Windows systems. For example, when I want to unzip a file > that resides on the Linux-based LAN drive here I usually receive > the error message "not a zip file". After moving it over to a > Windows PC the same file unzips just fine. On this, I suspect either your unzipper or that you have had some file transfer problems. Line endings are stored differently on Linux and Windows, so the copy mechanism has to take steps. Zip files are binaries, and those steps should be inhibited. For reliable standard zip packages go to infozip. -- Chuck F (cbfalconer at maineline dot net) Available for consulting/temporary embedded and systems. <http://cbfalconer.home.att.net> -- Posted via a free Usenet account from http://www.teranews.com
From: Joerg on 24 Sep 2007 11:17 CBFalconer wrote: > Joerg wrote: > >>The Real Andy wrote: >> >>>CBFalconer <cbfalconer(a)yahoo.com> wrote: >>> >>>>antedeluvian51 wrote: >>>> >>>> >>>>>mscomm32.ocx is often a headache. The only sure way is to install >>>>>VB6 (I am not sure if you need the professional or enterprise >>>>>editions for the registration to occur). You can in fact uninstall >>>>>VB6 immediately afterwards without ever having used it, and the >>>>>registration will still stick. I guess you could do this with a >>>>>borrowed copy without violating the copyright. >>>> >>>>I fail to see any reason for anyone to put up with these >>>>shenanigans. Linux is still available, at a reasonable price, >>>>with a reasonable license. >>> >>>What has that got to do with the OP's question? Why is it that >>>linux bigots can never answer the question, but rather just dodge >>>it with some completely irrelevant drivel. If Joerg wanted to use >>>linux, then Joerg would have used linux because Joerg is more >>>than competent to do so, but that is not what was asked. >> >>Right, no Linux here. This has to work on client's PCs and their >>IT staff would roll on the floor holding their bellies if I >>suggested they change out the OS on a number of PCs. > > > I would never have made the comment in another newsgroup, but this > is c.a.embedded, and I fail to see any reason for Windows > fragilities to impede things. > Sometimes you must put up with it. The installed base is huge. Other times you have to do it because the customer wishes it. For example, we have desigend a whole big ultrasound machine around Windows (after tossing an re-writing a lot of stuff). Ok, it's big, about the size of a small dishwasher but that's an embedded application. > >>On a side note Linux seems to cause some quirks in cooperation >>with Windows systems. For example, when I want to unzip a file >>that resides on the Linux-based LAN drive here I usually receive >>the error message "not a zip file". After moving it over to a >>Windows PC the same file unzips just fine. > > > On this, I suspect either your unzipper or that you have had some > file transfer problems. Line endings are stored differently on > Linux and Windows, so the copy mechanism has to take steps. Zip > files are binaries, and those steps should be inhibited. For > reliable standard zip packages go to infozip. > Sure, but the drive is marketed for Windows-based networks. However, no complaints because other than that it works nicely. Made it very easy to send off a scope screen capture from the lab. The USB extension was thoroughly botched by the mfg though. -- Regards, Joerg http://www.analogconsultants.com
From: Joerg on 25 Sep 2007 16:45
Marc_F_Hult wrote: > On Wed, 19 Sep 2007 15:05:22 -0700, Joerg > <notthisjoergsch(a)removethispacbell.net> wrote in message > <A%gIi.4992$Sd4.1737(a)nlpi061.nbdc.sbc.com>: > > >>Hello Folks, >> >>Since mscomm.ocx for some strange reason will pop a license block unless >>you also install VB Professional (which most people don't need) I am >>looking for other methods to communicate with RS232 from Excel VBA, >>other than directly using the API. Lots of Google searching provided >>only one alternative, a routine called "cheapcomm". However, none of the >>download sites from back then (2004 and earlier) works anymore. Does >>someone know a site that still has it? > > > > Hi Joerg, > > Have you discounted the WindMill drivers ? They work with Excel. > > http://www.windmill.co.uk/rs232.html > > LabIML 4.3 is the ASCII-only version which is free for the cost of signing > up for their newsletter. I've been on their list 4-5 years and although one > can quit after the download, I haven't. Very little traffic and what there > is sometimes even useful. > > You have to pay for the binary version. > Thanks, I did look there. Unfortunately what comes off lab equipment is pure data, not ASCII :-( GBP145 times number of seats just to get data from RS232 into Excel is a bit steep. -- Regards, Joerg http://www.analogconsultants.com |