You can try

application.DisplayAlerts = False
' open the workbook
application.DisplayAlerts = True

don't know if it will suppress this prompt or not AND if it suppresses the
message, whether it will save or not.

--
Regards,
Tom Ogilvy

"Microsoft" wrote in message
...
I have a VB app that opens an excel workbook, makes some modifications /
additions, and then saves / closes the workbook. It was working fine until
I
upgraded to Excel 2003. Now attempting to open the workbook results in an
[color blue]Error 1004 - Method 'Open' of object 'Workbooks'
failed[/color].
I've determined that the issue is an invalid Worksheet name, so I added
the
CorruptLoad:=xlRepairFile parameter to my Workbooks.Open
instruction. Excel now repairs the worksheet name on open, however now I
get
a confirmation dialog box that asks if I want to save the repaired file.
Is there any way to open the workbook, repair/correct the worksheet name,
and continue on making my changes without showing any dialog boxes?
Thanks for your help!
Charlton