| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to reveal path of an open file ?
Hi,
I have a working file and would like the file path ( file name and directory ) show at cell A1. May I know what formula or keyborad short cut I must enter ? Thanks Low -- A36B58K641 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to reveal path of an open file ?
One method.
Sub NameinCell() Range("A1").Value = ActiveWorkbook.FullName End Sub Another using a formula =LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1))) NOTE: enter as is..........do not substitute your filename. Gord Dibben MS Excel MVP On Fri, 24 Jul 2009 09:19:01 -0700, Mr. Low wrote: Hi, I have a working file and would like the file path ( file name and directory ) show at cell A1. May I know what formula or keyborad short cut I must enter ? Thanks Low |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to reveal path of an open file ?
Hi Gord,
Thanks for your help. Best Regards Low -- A36B58K641 "Gord Dibben" wrote: One method. Sub NameinCell() Range("A1").Value = ActiveWorkbook.FullName End Sub Another using a formula =LEFT(CELL("filename",A1),FIND("]",CELL("filename",A1))) NOTE: enter as is..........do not substitute your filename. Gord Dibben MS Excel MVP On Fri, 24 Jul 2009 09:19:01 -0700, Mr. Low wrote: Hi, I have a working file and would like the file path ( file name and directory ) show at cell A1. May I know what formula or keyborad short cut I must enter ? Thanks Low |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002: How to reveal the grid lines ? | Excel Discussion (Misc queries) | |||
| Excel 2002: How to reveal a formula in a cell ? | Excel Discussion (Misc queries) | |||
| Excel 2002: How is the Excel 2007 file format open in Excel 2002 ? | Excel Discussion (Misc queries) | |||
| Excel 2002: How to reveal grid lines on color shaded worksheet? | Excel Discussion (Misc queries) | |||
| UNC Path length problem opening a file in excel 2002 or 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
