![]() Some of the code I'm not too familiar with exactly what it does since I inherited the backbone and only changed the loop parameters etc. The debugger goes to the errhandler line below and has an issue with " If MSComm1.PortOpen = True Then MSComm1.PortOpen = False". The laptop has a USB to RS-232 adaptor and I think the problem is that I need to change the Mscomm1 port to whatever port the USB adaptor is coming from on the laptop. ![]() I moved the program to a laptop and I got a run time error '424' object required. The current version I have works for a pc by taking the inputs from rows in the excel file and placing instructions in a certain order as steps in a process for the pump to perform. I don't have anything configured right now to test this stuff, but if it fails, get back to me.I am working with inherited code that I altered that takes input from Excel and serial port adaptor to automate peristalitc pumps. You may prefer to just copy pieces of the code examples, anyway. If/when you download the "demo" spreadsheets, don't enable macros until you review the code. Similarly functioning code that calls to the Windows API can be found here: Īnd example spreadsheets that use the module code from GITHUB are here: The ActiveX component MSCOMM is no longer supported. If Right(chars, Len(lineEnding)) = lineEnding Thenĭebug.Print "Line:"
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |