| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Obtaining a single Access record from Excel input | Links and Linking in Excel | |||
| Excel CELL bug | Excel Worksheet Functions | |||
| Can I put 2+ rows from excel on a single label using mailmerge | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Hybrid Mode
