All,
I have a need to display the full file path name of a file into a given cell in a spreadsheet I am constructing. Whilst I know you can place it in the footer I was wanting it in a particular cell in a spreadsheet so that it can later be copied into a job ticket by an MI system
Any help as ever is appreciated
Best regards,
David
Last edited by David_S_Walker; 01-06-2011 at 11:19 AM.
Try
=SUBSTITUTE(LEFT(CELL("filename"),FIND("]",CELL("filename"))-1),"[","")
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thanks but maybe I need to be a bit more explicit. It is the path/location name (C:\david\documents\...etc) I am after which I want Excel to "discover" and then display into a given cellOriginally Posted by royUK
Hopefully that means something to somebody?
Best regards,
David
How about just:
=CELL("filename",$A$1)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
That works!
...For now anyway
I may have another question or two!
Best regards,
David
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks