Writing Data to binary file
Here is example code that writes out a sequence of numbers to a binary file, and then reads them back in. Note: when using this code, the user needs to edit the location of the file defined in the 2nd line.
Dim bDir As String, fName As String, fPath As String bDir = "C:\Users\Tom\Desktop\Temp\" fName = "binaryFileTest.dat" fPath = bDir & fName Open fPath For Binary Access Write As #1 Print "Entry" & Chr(9) & "Random Number" Dim numVals As Long, curVal As Long Dim dNum As Double numVals = 15 For curVal = 1 To numVals ' get a random number dNum = Rnd() Print curVal & Chr(9) & dNum ' write to file Put #1, , dNum Next Close #1 ' Now, try and read values back out of the file Print Print "Entry" & Chr(9) & "Read Value" Open fPath For Binary Access Read As #1 For curVal = 1 To numVals Get #1, , dNum Print curVal & Chr(9) & dNum Next Close #1