Does anyone know the equivalent of the Python unpack function in vba. Ultimately, trying to read a file as binary, loading the data into a Byte array then converting certain portions of the byte array into floating point numbers using little endian ordering. I can do this in Python, but would prefer to use vba for other reasons.
Asked
Active
Viewed 54 times
0
-
You are looking for `Open "FileName" For Binary Access Write As #1` Here is a small sample to load into an Array. https://stackoverflow.com/a/49522684/7868938 – Ricardo A Jun 16 '22 at 18:41
-
@RicardoA, I can already perform the Open "xxx" For Binary As. I can actually place every byte entry into a cell in excel, but these come out as ASCI formatted values. – BryanF Jun 16 '22 at 18:56