![]() ![]() Sometimes the vendors provide software but usually it has way more bells and whistles than one needs for routine measurements. I've interfaced several minor pieces of lab equipment (balances, titrators) through Excel. Darn useful little ActiveX though don't you think? Greg RE: Excel and MSCOMM control (TechnicalUser). I think the issue was that I addressed the licensing issue and provided a workaround that may have been deemed illegal. Once upon a time I wrote an extensive FAQ regarding MSCOMM. ![]() 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. 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. 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. Name it 'Enable MSCOMM.reg' or something.Īfter installing your project on another machine - copy the.reg file over and double click it. After changing the registry key.if you export the key from the registry a *.reg file will be created. The workbook gets data from a serial port or winsock. Event and tells excel what to do when data is received from the serial port. Is there a way to fix this problem? RE: Excel and MSCOMM control (TechnicalUser).Īlthough I am no Excel or VBA expert. An ideas of why an update to the OS would break a spreadsheet? My OS is Windows XP Pro. I get the message, 'Can't exit design mode because control 'MSCOMM1' cannot be created'. Lately our IT installed some updates on my computer and now this spreadsheet cannot use the MSCOMM control. When I upgraded to Excel 2007 this spreadsheet still worked fine. ![]() I have a spreadsheet I originally created in Excel 2003 which used the MSCOMM control to read data sent to the serial port. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |