Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION
there are more side effects like when there are few files open that
have the same form the name of the closed file transfered to the remain one. i used this formula (MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH(".",CELL("filenam e"))-SEARCH("[",CELL("filename"))-1)) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION
Use
=cell("Filename",a1) Without the range reference, excel will use the whatever worksheet/workbook that is active to evaluate that function. You can really use any cell you want. I usually use the address of the cell that holds the formula. yossie6 wrote: there are more side effects like when there are few files open that have the same form the name of the closed file transfered to the remain one. i used this formula (MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH(".",CELL("filenam e"))-SEARCH("[",CELL("filename"))-1)) -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Cell("filename") doesn't update to new filename when do save as. | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) |