Getting the filepath of macro project

[sunchuanpu]

Hello,

I have some txt files for storing some editable settings (such as user's list of stylesheet for printing), in the same folder as my .dvb file

I realized that the path of those txt files can be different if I want to use the program on other computers. Is it possible to get the filepath of current .dvb file? It will be best if I don't have to preset a specific location and ask my users to put the folder there.

Or are there better ways to store information?

Thank you very much.

[Ed__Jobe · Accepted solution]

You can reference "Visual Basic for Applications Extensibility 5.3". Then you can use

VBE.ActiveProject.FileName

[sunchuanpu]

Thank you very much.

I found this code works for me

Application.VBE.ActiveVBProject.fileName