Some say that the older version of MSCOMM32.OCX has had its "kill bit" set by update "kb969898" (which was installed on system on 28th June). May be Microsoft update might have caused this problem. cess/archi ve/2009/06 /14/an-old er- version -of-mscomm 32-ocx-has -had-the-q uot-kill-b it-quot-fl ag- set.asp x Microsoft Blog (URL 1) recommends replacing MSCOMM32.OCX with API (Application Programming Interface) code and links to a Serial Port Communication page (URL 2) where you can download VB source code to use the API.ġ. PS - this is to support a development process - the full production process controller will be programmed by a proper software engineer - not an aero eng!Īnswer : MSComm VBA Excel comms with serial port I get the following messages:Ĭan anyone help - I looked at removign the need for the MSComm use by employing some code I've found on-line but am having difficulty in getting this to work - I can open the port and send some data but have errors coming up when I try to read data. I can't add the mscomm axtive x object to a worksheet in excel. I followed the process of downloading the MSComm ocx into the windows system folder (& system 32), registering it through reg command prompt, altering licences and this is where it goes wrong. This is a nice way to run the controller as I can take the data, process it in vba code, store it to the spreadsheet and then directly provide feedback on what to do next to a robot. The code uses MSComm to data to the multimeter and recieve data back from it. The controller relies upon communicating with the 8845A multimeter through a piece of code written in Excel VBA. My pc recently died (for unrelated reasons) and am now attempting to setup the controller on another pc - but no luck. I had a development controller running in Excel VBA communicating with a Fluke 8845A digital multimeter. Hi - I'm an engineer working on trying to control a process using electrical resistance as a feedback. Question : MSComm VBA Excel comms with serial port
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |