|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 13th, 2009, 08:24 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a function to print file name/path on a spreadsheet?
|
|
#2
April 13th, 2009, 08:44 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a function to print file name/path on a spreadsheet?
Page setup Header/footerCustom footer click the symbols to insert path
and/or filename -- Kind regards, Niek Otten Microsoft MVP - Excel "cchas80860" wrote in message ...
|
|
#3
April 13th, 2009, 09:29 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a function to print file name/path on a spreadsheet?
cchas80860 wrote: Nothing!
:-}
|
|
#4
April 13th, 2009, 10:03 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a function to print file name/path on a spreadsheet?
cchas80860 wrote: Nothing!
Look at =CELL("filename") if you aren't talking about headers and footers.
|
|
#5
April 14th, 2009, 02:35 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Is there a function to print file name/path on a spreadsheet?
If you are going to use CELL("filename"), you should include a cell reference
(any cell will do). Without it, the function returns the name of the last sheet that was recalculated. I always use CELL("filename", A1) now. Also, the workbook must have been saved for the "filename" method of the CELL function to work. Hope this helps, Hutch "Glenn" wrote: cchas80860 wrote: Nothing! Look at =CELL("filename") if you aren't talking about headers and footers.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
