Sub pathaa()
MsgBox ActiveWorkbook.Path

End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dable" wrote in message
...
I have about 20 spreadsheets containing tests and at the top of all of the
spreadshets is a summary section that has data in cells that is referenced
in
a summary spreadsheet. We would like to be able to have the summary
spreadsheet be "portable" in that the reference directory path need not be
the same. We are trying to see if it is possible to place the summary
spreadsheet in different directories containing the 20 test spreadsheets
and
have the summary "automatically" pick up the files in the current
directory.

The only way we can get it to work now is by either manually changing all
of
the referenced directories paths in the summary spreadsheet cells, or by
resetting all of the test spreadsheets back to their original states.

The line below is one of the summary spreadsheet cells and the path to the
directory containing the referenced spreadsheet, (TEST160 - Reports.xls).

='H:\Data\Test Scripts\Tests\version 4_04\[TEST160 -
Reports.xls]Reports'!$D$32

Is there a way to have the summary spreadsheet recognize the current
directory it is in and use that reference to get the data from the other
test
spreadsheets in the same directory?