The "Open" statement

[carl0s66]

I'm struggling with the syntax of the open statement, the helpfil
states it as

-Open pathname For mode [Access access] [lock] As [#]filenumbe
[Len=reclength]-

I know this makes me look thick but I've tried various things that hav
all failed, can someone give me an example of how this would look for
file named "carrier" that I wanted to input to as the mode?

Thank

 

[JE McGimpsey]

Say the file "carrier.csv" exists in the directory "C:\temp\". Here's
one way:

Const sPATH As String = "C:\temp\"
Dim nFileNum As Long

nFileNum = FreeFile
Open sPATH & "carrier.csv" For Input As #nFileNum

 

[carl0s66]

Ah ok cool.

I can presumably assign any long value to nFileNum

 

[JE McGimpsey]

Yes, but the FreeFIle method automatically produces the next free file
number, so it's a bit safer in cases where you may have multiple files
open.