Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Return File Name to cell
I posted this yesterday but cannot seem to find it through the site I am 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 I can use the Cell("filename") function, but this provides the path. I cant seem to figure out how edit the string do that only the file name shows up in the formula. Thanks. -- ExcelMonkey ------------------------------------------------------------------------ ExcelMonkey's Profile: http://www.excelforum.com/member.php...fo&userid=5221 View this thread: http://www.excelforum.com/showthread...hreadid=318741 |
#2
|
|||
|
|||
Hi
see: http://www.xldynamic.com/source/xld.xlFAQ0002.html "ExcelMonkey" wrote: I posted this yesterday but cannot seem to find it through the site I am 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 I can use the Cell("filename") function, but this provides the path. I cant seem to figure out how edit the string do that only the file name shows up in the formula. Thanks. -- ExcelMonkey ------------------------------------------------------------------------ ExcelMonkey's Profile: http://www.excelforum.com/member.php...fo&userid=5221 View this thread: http://www.excelforum.com/showthread...hreadid=318741 |
#3
|
|||
|
|||
Thanks Frank! -- ExcelMonkey ------------------------------------------------------------------------ ExcelMonkey's Profile: http://www.excelforum.com/member.php...fo&userid=5221 View this thread: http://www.excelforum.com/showthread...hreadid=318741 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Embedding file name in a Cell | Links and Linking in Excel | |||
Using Jet to read excel file returns blank for last cell - sometim | Excel Discussion (Misc queries) | |||
Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
Function to return colour of formatted cell | Excel Worksheet Functions |