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. You can review the TOC and part of the first example at if you have Visual Basic (probably VB6) then bypass the next few attempts. The book is called "Excel by Example : A Microsoft Excel Cookbook for Electronics Engineers" ISBN 0750677562 (published by Elsevier) and is available in paperback or in electronic format. The first describes an interface to a DVM and the second to a function generator. Microsoft was unable to help me in this regard.įorgive me if I take this opportunity to also tell you that there are two examples (chapters) that actually show you how to interface MS Excel to the serial port (plus one that uses the parallel port). Some other techniques are also described in the book. You may be lucky and find some other way to register the control. I suggest you consult a lawyer before you do this.
I don't know what the legal ramifications are, but it would seem to me that you could borrow a copy, install and uninstall and not violate the license.
You can immediately uninstall VB6 (you don't even have to run it)- the MSComm feature will remain enabled in Excel. That was to install the Professional or the Enterprise Edition of Visual Basic 6. In researching the topic for my book, I only found one sure way. Getting the MSComm control to appear in Excel or VBA can sometimes be a very difficult thing.
0 kommentar(er)
