get the path of the excel file...

[Fursten]

Hi,

In a directoy I have an excel file. In that same directory I have a text file.

My excel file will read the text file, however I want it to find that text file without the user need to choose it.

In VB I could use: app.path & "nameofthefile", however i can´t do it in VBA

Is there any way to say to excel file to look for the text file in same directory as it stands?

thank you

Sergio Oliveira

 

[ide]

use
ActiveWorkbook.Path
or
Application.ThisWorkbook.Path

f.e.:
Const sTxtFileName = "myFileName.txt"
MsgBox ActiveWorkbook.Path & "\" & sTxtFileName

ide