How to get current directory without using VBA?

Question

Is possible get current directory without using VBA? (to avoid using macros)

I know that is possible via VBA, but I am trying to avoid using macros in my document.

score 3 · Answer 1 · answered Jan 22 '14 at 08:51

3

You can use INFO formula to get path of the current directory or folder. Just write it in any cell

 =INFO("directory")

answered Jan 22 '14 at 08:51

Dmitry Pavliv

34,697
12
76
78

That gives the executing path, so the root folder of Excel – owenrumney Jan 22 '14 at 08:53
It give `Path of the current directory or folder.` see http://office.microsoft.com/en-au/excel-help/info-function-HP010342610.aspx – Dmitry Pavliv Jan 22 '14 at 08:54
I'm wrong, sorry, I tried INFO and it came back with the working directory. Second attempt came back with the directory the document is in. – owenrumney Jan 22 '14 at 08:57

ttaaoossuuuu · Accepted Answer · 2014-01-22T09:51:20.067

3

=LEFT(CELL("filename"),SEARCH("[",CELL("filename"))-1)

This will get local physical path. If file is on a remote machine, it will return the network path.

=INFO("DIRECTORY")

This will get network path (with machine name). NOTE: for me it just returns the networked My Directory folder from ANY file it is called from. Be careful.

edited Jan 22 '14 at 09:51

answered Jan 22 '14 at 08:52

ttaaoossuuuu

7,626
3
27
55

owenrumney · Answer 3 · 2014-01-22T08:58:05.463

1

You can use the forumula

 =CELL("filename", A1)

then substring it

UPDATE: the better solution is

 =INFO("DIRECTORY")

edited Jan 22 '14 at 08:58

answered Jan 22 '14 at 08:52

owenrumney

1,512
2
16
36

How to get current directory without using VBA?

3 Answers3