Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Compatability Checker in Automation
Hi Folks
First post here, so not sure if this is the right board for a query of this level but here goes: We have a .Net application that uses automation to drive Excel in the background (not visible) and when the application closes it closes Excel and the open workbook. So far so good. The problem we now have is that the first time you use our application with a workbook created in Excel 2003 but where the machine running the application has Excel 2007 installed, when you close the workbook the application appears to hang. It is not hanging, Excel has opened a "Compatability Checker" dialog behind our main application window reporting "Minor Loss of Fidelity" x7. Ideally we would like to be able to suppress this dialog OR control it some way. Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Compatability Checker in Automation
try Application.Displayalerts=False
Charles __________________________________________________ Outlines for my Sessions at the Australia Excel Users Group http://www.decisionmodels.com/OZEUC.htm "Howard Pierce-Morgan" wrote in message ... Hi Folks First post here, so not sure if this is the right board for a query of this level but here goes: We have a .Net application that uses automation to drive Excel in the background (not visible) and when the application closes it closes Excel and the open workbook. So far so good. The problem we now have is that the first time you use our application with a workbook created in Excel 2003 but where the machine running the application has Excel 2007 installed, when you close the workbook the application appears to hang. It is not hanging, Excel has opened a "Compatability Checker" dialog behind our main application window reporting "Minor Loss of Fidelity" x7. Ideally we would like to be able to suppress this dialog OR control it some way. Any ideas? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disabling Compatability Checker in Automation
Thanks Charles
Unfortunately we already tried this and it doesn't work. Regards Howard "Charles Williams" wrote: try Application.Displayalerts=False Charles __________________________________________________ Outlines for my Sessions at the Australia Excel Users Group http://www.decisionmodels.com/OZEUC.htm "Howard Pierce-Morgan" wrote in message ... Hi Folks First post here, so not sure if this is the right board for a query of this level but here goes: We have a .Net application that uses automation to drive Excel in the background (not visible) and when the application closes it closes Excel and the open workbook. So far so good. The problem we now have is that the first time you use our application with a workbook created in Excel 2003 but where the machine running the application has Excel 2007 installed, when you close the workbook the application appears to hang. It is not hanging, Excel has opened a "Compatability Checker" dialog behind our main application window reporting "Minor Loss of Fidelity" x7. Ideally we would like to be able to suppress this dialog OR control it some way. Any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Compatability Checker | Excel Discussion (Misc queries) | |||
Compatability Checker .xlsx workbooks | Excel Discussion (Misc queries) | |||
Excel 07 compatability checker | Excel Discussion (Misc queries) | |||
Excel 2007 Compatability Checker | Excel Discussion (Misc queries) | |||
Compatability checker | Excel Discussion (Misc queries) |