Thread: Hex2Bin in VB
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Fredrik Wahlgren Fredrik Wahlgren is offline
external usenet poster
 
Posts: 339
Default Hex2Bin in VB


"kuch68" wrote in message
...
I was just wondering if there was some code or function that exists to
convert hex to binary in vB. My program takes a 8 bytes of hex and

converts
them to binary populating each Bit in a column (64 columns). I need an

easy
way instead of using more columns to perform the HEX2BIN worksheet

function.

thanks
Josh


There is a HEX2BIN function available in the Analysis toolpak add-in.

/Fredrik