Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello All
I'm using "modCOMM - Written by: David M. Hitchner" to send data out of the serial port. I need to send HEX strings (eg 0E0E00000505000C20450164A5A5 ) to external devices. Each part of the string is 2 HEX characters. If I send a HEX string directly to it, I get incorrect data at the other end. By using 2 HEX programs and a null cable, I can pass the strings correctly to the equipment, and also monitor what Excel is sending out of the serial port. If I send this - I get this on the HEX comms program 0E0E00000505000C20450164A5A5 - 30453045303030303035303530303043323034353031363441 35413500 0 - 30 1 - 31 A - 41 a -61 0E - 3045 Chr(1) & Chr(255) - 01FF So, I can see that there is a way to get the correct data out, but I don't want to have to encode each and every pair of HEX digits into a "chr()". Whats the intelligent way of getting a string? Thanks a lot!! Andrew |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting string to number | New Users to Excel | |||
converting a string to long | Excel Programming | |||
Converting a Date to a string | Excel Programming | |||
converting number to string | Excel Programming | |||
Converting a range to string | Excel Programming |