Howard
Thu Oct 21 13:50:56 CDT 2004
You are always referring to objects within code.
Take a look at the Help for With.
--
http://www.standards.com/; See Howard Kaikow's web site.
"Zokess" <Zokess@discussions.microsoft.com> wrote in message
news:E59AA182-85E7-4BB5-ADFC-0E6CE077BA76@microsoft.com...
> Howard, Thanks for the tips...unfortunately, I have already gotten rid of
any
> Varient data types that I did use, I have not used any object data types
and
> don't believe I used any onject references. At least not directly...I did
> have a few procedures that were too large for Word VBA to handle so I
broke
> them up into seperate procedures and call them as needed.
>
> Any more advice / help? I appreciate it all!!
>
> "Howard Kaikow" wrote:
>
> > The first step is to clean up the code using tricks such as:
> >
> > 1. Do not use the Variant data type.
> > 2. Do not use the Object data type, unless absolutely necessary.
> > 3. Get rid of all unnecessary object references by using With ... End
With.
> >
> > Making those, and other changes, you may be able to reduce running time
by
> > over 99%.
> >
> > --
> >
http://www.standards.com/; See Howard Kaikow's web site.
> > "Zokess" <Zokess@discussions.microsoft.com> wrote in message
> > news:286705EB-8122-4E16-B6AA-0BD13BBEA67A@microsoft.com...
> > > I have created what I believe to be a rather complex document/program
in
> > word
> > > (I believe there are over 13000 total lines of code). I have quite a
few
> > > auto-text entries that either are, or contain graphics. The overall
size
> > of
> > > my Word Template (one I created specifically for this purpose, not
> > > Normal.doc) is quite close to 8 Megs. The document doesn't seem like
it
> > > takes excessivly long to open, or for the first UserForm to appear as
a
> > > reault of the AutoNew Macro which calls the form. It seems like it
takes
> > > excessively long for 1) items to be transferred from the userform
> > comboboxes
> > > and text boxes to the FormFields in the template, 2) the userForm to
> > unload,
> > > and 3) the 2nd userform to load. Then it seems to take excessively
long
> > for
> > > the same things to occur with the 2nd userform.
> >
> >
> >