suppress compatibility warning dialog during save

T

tinembart

Dear group

When i save a workbook in Excel97-2003 (.xls) format, i sometimes get
compatibility-warnings concerning loss of precision. Is it possible to
suppress this dialog program-controlled (using vba) or to 'catch' it
(like an exception) ? I have to translate a lot of .xlsx-workbooks
back to old .xls-format and would like to automate this operation
(open the file in new format, save it in old format), but the
compatibility-warning-dialog disrupts the processing. For this action,
i am really not interested in the compatibility warnings.

Thank you for any hints

Roger
 
T

Tom Ogilvy

If it is a warning, then this should work

Application.DisplayAlerts = False
Thisworkbook.SaveAs . . .
Application.DisplayAlerts = True

But I don't have xl2007, so I haven't tested it with that warning.
 
T

tinembart

If it is a warning, then this should work

Application.DisplayAlerts = False
Thisworkbook.SaveAs . . .
Application.DisplayAlerts = True

But I don't have xl2007, so I haven't tested it with that warning.

--
Regards,
Tom Ogilvy








- Zitierten Text anzeigen -

If it is a warning, then this should work

Application.DisplayAlerts = False
Thisworkbook.SaveAs . . .
Application.DisplayAlerts = True

But I don't have xl2007, so I haven't tested it with that warning.

YES! Its working! Thank you very much!

Cheers, Roger
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top