|
=cell("filename",a1)
Is there anyway to use this function to enter only the filename and not the
full path? |
See:
http://www.officearticles.com/excel/...ft_ex cel.htm ************ Anne Troy www.OfficeArticles.com "topher" wrote in message ... Is there anyway to use this function to enter only the filename and not the full path? |
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. "Anne Troy" wrote: See: http://www.officearticles.com/excel/...ft_ex cel.htm ************ Anne Troy www.OfficeArticles.com "topher" wrote in message ... Is there anyway to use this function to enter only the filename and not the full path? |
=cell("filename",a1)
You're welcome, Topher. :)
************ Anne Troy www.OfficeArticles.com "topher" wrote in message ... 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. "Anne Troy" wrote: See: http://www.officearticles.com/excel/...ft_ex cel.htm ************ Anne Troy www.OfficeArticles.com "topher" wrote in message ... Is there anyway to use this function to enter only the filename and not the full path? |
| All times are GMT +1. The time now is 08:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com