View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] tinembart@brain.ch is offline
external usenet poster
 
Posts: 3
Default suppress compatibility warning dialog during save

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