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.
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Bariloche

Board Regular
Joined
Nov 12, 2002
Messages
143
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)

MrExcel MVP
Joined
May 17, 2002
Messages
3,329
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.

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

MrExcel MVP
Joined
May 17, 2002
Messages
3,329
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:
 

Watch MrExcel Video

Forum statistics

Threads
1,122,370
Messages
5,595,770
Members
414,017
Latest member
surajks

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
Top