Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 hangs on programmed file close
I am working in Excel 2007 with SP1. I have a workbook with VBA that works
fine except that the Module that closes the workbook, using ActiveWorkbook.Close, hangs Excel when run. If I step through the code it closes normally and Excel doesn't hang. The same workbook running in 2003 works fine. What causes this and how do I stop it? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 hangs on programmed file close
Can you post the code you are using and then it can be assessed/tested?
-- Regards, OssieMac "Richard MG" wrote: I am working in Excel 2007 with SP1. I have a workbook with VBA that works fine except that the Module that closes the workbook, using ActiveWorkbook.Close, hangs Excel when run. If I step through the code it closes normally and Excel doesn't hang. The same workbook running in 2003 works fine. What causes this and how do I stop it? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 hangs on programmed file close
I think that this is your problem
See the last section on this page http://www.rondebruin.nl/shape.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Richard MG" wrote in message ... I am working in Excel 2007 with SP1. I have a workbook with VBA that works fine except that the Module that closes the workbook, using ActiveWorkbook.Close, hangs Excel when run. If I step through the code it closes normally and Excel doesn't hang. The same workbook running in 2003 works fine. What causes this and how do I stop it? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 hangs on programmed file close
Thanks, Ron. Perfect! It worked just fine.
"Ron de Bruin" wrote: I think that this is your problem See the last section on this page http://www.rondebruin.nl/shape.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Richard MG" wrote in message ... I am working in Excel 2007 with SP1. I have a workbook with VBA that works fine except that the Module that closes the workbook, using ActiveWorkbook.Close, hangs Excel when run. If I step through the code it closes normally and Excel doesn't hang. The same workbook running in 2003 works fine. What causes this and how do I stop it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 hangs while loading chart | Charts and Charting in Excel | |||
Open, Save and close Excel 2007 file with a cmd command | Excel Discussion (Misc queries) | |||
Excel 2007: How do I disable the 'Do you wish to save changes to...' when I close an un changed file? | Excel Discussion (Misc queries) | |||
Excel 2007 Hangs until Minimized | Excel Discussion (Misc queries) | |||
Excel hangs on close when using Web services in add-in | Excel Programming |