imprinting a worksheet with the directory path with a formula
I know there is a way to imprint a worksheet with the entire path (e.g. X:susand/etc/etc) by entering a formula.
I used to use this function and forgot the formula.
I remember that it begins with =filename( )
But, I do not remember what goes inside the parentheses.
Help!
Hi,
Try this,
=LEFT(CELL("filename",A1), FIND("]",CELL("filename", A1)))
or
=INFO("directory")
For this to work you must save the file with a name first.
Last edited by oldchippy; 01-24-2008 at 06:37 PM.
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
imprinting worksheet with filepath
oldchippy:
The formula:=INFO did not work.
But, the other one did!
Thanks, it is a little more lengthy than I remember, but it worked!
Thanks a bunch!
When you say =INFO did not work, do you mean only the directory path was there, only that what it does. The other formula I gave includes the directory path+filename.
Here's a link on INFO
http://techonthenet.com/excel/formulas/info.php
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks