Tag Archives: Write

Read Write Binary Data in VBA and .NET

I created VBA and .NET classes to read and write binary data (blobs).

Longs, strings and byte arrays can be written to a single byte array using the VBA class, written to a file, then read by the .NET version (and vice-versa).

These classes can be extended to use a file format structure that includes metadata about the data included in the blob (Zip file format for example) – but I will leave that up to the reader.

Without file format metadata, you will have to know ahead of time the data type included in the blob and read/write in the correct order.

Download VBA and .NET classes here.