if you want the function to work for a single/specific workbook use
ThisWorkbook.Path. If you want to find the path of the activeworkbook use
ActiveWorkbook.Path.

"Terry" wrote:

Instead of using CurDir is there a command to use to get
the path of the current Workbook. CurDir doesn't always
work if the person has minimized xcel and traveled around
to other places and then openned the excel file again.

I know Workbook has a path property but can not figure out
how to use it.

Thanks...