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



Photo

[Release] Byte count in Excel

- - - - -

  • Please log in to reply
No replies to this topic

#1
jaclaz

jaclaz

    The Finder

  • Developer
  • 14,689 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:

http://forums.codegu...-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

Attached Files




How to remove advertisement from MSFN



0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users