Hi,

I have a file that when saving id like it save a copy somewhere else.

Id need it to look in the folder where the file will be saved, delete an existing copy if theres one in there, then save a new copy, but also remove all VBA from the copy and save as an xls file.

The reason for the last part is im guessing if it was an exact duplicate then the macro would run when saving the new copy and cause a whole load of problems.

The original is also password protected and the copy doesn't need to be.

Someone helped me out with this, but it doesnt seem to do what ive described, so hopefully my explanation above is clear enough to get some help.

Thanks in advance

Please Login or Register  to view this content.