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.

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.

Barb,

Thank you for your reply to my post. I don't think I was clear in my
question though. I need a macro that will automatically put the file path in
the footer of every document I open. I have found some Macro codes for
previous Office versions but none of them work on Office 2007.

"Barb Reinhardt" wrote:

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 in the footer. I believe I have to use a macro for this to work. I have found some macro codes for this action but none of them are working with Office 2007.