I've written 2 fairly large Excel programs (each having over 1000 lines of
code and several forms) and I'm concerned about optimizing memory/speed as
these programs continue to grow. I have some specific questions

1) Is it better to store temporary data within arrays in the code or to send
data to worksheet cells as much as possible?

2) Is it better to store text within the program code or to gather it from
some separate workbook containing the text? The text I'm talking about comes
from comments in my code that will become headings to rows and columns and
comments in those headings.

3) I tend to provide extensive documentation comments within my code for
future programmers and myself. Do i pay a price in memory or speed for doing
this?

4) I've stayed away from producing Excel charts in some cases because I
guessed they would degrade speed/memory usage. Without those charts the
workbooks generated by my programs are typically 500K in size. Am I being
too cautious?

Our company uses fairly modern computers with, for example, 1GB RAm
typically and the programs I'm making use Excel 2003 to drive AutoCAD, which
means both those programs are running at the same time when the programs are
being used.

Thanks for any advice,

-Tony