Is there anyway to use this function to enter only the filename and not the full path?
T topher Oct 14, 2005 #1 Is there anyway to use this function to enter only the filename and not the full path?
A Anne Troy Oct 14, 2005 #2 See: http://www.officearticles.com/excel/return_the_workbook_name_to_a_cell_in_microsoft_excel.htm ************ Anne Troy www.OfficeArticles.com
See: http://www.officearticles.com/excel/return_the_workbook_name_to_a_cell_in_microsoft_excel.htm ************ Anne Troy www.OfficeArticles.com
T topher Oct 14, 2005 #3 Thank you very much! Not sure I understand how it works, but it does. Thanks also for the link, looks like I'll get alot of insight to "real" solutions rather than the "junk" from online help.
Thank you very much! Not sure I understand how it works, but it does. Thanks also for the link, looks like I'll get alot of insight to "real" solutions rather than the "junk" from online help.