MrExcel Publishing
Your One Stop for Excel Tips & Solutions

filename


Posted by Joe Garza on October 16, 2001 5:48 AM

I want to show ONLY the filename in a cell and not the whole path. Is there any other command besides =cell("filename")?

Thanks


Posted by Gyula Lorant on October 16, 2001 6:48 AM


There a number of ways to do this.
Here's one way :-

Define a Name (let's say : Doc) which is equal to
=GET.DOCUMENT(88)
Type =Doc in any cell to get the filename.

Posted by Joe Garza on October 16, 2001 8:13 AM

Thanks, but I would have to type the name in the referenced cell to pull up the file name. I want it work just like =cell("filename") where it automatically puts the name, or like =now() which would automatically put the todays date.

I appreciate your help.


Posted by Joe Garza on October 16, 2001 8:13 AM

Thanks, but I would have to type the name in the referenced cell to pull up the file name. I want it work just like =cell("filename") where it automatically puts the name, or like =now() which would automatically put the todays date.

I appreciate your help.


Posted by Juan Pablo on October 16, 2001 8:54 AM

You could use...

Hello,
I have a huge database which records about 75 variables per range of values. In the foll. case ( which is incl. below) you can see, the pH range is what the user will select from either a drop down menu or an option button. I want the corresponding values (BD, SP, WHC etc) to pop up in a table depending on the range that has been selected. I hope I have made my point. Please help..I am ready to throw my computer out of the window if I don't get this taken care of soon. HELP!!!!Thanks in advance.

pH 3.8-4 4.1-5
BD 1.1 0.85 0.98 0.92 1.02 0.95
SP 58.49 67.92 63.01 65.28 61.5 64.15
WHC 35.76 33.33 32.69 46.28 49 44.1
EC 0.051 0.31 0.36 0.24 0.41 0.3
Na 36 81 76 53 61 67

Posted by Gyula Lorant on October 16, 2001 3:26 PM


It does work just like =cell("filename") or =now().
All you have to type in the cell is =Doc and the file name will be displayed.