M
Mathew
Hi,
I have a fairly complex VBA project within Excel which
reads a SQL Server database for data, populates a data
sheet and then dynamically generates charts based onthe
data. I do it dynamically because copying a sheet
containing charts truncated the data series in the charts
and left them un-editable.
Anyway, after applying several font changes, I get the
error - Unable to set the xxx property of the Font Class
(where xxx is a font property). If I then try to do it
manually I get - No more new fonts may be applied to this
workbook. I also get the 'Not enough systemm resources to
display completely' error.
Any ideas ?
Also, after copying my data sheet and chart sheet to the
target workbook a number of times (and doing the
requisite processing) Excel fails without an error
message. I assume this is to do with a lack of resources.
Again any ideas ?
Many Thanks
I have a fairly complex VBA project within Excel which
reads a SQL Server database for data, populates a data
sheet and then dynamically generates charts based onthe
data. I do it dynamically because copying a sheet
containing charts truncated the data series in the charts
and left them un-editable.
Anyway, after applying several font changes, I get the
error - Unable to set the xxx property of the Font Class
(where xxx is a font property). If I then try to do it
manually I get - No more new fonts may be applied to this
workbook. I also get the 'Not enough systemm resources to
display completely' error.
Any ideas ?
Also, after copying my data sheet and chart sheet to the
target workbook a number of times (and doing the
requisite processing) Excel fails without an error
message. I assume this is to do with a lack of resources.
Again any ideas ?
Many Thanks