Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add file name to spreadsheet
Is there a vba function or formual that I can use to add the file's name to
my spreadsheet? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add file name to spreadsheet
=cell("filename")
"EducatingMom" wrote: Is there a vba function or formual that I can use to add the file's name to my spreadsheet? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add file name to spreadsheet
See http://www.xldynamic.com/source/xld.xlFAQ0002.html
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "EducatingMom" wrote in message ... Is there a vba function or formual that I can use to add the file's name to my spreadsheet? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add file name to spreadsheet
Thanks, I was looking for a formula that would put the filename into the
spreadsheet instead of me typing in the actual filename. I want to use this formula on several different files. "Duke Carey" wrote: =cell("filename") "EducatingMom" wrote: Is there a vba function or formual that I can use to add the file's name to my spreadsheet? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
add file name to spreadsheet
Mom,
Duke gave you the actual formula, =CELL("filename") the filename inbetween the quotes is what pulls the actual filename from the file, and will change automatically if you "save as" and give it a new filename. Try =CELL("filename") exactly as you see it here. (look up the CELL worksheet function in help...) Beege "EducatingMom" wrote in message ... Thanks, I was looking for a formula that would put the filename into the spreadsheet instead of me typing in the actual filename. I want to use this formula on several different files. "Duke Carey" wrote: =cell("filename") "EducatingMom" wrote: Is there a vba function or formual that I can use to add the file's name to my spreadsheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
file will not open | Excel Discussion (Misc queries) | |||
save a spreadsheet file with same name but different version | New Users to Excel | |||
Excel Outlook Attachments opening after several errors everytime | Setting up and Configuration of Excel | |||
Mirror spreadsheet? | Excel Discussion (Misc queries) | |||
Embedding a file into an Excel spreadsheet? | Excel Worksheet Functions |