Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compatibility checker in excel 2007, turning it off
I need to save a folder full of excel files, but in .xls format. In 2007 it
always runs compatibility checker when saving in .xls. Is there a way to turn this off in excel, turn it off with vba, or have code that would at least check the ok box when asking if I still want to save in .xls format? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
compatibility checker in excel 2007, turning it off
I just did a quick test but it seems that stopping alerts block the
compatibility checker: Application.DisplayAlerts = False ActiveWorkbook.SaveAs "book1", xlWorkbookNormal ''XL97-03 -- Jim "Need Help Fast!" wrote in message ... |I need to save a folder full of excel files, but in .xls format. In 2007 it | always runs compatibility checker when saving in .xls. Is there a way to turn | this off in excel, turn it off with vba, or have code that would at least | check the ok box when asking if I still want to save in .xls format? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
compatibility checker in excel 2007, turning it off
Thank you Jim. It worked. You are a life saver. "Jim Rech" wrote: I just did a quick test but it seems that stopping alerts block the compatibility checker: Application.DisplayAlerts = False ActiveWorkbook.SaveAs "book1", xlWorkbookNormal ''XL97-03 -- Jim "Need Help Fast!" wrote in message ... |I need to save a folder full of excel files, but in .xls format. In 2007 it | always runs compatibility checker when saving in .xls. Is there a way to turn | this off in excel, turn it off with vba, or have code that would at least | check the ok box when asking if I still want to save in .xls format? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn off compatibility Checker in Excel 2007? | Excel Discussion (Misc queries) | |||
COMPATIBILITY CHECKER ON 2007 | Excel Discussion (Misc queries) | |||
Compatibility Checker-excel | Excel Discussion (Misc queries) | |||
Excel 2007 - Compatibility Checker | Excel Discussion (Misc queries) | |||
disable the Compatibility Checker in Excel | Excel Discussion (Misc queries) |