I want to save a excel file into particular folder, if the same name file found macro should automatically save this file also with making a same name and adding "Copy" or "duplicate" at the end.
Eg. Xyz.xls (if same name file found, macro should save this file also with xyz (copy).xls)
Is there any code then please help.
Abdul Qaiyum Shaikh