If you want it in a cell on a worksheet, use something like this

=CELL("filename",A1)

=LEFT(CELL("filename",A1),SEARCH("[",CELL("filename",A1))-2)


--
HTH,
Barb Reinhardt



"Shoretz & Company" wrote:

I am using office 2007 and I need to have the file path automatically added
to new excel worksheets and word documents. I believe I have to use a macro
for this to work. I have found some macro code for this but none of them are
for Office 2007.