Hello all,

I'm using Excel 2002 SP3.

I have a list of 66 password protected Excel spread sheets that I need
to open, delete the top two lines, then save it removing the password,
and then move the file to a different folder.

I have the open (including password) and the deleting the top two rows
working.

The way I'm trying to remove the password is by saving as the same
workbook leaving the password argument blank. The problem is that I
get the message saying that it already exists and asking me if I want
to overwrite it. Is there any way to get the SaveAs method to
override this message box and overwrite the file by default? I looked
through the help files on SaveAs method and none of the arguments
explicitly said anything about existing files. The only one that I
think might work is the ConflictResolution argument, but that looks
like it is for resolving conflicts when 2 people are working on the
same workbook at the same time.

Any help on this will be greatly appreciated,

Conan Kelly