if you've been really good, maybe you could use Sendkeys and send an escape (or
whatever you need to dismiss that dialog).

But if you're unlucky, your sendkeys could go to a different application and
hose that one up.



Microsoft wrote:

The workbook is re-created on a daily basis, so I can't just fix it once- It
has to be fixed every day. (It is the product of another program's "export"
facility.) My app just makes the necessary changes to the workbook and then
emails it out.
Maybe there's another way around it...
Thanks again for your help!

"Tom Ogilvy" wrote in message
...
That is the only command that suppresses warning messages (that I am aware
of) - but apparently this message doesn't fall in the category of messages
it will suppress.

Why not just fix the workbook one time and be done with it?

--
Regards,
Tom Ogilvy

"Microsoft" wrote in message
...
Thanks for your swift reply.
I've tried DisplayAlerts but the dialog box still opens.
Any other suggestions?

Thanks!

"Tom Ogilvy" wrote in message
...
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.
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







[/color]

--

Dave Peterson