CorruptLoad param of Workbooks.Open

[Microsoft]

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[/QUOTE].
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

 

[Tom Ogilvy]

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.

 

[Microsoft]

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

Thanks!

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

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

[/QUOTE]

 

[Tom Ogilvy]

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

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

Thanks!

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

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

[/QUOTE]

 

[Microsoft]

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!

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

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

Thanks!

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

[/QUOTE]

 

[count]

I'm not sure but it resembles my problem with 2003:
I used Named Ranges and my gradual development I kept, using SavingAs
....TheNameXX.xls with XX incrementing every so often.
All was well until I deleted early versions of XX.
Then Named Ranges couldn't be found and I had to delete / readd all of them.
Also macros assigned to buttons remembered older versions too. Horror.
The cure was in Options: I cleared the check mark Store External Links
[forgive inaccurate translation of the Option - I'm working with Polish
version at the moment and forgot original wording]. I also cleared other
check marks so...
....at this point I think it's time for knowledgable people to step in
Tom!, Bob!, Frank! - overhere!
Regards,
Paul
P.S. Ehem, ...about your nick...

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!

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

suppresses
the modifications

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

[/QUOTE]

 

[Dave Peterson]

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.

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!

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

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

Thanks!

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

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

[/QUOTE]