Results 1 to 3 of 3
  1. #1
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Read Binary (XL VBA)

    I have a file that when I open it with notepad is fully of gobbledy-gook. I'm thinking that I can open this file as binary, read byte by byte and convert this to string, then dump the strings into an excel sheet.

    The only issue is that I cannot remember the function to convert a byte to string - pls help.
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Read Binary (XL VBA)

    If the file isn't readable in Notepad, I 'm pretty sure you won't get readable strings following the procedure you describe. Does the extension of the file give you any indication of what type it is?

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Read Binary (XL VBA)

    What you describe is essentially what notepad does, so if you can't read the file in notepad there is not much else you can do. If the file contained strings, it may have been encrypted or compressed, in which case you must know what method was used and if it was encrypted what the key is.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •