Vba Serial Port Mscomm
I have a spreadsheet I originally created in Excel 2003 which used the MSCOMM control to read data sent to the serial port.When I upgraded to Excel 2007 this spreadsheet still worked fine. Lately our IT installed some updates on my computer and now this spreadsheet cannot use the MSCOMM control. I get the message, 'Can't exit design mode because control 'MSCOMM1' cannot be created'.An ideas of why an update to the OS would break a spreadsheet? My OS is Windows XP Pro.
MSComm Control Methods The MSComm control provides serial communications for your application by allowing the transmission and reception of data through a serial port. Syntax MSComm Remarks The MSComm control provides the following two ways for handling communications:. Event-driven communications is a very powerful method for handling.
Is there a way to fix this problem? RE: Excel and MSCOMM control (TechnicalUser). Oh Yeah, one more thing. After changing the registry key.if you export the key from the registry a.reg file will be created. Name it 'Enable MSCOMM.reg' or something.
Vba Open Serial Port
After installing your project on another machine - copy the.reg file over and double click it. A couple of warning dialogs will appear explaining the scary things that can happen when making changes to the registry, but the line will be altered and MSCOMM will be available on the other machine as well.
I don't know about programming to it on the other machine (licensing issues have always been vague regarding using MSCOMM with VBA since it only shipped with FoxPRo and VB) but it can be called and used by your project provided of course that you have installed mscomm32.ocx on the second machine and registered it there as well. The.reg file will provide you with a way to quickly fix the problem if your IT department pushes out another update and IE bans the ActiveX control again.Once upon a time I wrote an extensive FAQ regarding MSCOMM.
It has been removed from Tek-Tips. I think the issue was that I addressed the licensing issue and provided a workaround that may have been deemed illegal. Darn useful little ActiveX though don't you think?Greg RE: Excel and MSCOMM control (TechnicalUser). The MSCOMM is certainly useful. I've interfaced several minor pieces of lab equipment (balances, titrators) through Excel. Sometimes the vendors provide software but usually it has way more bells and whistles than one needs for routine measurements.I even interfaced a 20-year old spectrometer which originally ran in DOS.
When our last Win95 computer went belly up, the DOS program would no longer run reliably in the command prompt window for newer OSs. MSCOMM, VBA and Excel allowed me to keep the instrument running.
RE: Excel and MSCOMM control (Programmer) 21 Aug 09 17:54. D'OH The compatibility flag was set back to 400 sometime last week, disabling the ActiveX again. I may stick to the WindowsAPI version of the solution since it isn't affected by the registry change but it is more cumbersome than MSCOMM.Thanks anyway about the tip about the compatiblity flag.I thought about possibly editing the security settings in IE, but those are disabled on my computer. I'm not even sure how I would make my computer a trusted zone.P.S. The PortMonitor site says it contains Malware on my McAfee sitemonitor program. I wonder why?
RE: Excel and MSCOMM control (Programmer) 25 Aug 09 21:10.
