Joepy,

Try
Activeworkbook.Path

John

Joepy wrote:

Hello,

I need to be able to retrieve the directory of the excel file which is
currently active.

"CurDir" does not work, because if excel is set to "C:\My Documents"
as the standard folder it always outputs this folder, although the
document is actually in "C:\WINDOWS\Desktop".

Can anyone help me with this?

Thanks,
Joepy