Jump to content

[Release] Byte count in Excel


jaclaz

Recommended Posts

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 :w00t::ph34r: 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 :yes:.

 

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

Link to comment
Share on other sites

  • 2 months later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...