app.path

[GarrettDori]

How does App.Path work? Any examples would help, I tried searching but found nothing helpful

[vbasicgirl]

It returns the path where your project or exe is running at that time.

casey.

[MartinLiss]

Put MsgBox App.Path in a FormLoad sub and see what it gives you.

[paralinx]

It comes in handy for getting files. If you stick your file in the same location as your project then you can easily access it.

sFileLocation = App.Path & "\File.txt"

[MartinLiss]

It comes in handy for getting files. If you stick your file in the same location as your project then you can easily access it.

sFileLocation = App.Path & "\File.txt"

There is one gotcha if you do that.

If Right$(App.Path, 1) = "\" Then
        sFileLocation = App.Path & "File.txt"
    Else
        sFileLocation = App.Path & "\File.txt"
    End If

[Keithuk]

It comes in handy for getting files. If you stick your file in the same location as your project then you can easily access it.

sFileLocation = App.Path & "\File.txt"

Thats assuming your file isn't on the root of a drive, C: A:

Option Explicit
 
Dim Ap As String
 
Sub Form_Load()
 
If Right$(App.Path, 1) = "\" Then
    Ap = App.Path
Else
    Ap = App.Path & "\"
End If
 
End If
 
Private Sub cmdSave_Click()
 
Open Ap & "Yourfile.txt" For OutPut As #1
'Save data
Close #1
 
End If

That way you don't have to think about the / if its needed or not. That way the exe can be anywhere you want it to be.

[GarrettDori]

Thanks I know what it is now :-)