Running macro gives "xyz file named already exist. Do you want to replace ?"

[shaikhstonevilla]

Hi Guys,

I am running macro which prepares report for me from excel and save file it in csv format at the specific path.

Now my problem is that while saving the file, it give me pop up "xyz file named already exist. Do you want to replace it ?"
Surprisinlgy, no any file exist with the xyz file name at the that path.

More, if i change the path in macro to save the file at different location and re-run the macro, it also gives me the same pop up.


If anybody have the solution, it would be great help.


Regards,
Shaikhstonevilla

 

[Joe4]

It would be helpful to see your code. It might be that your code is actually trying to save the file twice, so the second time around it recognizes that the file already exists.