View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How do I get Excel filename using a single keystroke

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 wrote:

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?


--

Dave Peterson