Return File Name to cell

E

ExcelMonkey

I posted this yesterday but cannot seem to find it through the site I a
using - Exceltip.com. As such I am posting it again.

I want to return the file name to a cell in my spreadsheet. I know
can use the Cell("filename") function, but this provides the path.
cant seem to figure out how edit the string do that only the file nam
shows up in the formula.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Vlookup and return sheet name also 2
Sub projects added as read only in Master file which are saved on sharepoint 1
File name insertion in cell 3
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
Drop down list control value in vba 2
INDEX return multiple columns 1
Link To File That No Longer Exists 1

Top