Overridding the "already exists" message with the SaveAs method
 

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

Overridding the "already exists" message with the SaveAs method
 

Precede the code with

Application.DisplayAlerts = False

and reset to True afterwards

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Conan Kelly" <CTBarbarin at msn dot com wrote in message
...
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

Overridding the "already exists" message with the SaveAs method
 

Hi There,

Just a curiousity, but what other Alerts will this suppress other than
"This file already exsits."?

Regards,
Amber D. Laws :)

Bob Phillips Wrote:
Precede the code with

Application.DisplayAlerts = False

and reset to True afterwards

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Conan Kelly" <CTBarbarin at msn dot com wrote in message
...
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




--
Amber_D_Laws
------------------------------------------------------------------------
Amber_D_Laws's Profile: http://www.excelforum.com/member.php...o&userid=30012
View this thread: http://www.excelforum.com/showthread...hreadid=513337

Overridding the "already exists" message with the SaveAs method
 

Bob,

Thanks for your help--much appreciated.

Conan



"Bob Phillips" wrote in message
...
Precede the code with

Application.DisplayAlerts = False

and reset to True afterwards

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Conan Kelly" <CTBarbarin at msn dot com wrote in message
...
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

Overridding the "already exists" message with the SaveAs method
 

Most messages that popup with a default action.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Amber_D_Laws"
wrote in message
news:Amber_D_Laws.23c7wy_1140119101.3381@excelforu m-nospam.com...

Hi There,

Just a curiousity, but what other Alerts will this suppress other than
"This file already exsits."?

Regards,
Amber D. Laws :)

Bob Phillips Wrote:
Precede the code with

Application.DisplayAlerts = False

and reset to True afterwards

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Conan Kelly" <CTBarbarin at msn dot com wrote in message
...
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




--
Amber_D_Laws
------------------------------------------------------------------------
Amber_D_Laws's Profile:
http://www.excelforum.com/member.php...o&userid=30012
View this thread: http://www.excelforum.com/showthread...hreadid=513337