How to get file path of the file with the running-vba code

Question

I want to get the folder path from the file who is running the vba-code. For example: the vba-code is in the file C:\myfolder\file.accdb and I want the vba-code to return C:\myfolder\

Is that possible?

Answer 1

You need

currentproject.Path