View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrew P. Andrew P. is offline
external usenet poster
 
Posts: 13
Default Converting a HEX string

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