M
Michael C
I have created from scratch a new main workbook and several 'satellite'
dynamically populated/'built' report templates - in 2007 (as, 2003 to 2007
seemed to fraught with danger).
All runs well, I have saved versions of the 2007 workbooks as 97-2003
workbooks with a couple of compatability 'fixes' around colour formats and
shape formats. In 2003, I can run these (both the master workbook and the
report templates )independantly and all works fine.
But - if I call the report via the parameter selection main workbook
reporting FORM - the report is found, opened, parameters populated, list
boxes filled and report dynamically structured - all well. THe code then
seeks to return to the main workbook to wrap up there - - and, alas, XL
either falls over OR I get the following message (ad-infinitum):
"Excel cannot complete this task with available resources. Choose less data
or close other applications."
Note - if the report is already open - and NOT opened via the procedure -
then, all is fine again - however, that's not really sustainable - to open
all report templates first...but - even though there ARE not links, is there
some silly order of opening issue here?
----any ideas??
There ARE pictures and shapes and activeX combo boxes on the report template.
The main workbook has pictures, shapes (acting as buttons), forms galore.
I've already found that using a 'shape' in 2007 to close a workbook is
dangerous and use activeX controls for that. I'm just a tad nervous about
this whole 2003/2007 thing.
dynamically populated/'built' report templates - in 2007 (as, 2003 to 2007
seemed to fraught with danger).
All runs well, I have saved versions of the 2007 workbooks as 97-2003
workbooks with a couple of compatability 'fixes' around colour formats and
shape formats. In 2003, I can run these (both the master workbook and the
report templates )independantly and all works fine.
But - if I call the report via the parameter selection main workbook
reporting FORM - the report is found, opened, parameters populated, list
boxes filled and report dynamically structured - all well. THe code then
seeks to return to the main workbook to wrap up there - - and, alas, XL
either falls over OR I get the following message (ad-infinitum):
"Excel cannot complete this task with available resources. Choose less data
or close other applications."
Note - if the report is already open - and NOT opened via the procedure -
then, all is fine again - however, that's not really sustainable - to open
all report templates first...but - even though there ARE not links, is there
some silly order of opening issue here?
----any ideas??
There ARE pictures and shapes and activeX combo boxes on the report template.
The main workbook has pictures, shapes (acting as buttons), forms galore.
I've already found that using a 'shape' in 2007 to close a workbook is
dangerous and use activeX controls for that. I'm just a tad nervous about
this whole 2003/2007 thing.