Reading random binary file with header

Hi Moadll,

Try the following code (includes a routine to output a sample binary file per your specs) that reads/writes one byte at a time. When reading past the End of the File, the file will close.

Please Login or Register  to view this content.

It is a best practice to declare all variables. If you misspell a variable in your code, VBA will silently assume it is a Variant variable and go on executing with no clue to you that you have a bug. Go to the VBA development window, click Tools, Options, and check "Require Variable Declaration." This will insert the following line at the top of all new modules:

Please Login or Register  to view this content.

This option requires all variables to be declared and will give a compiler error for undeclared variables.

I hope this helps.

Lewis

Hello Lewis,

thanks for the pointer. I went for a slightly different version of that that works with less loops (I have a very large data-set to go through where time starts to matter):

Please Login or Register  to view this content.

With that I get the intial 433 Bytes read in one go and then read the chunks of data-sets also in one go per data-set.
What I cannot do is to directly jump to a certain data-set. That would be nice, however not essential here.
The other nice thing with that is that I already get the binary data brought onto the variables. The TIME_DATE is a 4 Byte value where I was fearing I'd have to go for a loop of reading a byte, multiplying it with 256, 256^2 or 256^3 to get the variable properly populated.

Sometimes automatisms aren't that bad... 8o)

Cheers,

Moadll