ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Inserting File Path name (https://www.excelbanter.com/excel-discussion-misc-queries/130545-inserting-file-path-name.html)

Kelli

Inserting File Path name
 
Currently I am able to insert the file path name at the bottom of my Word
documents by: Insert/Field/Document Information/FileName/Options/Field
Specific Swtiches tab/ /p - add to field.

I want to do this same thing for my Excel documents. Is this possible?

Gord Dibben

Inserting File Path name
 
Kelli

Do you mean as in a "footer" that appears when you print or as in a cell value
that is always visible.

1. As a footer, go to ViewHeader/Footer and click on the Icon to insert the
file path and name.

2. In a cell.........see Bob Phillips' site for formula to enter the path and
name.

http://www.xldynamic.com/source/xld.xlFAQ0002.html


Gord Dibben MS Excel MVP


On Tue, 13 Feb 2007 12:09:01 -0800, Kelli
wrote:

Currently I am able to insert the file path name at the bottom of my Word
documents by: Insert/Field/Document Information/FileName/Options/Field
Specific Swtiches tab/ /p - add to field.

I want to do this same thing for my Excel documents. Is this possible?




All times are GMT +1. The time now is 06:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com