How to retrieve the directory of the currently open file?
 

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

How to retrieve the directory of the currently open file?
 

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

How to retrieve the directory of the currently open file?
 

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