Excel vba serial port mscomm control9/21/2023 ![]() 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. In order to get access to the VBA script editor, you first need to make the corresponding buttons available on. I had a development controller running in Excel VBA communicating with a Fluke 8845A digital multimeter. ocx file, like for instance the MSComm control. ![]() Hi - I'm an engineer working on trying to control a process using electrical resistance as a feedback. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |