Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Field To Insert Full Path to Excel File
Is there a field or function in Excel that would insert a full path to the
spreadsheet on the file system along with the name? For example: \\ourserver\sharedfiles\some\directory\path\my-excel-spreadsheet.xls You often get handed a printout of a spreadsheet, and it would really be nice if the printed version of the spreadsheet had a way to reference its own location so you could easily get back to it starting from the printed version. In Page Setup I see a way in the header to insert &File to get the filename only, but that does not insert a full path. -- Will |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Field To Insert Full Path to Excel File
hi try this one! in the cell you want to have the file name type =cell("filename") -via135 Will Wrote: Is there a field or function in Excel that would insert a full path to the spreadsheet on the file system along with the name? For example: \\ourserver\sharedfiles\some\directory\path\my-excel-spreadsheet.xls You often get handed a printout of a spreadsheet, and it would really be nice if the printed version of the spreadsheet had a way to reference its own location so you could easily get back to it starting from the printed version. In Page Setup I see a way in the header to insert &File to get the filename only, but that does not insert a full path. -- Will -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=511289 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Field To Insert Full Path to Excel File
If you don't include a reference to a worksheet, then that formula will return
the name of the file/worksheet that is active when excel calculates. It's usually better to use a formula like: =cell("Filename",a1) (a1 can be any cell) via135 wrote: hi try this one! in the cell you want to have the file name type =cell("filename") -via135 Will Wrote: Is there a field or function in Excel that would insert a full path to the spreadsheet on the file system along with the name? For example: \\ourserver\sharedfiles\some\directory\path\my-excel-spreadsheet.xls You often get handed a printout of a spreadsheet, and it would really be nice if the printed version of the spreadsheet had a way to reference its own location so you could easily get back to it starting from the printed version. In Page Setup I see a way in the header to insert &File to get the filename only, but that does not insert a full path. -- Will -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=511289 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inserting Field To Insert Full Path to Excel File
xl2002 adds the ability to include the full path in the header/footers.
Before xl2002, you'll need some other solution. Maybe John Walkenbach's addin: http://j-walk.com/ss/excel/files/addpath.htm to add the path in the header/footer Will wrote: Is there a field or function in Excel that would insert a full path to the spreadsheet on the file system along with the name? For example: \\ourserver\sharedfiles\some\directory\path\my-excel-spreadsheet.xls You often get handed a printout of a spreadsheet, and it would really be nice if the printed version of the spreadsheet had a way to reference its own location so you could easily get back to it starting from the printed version. In Page Setup I see a way in the header to insert &File to get the filename only, but that does not insert a full path. -- Will -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to tell excel to read numeric field as character fr a csv file | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
full path of excel file | Excel Discussion (Misc queries) | |||
Reflect file path (show drive letters) in Excel 2000 | Excel Discussion (Misc queries) | |||
How to change the Excel Title Bar to show the full file path na... | Excel Discussion (Misc queries) |