Try this Joepy
Sub test()
MsgBox ActiveWorkbook.Path
End Sub
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl
"Joepy" wrote in message om...
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