Pulling data from a CSV file

What am I doing wrong in code? I want to pull data from a CSV file. I get an error that says 'Invalid procedure call or argument'.
==================================================================================
Public Function GetDataFromFile(ByVal OrderNumber As String)
Dim f As Integer
Dim strAll As String
Dim strOrder() As String
Dim strField() As String
Dim strOurOrder As String
Dim strTemp As String

'throw the whole file into a string
f = FreeFile
Open "C:\Customers\Superior Advertising\UPSEXP.CSV" For Binary As #f

strAll = Space$(LOF(f))
Get #f, , strAll
Close #f
'trim off everything before the first instance of the order
strAll = Mid$(strAll, InStrRev(strAll, OrderNumber))

GetDataFromFile = Left$(strAll, InStr(strAll, vbCrLf) - 1)
End Function
==================================================================================
If I make a copy of the CSV file and open it in Notepad and change the file extension to .txt - then it works, it pulls data like it should.

All data in each line item is separated by a comma and quotes surround each field.
Example of some of the data:

'place this in the General Declarations of a module
Type Rec_struc
OrderNum As String
Name As String
Contact As String
Addr1 As String
Addr2 As String
Addr3 As String
City As String
State As String
Zip As String
Phone As String
End Type

I’ve seen a number of people looking for examples of how to access web services from VB6. I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.
What are they?
An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…

As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…

Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…