Read Binary (XL VBA)

Topic

New Reply

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.

Reply | Quote

Replies

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?

Reply | Quote

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.

Reply | Quote