R
Ron West
I have a set of spreadsheets that work fine (auto-launched at 5am unattended)
in Excel 2003.
There is a central control workbook that calls each of a list of up to 20
data manipulation spreadsheets in turn, according to which of the checkboxes
in a column in the main spreadsheet are checked. Each worker spreadsheet is
opened, executed, and then closed, originally using "ActiveWindow.Close".
Unfortunately, when migrating to Excel 2007 SP1, the "ActiveWindow.Close"
line causes Excel to crash so fundamentally that other applications (such as
BrioQuery) stop working properly - so I have to reboot the machine.
I have tried using alternatives to "ActiveWindow.Close" - for example
Worksheets("name").Close, objectname.Close, etc, but it makes no difference.
Eliminating Compatibility Mode (saving all activated worksheets as .XLSM)
made no difference.
I’ve also done some research via Google and came across some pages that gave
solutions to similar problems - for example using ActiveX buttons from the
Toolbox to call the code instead of "Form" buttons - but none of them made
any difference.
Any ideas?
in Excel 2003.
There is a central control workbook that calls each of a list of up to 20
data manipulation spreadsheets in turn, according to which of the checkboxes
in a column in the main spreadsheet are checked. Each worker spreadsheet is
opened, executed, and then closed, originally using "ActiveWindow.Close".
Unfortunately, when migrating to Excel 2007 SP1, the "ActiveWindow.Close"
line causes Excel to crash so fundamentally that other applications (such as
BrioQuery) stop working properly - so I have to reboot the machine.
I have tried using alternatives to "ActiveWindow.Close" - for example
Worksheets("name").Close, objectname.Close, etc, but it makes no difference.
Eliminating Compatibility Mode (saving all activated worksheets as .XLSM)
made no difference.
I’ve also done some research via Google and came across some pages that gave
solutions to similar problems - for example using ActiveX buttons from the
Toolbox to call the code instead of "Form" buttons - but none of them made
any difference.
Any ideas?