Automation Template, file size
- From: "Haukwa" <glkehler@xxxxxxxxxxxxx>
- Date: 22 Feb 2006 07:37:03 -0800
Everyone,
I am interested in hearing from the group about file sizes for template
documents heavily fortified by VBA code and AutoText entries.
Background...I'm a VBA novice/intermediate user and I've never
attempted a project this size. I'm well into a project to automate the
generation of a report using user input and autotext entries. Has
anyone run into problems with template (*.dot) file sizes exceeding
10MB?
The mytemplate.dot file is approaching 1MB. So far mytemplate.dot
consists of the following:
- one userform, with a 6-page Multipage object, with 358 control
objects (including labels, buttons, textboxes, etc.).
- code to support the userform (populating comboboxes, manipulating
labels, restricting access to textboxes, etc.)
- code to generate mytemplate.ini file
I'm beginning the process of writing the autotext entries and the code
to arrange the autotext entries into the final deliverable/report. The
final deliverable will be four to five pages long.
Any comments are appreciated.
Thanks,
Gerry
.
- Prev by Date: Re: Parse style names into alias segments?
- Next by Date: Re: Open Word and call Word macro from within Excel VBA?
- Previous by thread: Toggle spell check in code?
- Next by thread: Re: Automation Template, file size
- Index(es):
