Excel 2007 - File Address

[gwehner]

In Excel 2003, there is a Address bar which lets you know where in file is located. This feature is in the Web toolbar.

I use this Address bar a lot because I often send my coworkers links to files that I have saved in shared folders. Some of the shared folders are buried pretty deep in our system, so typing them out is time consuming and invites errors.

Does anyone know if Excel 2007 has this feature, and if so, where is it located?

Thank you.

 

[Hatcheda]

I have 07 at home. 2000 at work, So I can't test for you
This works on 2000

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 5/7/2007 by HATCHEDA
'
Dim MyFullName As String
MyFullName = ActiveWorkbook.FullName
MsgBox MyFullName
'
End Sub

Of course to avoid the typing just replace msgbox with a range
Range("A1") = MyFullName

 

[Hatcheda]

or even selection = MyFullName