Hi Everyone,
I have downloaded a VBA code from internet for gathering data from rs232 device through excel. My problem is i cant get the data from
the rs232 device to output to excel file. I already test the rs232 communication and its working fine, i can send and receive data from the device. but when i use the vba thru excel the only working is the command initiallize communication, and the write data to serial port command. i can prove this working because when i tried to send a command using this vba code to change some parameters on the rs232 device, when i check the rs232 device the parameters have change. but when i tried to send command to output the data to excel,no data appears on the excel file. im sure the command i send is correct because when i tried this using hype terminal it returns(output) the data. I hope someone can help me. i have a little knowledge on this. please see this link https://drive.google.com/open?id=1PEA2DJ_23cHbeKWGU7EqFlQQ_SfZE9To for the actual file im working on.
I have downloaded a VBA code from internet for gathering data from rs232 device through excel. My problem is i cant get the data from
the rs232 device to output to excel file. I already test the rs232 communication and its working fine, i can send and receive data from the device. but when i use the vba thru excel the only working is the command initiallize communication, and the write data to serial port command. i can prove this working because when i tried to send a command using this vba code to change some parameters on the rs232 device, when i check the rs232 device the parameters have change. but when i tried to send command to output the data to excel,no data appears on the excel file. im sure the command i send is correct because when i tried this using hype terminal it returns(output) the data. I hope someone can help me. i have a little knowledge on this. please see this link https://drive.google.com/open?id=1PEA2DJ_23cHbeKWGU7EqFlQQ_SfZE9To for the actual file im working on.
