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

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?

You need

currentproject.Path