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
|