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 |
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 |
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 |
All times are GMT +1. The time now is 07:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com