thanks jindon for your effort.
but this is not I want !
if I have in column B:C like this
86,000.00 C:\Users\pc\KLL\main\86,000.00.xlsm
INVOICE 87,000.00 C:\Users\pc\KLL\main\DTA\87,000.00.xlsm
so in column A should be when write done
then
will be
86,000.00 done. 86,000.00 C:\Users\pc\KLL\main\86,000.00.xlsm
and when write current then will be
86,000.00 done. 86,000.00 C:\Users\pc\KLL\main\86,000.00.xlsm
INVOICE 87,000.00 current 87,000.00 C:\Users\pc\KLL\main\DTA\87,000.00.xlsm
also when I would change files have already written
ex:
86,000.00 done. 86,000.00 C:\Users\pc\KLL\main\86,000.00.xlsm
when write 86,000.00 done and I would change to current then should change from done to current like this
86,000.00 current. 86,000.00 C:\Users\pc\KLL\main\86,000.00.xlsm
also I would when rename should select cell in column B or C if I write then will rename file based on selected cell if I don't write anything then will skip and move next cell to select and so on .
last thing I don't want dot (.) when I write word.