jaclaz Posted November 28, 2014 Share Posted November 28, 2014 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 . jaclazBytecount.zip Link to comment Share on other sites More sharing options...
computertech Posted February 23, 2015 Share Posted February 23, 2015 Thanks!!!!!!!!! Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now