Get Current Directory

[mp.]

Hey,

Probably very simple, but can someone tell me how to pass the full path of the directory that the current workbook was run from (ie, c:somedirectoryexcel) to a variable?


Thanks for the help,

mp.

 

[Bariloche]

mp.,

Try:

MyPath = ActiveWorkbook.Path

Or, if you want to include the file name:

MyCompletePath = ActiveWorkbook.FullName

The workbook's name only is:

MyName = ActiveWorkbook.Name


have fun

 

[Richie(UK)]

Hi mp,

Welcome to the board.

Forgive me if I'm preaching to the converted here but ...

Your use of 'current workbook' could be a little misleading. The answers above refer to the currently active workbook (ActiveWorkbook). If you want to refer to the workbook that contains your VBA code, use ThisWorkbook instead of ActiveWorkbook.

HTH

 

[mp.]

Thanks for the help but I still can't get this to work.

MyPath = ActiveWorkbook.Path returns a blank value?

MyCompletePath = ActiveWorkbook.FullName returns only the name of the workbook but not the path.

I get the same results if I use ThisWorkBook. instead of ActiveWorkBook.

Any more ideas?

mp.

3:8) Moooo!

 

[Richie(UK)]

Hi mp,

This works fine for me, give it a try:

<pre>Sub NameTest()
Dim MyPath As String, MyCompletePath As String

MyPath = ActiveWorkbook.Path
MyCompletePath = ActiveWorkbook.FullName
MsgBox MyPath & vbLf & MyCompletePath
End Sub</pre>
HTH

PS. You have saved the activeworkbook haven't you? :wink: