[Release] Byte count in Excel

[jaclaz]

I am particularly rusty on VBA, however I happened (while attempting to write *another* thing) to find a piece of nice VBA code for opening files, here:

http://forums.codeguru.com/showthread.php?499395-Reading-binary-files-in-VBA-quickly!

which I of course right away stole for my project.

 

As often happens, in order to understand how the snippet worked I did some tests completely unrelated to the original goal, and by pure chance I (half-@§§edly as usual) put together something that may be of actual use.

 

Find attached a simple spreadsheet that counts bytes in a file and draws a quick graph of their frequency  by value .

 

Such graphs are normally part of some disk/file/hex editors, among them I will cite X-Ways (commercial):

http://www.x-ways.net/

and (freeware) HXD:

http://mh-nexus.de/en/hxd/

Graphical representation of the byte/character distribution

 

 

and sometimes are useful to analyze "unknown" files.

 

Only very BRIEFLY tested on "smallish" files, YMMV.

 

Have fun .

 

jaclaz

Bytecount.zip

[computertech]

Thanks!!!!!!!!!