How do I get Excel filename using a single keystroke

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to create a single icon which will give me the filename and path
of my spreadsheet. I know the longhand way - ie cell"filename") - I'm looking
for a quicker way.

Can anyone help?
 
File|Properties|General tab

Or...

Hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window
type this and hit enter:
?activeworkbook.fullname
 
David

Assign this macro to a Toolbar button.

Sub NameinCell()
Range("A1").Value = ActiveWorkbook.FullName
End Sub


Gord Dibben MS Excel MVP
 
You did say "keystroke".

Assign a shortcut key combo to the macro.

Gord

David

Assign this macro to a Toolbar button.

Sub NameinCell()
Range("A1").Value = ActiveWorkbook.FullName
End Sub


Gord Dibben MS Excel MVP
Click to expand...

Gord Dibben MS Excel MVP
 
Back
Top