How do I Automically add the file path to a new document?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shoretz & Company - 21 Sep 2007 21:34 GMT

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.

Reply to this Message

Barb Reinhardt - 22 Sep 2007 02:22 GMT

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)

Signature

HTH,
Barb Reinhardt

> 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.

Reply to this Message

Shoretz & Company - 24 Sep 2007 15:30 GMT

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.

> If you want it in a cell on a worksheet, use something like this
>
[quoted text clipped - 4 lines]
> > 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.

Reply to this Message