| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
compatibility mode checking Excel & VB
How do I stop excel displaying a prompt to check for compatibility every time
I save a file in 97/2003 format from VB code? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
compatibility mode checking Excel & VB
answer found in Excel Programming user group:
Try Application.DisplayAlerts = False see: http://www.microsoft.com/office/comm...s/settings.xml Thanks "thelemeuk" wrote: How do I stop excel displaying a prompt to check for compatibility every time I save a file in 97/2003 format from VB code? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
compatibility mode checking Excel & VB
I've found that this doesn't work if any changes at all have been made to
the newly created workbook prior to saving. The Compatibility Checker is not affected by Display Alerts. You need to set an Excel 2007 property called CheckCompatibility to False, which only affects the display of the annoying dialog if no changes have yet been made to the workbook. ''In the main procedu Set wbExport = Workbooks.Add(xlWBATWorksheet) If Val(Application.Version) < 12 Then iFileFormat = xlWorkbookNormal Else iFileFormat = FormatxlExcel8 End If If Val(Application.Version) = 12 Then CheckCompat wbExport, False End If wbExport.SaveAs sFullName, ThisWorkbook.FileFormat ''Place this in a separate module, so it won't raise a compile error if Excel 2003 or earlier is running: Sub CheckCompat(wb As Workbook, bCheckCompat As Boolean) wb.CheckCompatibility = bCheckCompat End Sub - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - Training in Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "thelemeuk" wrote in message ... answer found in Excel Programming user group: Try Application.DisplayAlerts = False see: http://www.microsoft.com/office/comm...s/settings.xml Thanks "thelemeuk" wrote: How do I stop excel displaying a prompt to check for compatibility every time I save a file in 97/2003 format from VB code? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
compatibility mode checking Excel & VB
Thanks Jon - the workbook/module containing the suggested code now runs OK
but as you say, the saved files still have the compatibility check when opened and resaved. "Jon Peltier" wrote: I've found that this doesn't work if any changes at all have been made to the newly created workbook prior to saving. The Compatibility Checker is not affected by Display Alerts. You need to set an Excel 2007 property called CheckCompatibility to False, which only affects the display of the annoying dialog if no changes have yet been made to the workbook. ''In the main procedu Set wbExport = Workbooks.Add(xlWBATWorksheet) If Val(Application.Version) < 12 Then iFileFormat = xlWorkbookNormal Else iFileFormat = FormatxlExcel8 End If If Val(Application.Version) = 12 Then CheckCompat wbExport, False End If wbExport.SaveAs sFullName, ThisWorkbook.FileFormat ''Place this in a separate module, so it won't raise a compile error if Excel 2003 or earlier is running: Sub CheckCompat(wb As Workbook, bCheckCompat As Boolean) wb.CheckCompatibility = bCheckCompat End Sub - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - Training in Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "thelemeuk" wrote in message ... answer found in Excel Programming user group: Try Application.DisplayAlerts = False see: http://www.microsoft.com/office/comm...s/settings.xml Thanks "thelemeuk" wrote: How do I stop excel displaying a prompt to check for compatibility every time I save a file in 97/2003 format from VB code? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
compatibility mode checking Excel & VB
Once the file is saved the first time, the CheckCompatibility setting works
anytime. - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - Training in Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "thelemeuk" wrote in message ... Thanks Jon - the workbook/module containing the suggested code now runs OK but as you say, the saved files still have the compatibility check when opened and resaved. "Jon Peltier" wrote: I've found that this doesn't work if any changes at all have been made to the newly created workbook prior to saving. The Compatibility Checker is not affected by Display Alerts. You need to set an Excel 2007 property called CheckCompatibility to False, which only affects the display of the annoying dialog if no changes have yet been made to the workbook. ''In the main procedu Set wbExport = Workbooks.Add(xlWBATWorksheet) If Val(Application.Version) < 12 Then iFileFormat = xlWorkbookNormal Else iFileFormat = FormatxlExcel8 End If If Val(Application.Version) = 12 Then CheckCompat wbExport, False End If wbExport.SaveAs sFullName, ThisWorkbook.FileFormat ''Place this in a separate module, so it won't raise a compile error if Excel 2003 or earlier is running: Sub CheckCompat(wb As Workbook, bCheckCompat As Boolean) wb.CheckCompatibility = bCheckCompat End Sub - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - Training in Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "thelemeuk" wrote in message ... answer found in Excel Programming user group: Try Application.DisplayAlerts = False see: http://www.microsoft.com/office/comm...s/settings.xml Thanks "thelemeuk" wrote: How do I stop excel displaying a prompt to check for compatibility every time I save a file in 97/2003 format from VB code? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
compatibility mode checking Excel & VB
Hi Jon,
I created two new modules, but I'm still getting the compile error. Is there a better way to shut the check off? Thanks! Marie "Jon Peltier" wrote: I've found that this doesn't work if any changes at all have been made to the newly created workbook prior to saving. The Compatibility Checker is not affected by Display Alerts. You need to set an Excel 2007 property called CheckCompatibility to False, which only affects the display of the annoying dialog if no changes have yet been made to the workbook. ''In the main procedu Set wbExport = Workbooks.Add(xlWBATWorksheet) If Val(Application.Version) < 12 Then iFileFormat = xlWorkbookNormal Else iFileFormat = FormatxlExcel8 End If If Val(Application.Version) = 12 Then CheckCompat wbExport, False End If wbExport.SaveAs sFullName, ThisWorkbook.FileFormat ''Place this in a separate module, so it won't raise a compile error if Excel 2003 or earlier is running: Sub CheckCompat(wb As Workbook, bCheckCompat As Boolean) wb.CheckCompatibility = bCheckCompat End Sub - Jon ------- Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ Advanced Excel Conference - Training in Charting and Programming http://peltiertech.com/Training/2009...00906ACNJ.html _______ "thelemeuk" wrote in message ... answer found in Excel Programming user group: Try Application.DisplayAlerts = False see: http://www.microsoft.com/office/comm...s/settings.xml Thanks "thelemeuk" wrote: How do I stop excel displaying a prompt to check for compatibility every time I save a file in 97/2003 format from VB code? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I turn off compatibility mode in Excel 2007? | Excel Discussion (Misc queries) | |||
| Excel 2007 Compatibility Mode Not Responding | Excel Discussion (Misc queries) | |||
| EXCEL 2007 COMPATIBILITY MODE ISSUE | Setting up and Configuration of Excel | |||
| Compatibility Mode to Excel 2007 | Excel Worksheet Functions | |||
| EXCEL 2007 OPENING IN COMPATIBILITY MODE | Excel Discussion (Misc queries) | |||
Hybrid Mode
