Locating the current workbook location 1

[MrMajik]

Does Excel offer a way using VisualBasic to grab the path to where the workbook is currently located?

Access has the ol' tried-and-true Application.CurrentProject.Path that gives you the database location path but that does not seem to work in Excel.

Any ideas?

Thank you.

 

[Zathras]

You can use

   Application.ActiveWorkbook.Path

or simply

   ActiveWorkbook.Path

 

[MrMajik]

Zathras; Thank you!