Inserting Full File Path in an Excel Worksheet

[Guest]

Hi
One of the users I support asked me how to insert the full file path into an Excel worksheet. For instance, the way Word does it you'll see something like C:\documents and settings\local settings\temp\references.doc at the bottom of a document (assuming the user had this feature turned on.) It's similiar to using a footer, but the software will automatically put the full path to the filename in the document. Keep in mind that In Word, the user DOES NOT have to manually enter the path in, they simply turn a feature on to display the path at the bottom of the document. My customer told me that there used to be a way to do this in Excel also but he can't remember the steps.

In summary, he's using Excel 2000, and he wants to "turn on" a feature in Excel that will add the file path (the path where his document is stored either locally or on the network) at the bottom of his Excel spreadsheets when they print out. I realize this can be done manually, but there is a feature that will do this and I don't know how to activate it.

If someone could explain how to activate this, I would appreciate it

Thanks in advance
Tony

 

[Bob Phillips]

Tony,

=CELL("filename",A1) gives the filename & sheet name
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,100) gives the
sheet name
=LEFT(CELL("filename",A2),FIND("]",CELL("filename",A2))) gives the filename
& path

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hi,
One of the users I support asked me how to insert the full file path into

an Excel worksheet. For instance, the way Word does it you'll see something
like C:\documents and settings\local settings\temp\references.doc at the
bottom of a document (assuming the user had this feature turned on.) It's
similiar to using a footer, but the software will automatically put the full
path to the filename in the document. Keep in mind that In Word, the user
DOES NOT have to manually enter the path in, they simply turn a feature on
to display the path at the bottom of the document. My customer told me that
there used to be a way to do this in Excel also but he can't remember the
steps.

In summary, he's using Excel 2000, and he wants to "turn on" a feature in

Excel that will add the file path (the path where his document is stored
either locally or on the network) at the bottom of his Excel spreadsheets
when they print out. I realize this can be done manually, but there is a
feature that will do this and I don't know how to activate it.

 

[David McRitchie]

Hi Tony, and Bob,
I'm not sure but I think Tony asked for at the bottom (like in Word), which
would be the footer, which is where I would prefer to look for it as opposed
to being somewhere in the spreadsheet. Putting the pathname in the
footer or header in Excel 2000 and earlier will require a macro.

There are several choices, you can have the left footer, for instance,
updated automatically when you print, or you can run the macro yourself
when you want to change it. Use the kind of macro you are most
comfortable with:
Pathname in headings, footers, and cells
http://www.mvps.org/dmcritchie/excel/pathname.htm

Tony,

=CELL("filename",A1) gives the filename & sheet name
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,100) gives the
sheet name
=LEFT(CELL("filename",A2),FIND("]",CELL("filename",A2))) gives the filename
& path

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hi,
One of the users I support asked me how to insert the full file path into

an Excel worksheet. For instance, the way Word does it you'll see something
like C:\documents and settings\local settings\temp\references.doc at the
bottom of a document (assuming the user had this feature turned on.) It's
similiar to using a footer, but the software will automatically put the full
path to the filename in the document. Keep in mind that In Word, the user
DOES NOT have to manually enter the path in, they simply turn a feature on
to display the path at the bottom of the document. My customer told me that
there used to be a way to do this in Excel also but he can't remember the
steps.

In summary, he's using Excel 2000, and he wants to "turn on" a feature in

Excel that will add the file path (the path where his document is stored
either locally or on the network) at the bottom of his Excel spreadsheets
when they print out. I realize this can be done manually, but there is a
feature that will do this and I don't know how to activate it.

If someone could explain how to activate this, I would appreciate it.

Thanks in advance,
Tony

 

[Bob Phillips]

David,

Must admit that I was not sure how to read it. Whist the OP said footer, he
didn't actually say for printing, and so I read it as being on the sheet
itself, and thus gave some formulae. You always have to make some
assumptions <vbg>

Bob

Hi Tony, and Bob,
I'm not sure but I think Tony asked for at the bottom (like in Word), which
would be the footer, which is where I would prefer to look for it as opposed
to being somewhere in the spreadsheet. Putting the pathname in the
footer or header in Excel 2000 and earlier will require a macro.

There are several choices, you can have the left footer, for instance,
updated automatically when you print, or you can run the macro yourself
when you want to change it. Use the kind of macro you are most
comfortable with:
Pathname in headings, footers, and cells
http://www.mvps.org/dmcritchie/excel/pathname.htm

Tony,

=CELL("filename",A1) gives the filename & sheet name
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,100) gives the
sheet name
=LEFT(CELL("filename",A2),FIND("]",CELL("filename",A2))) gives the filename
& path

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Hi,
One of the users I support asked me how to insert the full file path

into
an Excel worksheet. For instance, the way Word does it you'll see something
like C:\documents and settings\local settings\temp\references.doc at the
bottom of a document (assuming the user had this feature turned on.) It's
similiar to using a footer, but the software will automatically put the full
path to the filename in the document. Keep in mind that In Word, the user
DOES NOT have to manually enter the path in, they simply turn a feature on
to display the path at the bottom of the document. My customer told me that
there used to be a way to do this in Excel also but he can't remember the
steps.

In summary, he's using Excel 2000, and he wants to "turn on" a feature

in
Excel that will add the file path (the path where his document is stored
either locally or on the network) at the bottom of his Excel spreadsheets
when they print out. I realize this can be done manually, but there is a
feature that will do this and I don't know how to activate it.

If someone could explain how to activate this, I would appreciate it.

Thanks in advance,
Tony

 

[Guest]

Thanks for the responses guys, I appreciate it.