Jump to content

Welcome to MSFN Forum
Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more. This message will be removed once you have signed in.
Login to Account Create an Account


[Release] Byte count in Excel

- - - - -

  • Please log in to reply
1 reply to this topic



    The Finder

  • Developer
  • 15,176 posts
  • Joined 23-July 04
  • OS:none specified
  • Country: Country Flag

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:


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):


and (freeware) 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 :).



Attached Files

How to remove advertisement from MSFN


  • Member
  • 2 posts
  • Joined 20-February 15
  • OS:XP Pro x86
  • Country: Country Flag


MSFN member

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users