Get Current Directory

mp.

New Member
Joined
Nov 13, 2002
Messages
12
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.
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
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
 
Upvote 0
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
 
Upvote 0
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!
 
Upvote 0
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:
 
Upvote 0

Forum statistics

Threads
1,213,494
Messages
6,113,974
Members
448,537
Latest member
Et_Cetera

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top