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

Mscomm32 windows 10 download