I need to create a button in Excel to read data in from serial port. I can't have any extra files attached to the excel sheet. I need to transfer this excel file to another computer to read this data. Here is how the file is suppose to function: Press button to select the serial port.
![]()
I'm having trouble getting code to read the incoming data send by a torque reader I'm working with. It sends a RS232 data stream which our current wedgelink software can be set up to translate it into key presses and then exported to excel. I would like to get the data into a string then cut the string up into an array of arrays to be able to use the data directly with excel. There is a ton of stuff how to do it in other languages but I'm limited to VBA right now.
This link https://dl.dropboxusercontent.com/u/37968177/modCOMM.bas has the base code someone wrote where i can open and close the port but im not getting any data or able to hold it open until end of the data feed. I'm still new at this and know I'm missing something. Serial Port Communication in Excel (VBA) | Electronics Open Source was the first place i found this code. Any ideas? ![]()
I need to create a button in Excel to read data in from serial port. I can't have any extra files attached to the excel sheet. I need to transfer this excel file to another computer to read this data.Here is how the file is suppose to function: Press button to select the serial port. Then, press another button to read data from serial port into the excel cell.Could someone please tell me how to do this?
Use VB macro or ActiveX macro? Sorry, this is the first time i'm using excel for this. Again, I can't have another file attached to the excel sheet. I found a discussion on exactly this topic in the german microcontroler.net forum here:Since I am running on Linux I can not verify if the code is correct.
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2023
Categories |