| 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)) |
| 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) | |||
Threaded Mode
