[RESOLVED] location/directory of workbook?

Hey all,

Is there a command to get the full path of the current workbook?

like a Workbook.Location or something?

which would return "C:\test\workbook.xls" ?

thanks much!

Workbook.Path

That doesn't work for me...

do I have to defined Workbook as my current Workbook?

and Application.path returns the MS office folder...

The path won't return any data if the workbook hasn't been saved yet. Use ActiveWorkbook if you aren't sure which workbook to reference.

Try

Code:

---

Application.ActiveWorkbook.FullName

---

awesome thanks guys

combined with

Application.ActiveWorkbook.name

get the whole path and file name