You can use either

ThisWorkbook.Path
' or
ActiveWorkbook.Path


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



"PeteCresswell" wrote in message
...
I'm trying to get the complete path to the .XLS my VBA code is running
in.

Actually, I just need the directory.... but either would do.

So far, all I'm able to get is the application's directory (where
Excel lives).

??