I created a VBA program, which :-
(1) Alerted me through Msgbox --- Do you want to create back up?
(2) If, I clicked yes, it saved current sheet as CSV file in C drive.
(3) If I clicked no, it saved current sheet in its whatever current drive.
There was a problem.
On first instance of running of this program, File was saved in C drive, if I selected Yes.
On Second instance, , it asked me to overwrite CSV file. I would want to ignore that alert which asked me to overwrite CSV file.
It should save CSV file by overwriting it, but without alerting user. How can this be done?