How do I get Excel filename using a single keystroke
 

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?

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

How do I get Excel filename using a single keystroke
 

David

Assign this macro to a Toolbar button.

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


Gord Dibben MS Excel MVP

On Thu, 19 Oct 2006 09:35:01 -0700, 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?

How do I get Excel filename using a single keystroke
 

You did say "keystroke".

Assign a shortcut key combo to the macro.

Gord

On Thu, 19 Oct 2006 11:00:39 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

David

Assign this macro to a Toolbar button.

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


Gord Dibben MS Excel MVP

On Thu, 19 Oct 2006 09:35:01 -0700, 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?

Gord Dibben MS Excel MVP

How do I get Excel filename using a single keystroke
 

Ah, who reads the subject lines????

<vbg

Gord Dibben wrote:

You did say "keystroke".

Assign a shortcut key combo to the macro.

Gord

On Thu, 19 Oct 2006 11:00:39 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

David

Assign this macro to a Toolbar button.

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


Gord Dibben MS Excel MVP

On Thu, 19 Oct 2006 09:35:01 -0700, 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?

Gord Dibben MS Excel MVP

--

Dave Peterson

How do I get Excel filename using a single keystroke
 

Me......after posting my reply<g



On Thu, 19 Oct 2006 15:04:01 -0500, Dave Peterson
wrote:

Ah, who reads the subject lines????

<vbg

Gord Dibben wrote:

You did say "keystroke".

Assign a shortcut key combo to the macro.

Gord

On Thu, 19 Oct 2006 11:00:39 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

David

Assign this macro to a Toolbar button.

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


Gord Dibben MS Excel MVP

On Thu, 19 Oct 2006 09:35:01 -0700, 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?

Gord Dibben MS Excel MVP

Gord Dibben MS Excel MVP