Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inserting the file path in a cell netorius77 Excel Discussion (Misc queries) 5 October 22nd 09 09:00 PM
Formula too long - new file path is shorter than old file path - Excel 2003 Greg J Excel Worksheet Functions 1 November 22nd 06 05:16 PM
file path Jane Excel Discussion (Misc queries) 2 August 18th 06 03:03 PM
Inserting Field To Insert Full Path to Excel File Will Excel Discussion (Misc queries) 3 February 11th 06 09:59 AM
Excel updating from XML file - file path specific? Sean Excel Discussion (Misc queries) 4 August 5th 05 12:56 PM


All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"