Jim,

I just had something like this and "K Dales" posted back to me saying I
could try this:

ThisWorkbook.Path

This will give you the directory of the current workbook. It's a useful
place to start.

Hope this helps
George