How to extract data from a binary (.bin) file into excel sheet using vba

[pratish2005]

Hi,

I have a binary file (.bin extension) and it contains some data in it. I need to extract it and do some analysis. Could somebody tell me how to do that? I want a VBA code that would take the bin file, extract the data and put it in an excel sheet.

Thanks

 

[Tinbendr]

Welcome to Mr. Excel!

Is the data in some type of regular format?

Can it be read in Notepad?

Can you import the data? If so, just record a macro importing it and adjust it as needed.

 

[Ruddles]

That's fairly easy. The question is: how do you want the data to be represented in the worksheet?

Do you want each byte from the file to appear as a single character in a separate cell? Or the actual value of each byte in a separate cell? Or do you want the contents encoded as hexadecimal, one byte per cell or multiple bytes per cell?

Do you have some sample data you could show us and then let us know what you would expect the worksheet to look like?