Hi - I'm an engineer working on trying to control a process using electrical resistance as a feedback. I had a development controller running in Excel VBA communicating with a Fluke 8845A digital multimeter. My pc recently died (for unrelated reasons) and am now attempting to setup the controller on another pc - but no luck.The controller relies upon communicating with the 8845A multimeter through a piece of code written in Excel VBA. The code uses MSComm to data to the multimeter and recieve data back from it.
Jan 22, 2013 Why is an MSCOMM control in my Excel 2007 application no longer supported on a different computer. Which in turn allowed me to read input from my machine attached to the COM1 serial port. THE NATURE OF MY PROBLEM. Some can be used only on Microsoft Visual Basic for Applications (VBA) UserForms. Communication - Serial port communications VB component lib Powerful Virtual Serial Port ActiveX Control. Supporting Visual Studio NET, C#,.
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.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. I can't add the mscomm axtive x object to a worksheet in excel. I get the following messages:Cannot insert object.Can 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 need a solution asap!!!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!Cheers.
Comments are closed.
|
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |