How to retrieve the directory of the currently open file?

[Joepy]

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

 

[Ron de Bruin]

Try this Joepy

Sub test()
MsgBox ActiveWorkbook.Path
End Sub

 

[John Wilson]

Joepy,

Try
Activeworkbook.Path

John