Hi
I would like to know how do i extract part of a file name or the complete file name to a cell. The path is on a server so it will be like "\\server\folder\" and then the file name "ed_scenario_validation_20110810.csv" the part with out the date "ed_scenario_validation_" always stay the same then the date "20110810" changes everyday.
Tnx
I would like to know how do i extract part of a file name or the complete file name to a cell. The path is on a server so it will be like "\\server\folder\" and then the file name "ed_scenario_validation_20110810.csv" the part with out the date "ed_scenario_validation_" always stay the same then the date "20110810" changes everyday.
Tnx
