> Thanks,
> M. Berry

> That's the theoretical limit. I wouldn't recommend that you attempt to get
> anywhere near that though!

> I'd recommend you regularly use the Word VBA Code Cleaner from
> www.payneconsulting.com.

> If you use that regularly, it will tend to minimise file bloat resulting
> from repeated editing of the VBA code.

> That's the theoretical limit. I wouldn't recommend that you attempt to get
> anywhere near that though!

> I'd recommend you regularly use the Word VBA Code Cleaner from
> www.payneconsulting.com.

> If you use that regularly, it will tend to minimise file bloat resulting
> from repeated editing of the VBA code.

> > The total file size limit for a template is the same as for a document
as
> > far as I know. That limit is 32Mb plus the size of any embedded
graphics.

> > That's the theoretical limit. I wouldn't recommend that you attempt to
get
> > anywhere near that though!

> > I'd recommend you regularly use the Word VBA Code Cleaner from
> > www.payneconsulting.com.

> > If you use that regularly, it will tend to minimise file bloat resulting
> > from repeated editing of the VBA code.

> Hi Jonathan
> I am running Windows 98 and using Word and Access from Office 97
> (Professional).  Recently I have noticed that closing documents (in Word,
> Access and Excel) can often take a long time - circa 10 - 20 seconds.
> Sometimes the document closes almost instantly but leaves the
> (blank)application window on screen and it then takes some seconds to

> I have been having problems getting VB code to work in a Word macro for a
> mail merge job using an Access Table as the data source.  I have edited
the
> VB code many times and made copies with variations.  (These will be
deleted
> when I get my code working properly.)

> Could this be the cause of the slow file closures?

> > > I'd recommend you regularly use the Word VBA Code Cleaner from
> > > www.payneconsulting.com.

> > > If you use that regularly, it will tend to minimise file bloat
resulting
> > > from repeated editing of the VBA code.

> > Hi Jonathan
> > I am running Windows 98 and using Word and Access from Office 97
> > (Professional).  Recently I have noticed that closing documents (in
Word,
> > Access and Excel) can often take a long time - circa 10 - 20
seconds.
> > Sometimes the document closes almost instantly but leaves the
> > (blank)application window on screen and it then takes some seconds
to
> close.

> See if this article identifies the cause of the problem.

> Problems opening Word
> Word opens very slowly; or crashes (or gives an error message) as soon
as it
> opens
> http://www.mvps.org/word/FAQs/AppErrors/ProbsOpeningWord.htm

> > I have been having problems getting VB code to work in a Word macro
for a
> > mail merge job using an Access Table as the data source.  I have
edited
> the
> > VB code many times and made copies with variations.  (These will be
> deleted
> > when I get my code working properly.)

> > Could this be the cause of the slow file closures?

> Possibly.

> > If so would the Code
> > Cleaner from Payne be of some use?

> Very probably.

> > I visited their site but it gave only a
> > brief description of what their free download was supposed to do.  I
> > downloaded the file (PCGWordCodeCleaner.exe) but haven't used it yet
as I
> am
> > very wary of .exe files if I am uncertain exactly what they will do.
If I
> > run this program will it give me explanations of what it plans to do
> and/or
> > options to take and thus provide me with some degree of control?

> Yes it does. One of the options is to backup the template before doing
> anything else.

> > Obviously
> > I don't want to lose any of the work I have done so far.

> That file is just the installation routine. It installs an add-in in
Word's
> startup folder, so that you have an additional item in the Tools menu.
What
> the code cleaner does is back up your file, then export all the forms
&
> modules, re-import them and save. There are one or two other options
for
> further code shrinkage that I don't bother with.

> This cuts down the template bloat that arises from editing VBA,
particularly
> in Word 97. You can do all that by hand if you prefer, it just takes
longer.

> I use the VBA code cleaner regularly myself.

> Am I right in thinking that all the various macros are stored in the
> Normal.dot template and that it is that template that needs to be
> *cleaned* with the Code Cleaner?

> Correct.

> > If I open Word either with any
> > existing document or with a new blank Document1 and click Tools/VBA
Code
> > Cleaner, all that is shown in the Projects tab window is Normal.dot.
> > Presumably I would select Normal.dot and then click the OK button to
> > start the cleaning process?

> Correct. The code cleaner will offer to back up the template before it
> starts cleaning. I would recommend you accept the offer.

> Thanks for your response re Code Cleaner.  I installed the program but
> got some odd results when I ran it.

> Instead of getting the offer to back up the template I received the
> following message: -
> *Cannot make a backup of Normal.dot.  This you must do outside of Word
> while word is shut down.  Do you wish to continue?*

> I don't understand why this happened - do you?

> With Word shut down I found Normal.dot in C:\Program Files\Microsoft
> Office\Templates and manually made a copy.  Then opened Word and clicked
> the Yes button on the above mentioned message and the *clean* was done
> in a flash, and Normal .dot has been reduced from  368KB to 120KB.

> The Help file says that the source code has not been protected and can
> be viewed using the VB Editor, but a macro named Cleaner Main has the
> Edit button greyed out, and clicking the Step Into button produces a
> message *Project is unviewable*.  Very curious don't you think?

> The following is not really a vba problem and this may be the wrong
> group to post it to.  If so, please could you suggest a more suitable
> group?

> I am still experiencing problems when using Word.  Originally I was
> finding file closure (in Word, Excel and Access all in Office 97) taking
> up to 20 seconds before the Application window disappeared.  In your

> See if this article identifies the cause of the problem.

> Problems opening Word
> Word opens very slowly; or crashes (or gives an error message) as soon
> as it opens
> http://www.mvps.org/word/FAQs/AppErrors/ProbsOpeningWord.htm

> KB Q167081 appeared to deal with the problem, and I followed the
> instructions to clear the check boxes in the Journal tab for MS Outlook.
> I now find that file closure in all three applications is much faster
> and virtually back to *normal*.  How much is due to taking these steps
> or to using the Code Cleaner I am not sure.

> Opening Excel and Access is also quite quick but OPENING Word is now a
> very slow process.  When Word is called, initially the application
> window appears fairly quickly but consists of only a title - Microsoft
> Word (but no document title), a light grey band across the top (where
> the toolbars should be) and the rest of the window is dark grey.  After
> about 20 seconds the menu bar, toolbars, rulers and document title then
> appear.  Have you any suggestions as to the cause(s) and possible cures
> for this problem.  I would add that these opening/closing problems have
> only started in the last few weeks during the time I was frequently
> editing VB code for a Word macro using an Access Table as the Source
> document.

> > With Word shut down I found Normal.dot in C:\Program Files\Microsoft
> > Office\Templates and manually made a copy.  Then opened Word and
clicked
> > the Yes button on the above mentioned message and the *clean* was
done
> > in a flash, and Normal .dot has been reduced from  368KB to 120KB.

> > The Help file says that the source code has not been protected and
can
> > be viewed using the VB Editor, but a macro named Cleaner Main has
the
> > Edit button greyed out, and clicking the Step Into button produces a
> > message *Project is unviewable*.  Very curious don't you think?

> That sounds like Word is getting confused by multiple copies of
normal.dot.
> Close Word, delete or rename all copies of normal.dot except your
cleaned
> version, and make sure that one is back in the correct place.

> > The following is not really a vba problem and this may be the wrong
> > group to post it to.  If so, please could you suggest a more
suitable
> > group?

> Code cleaner questions are fine here :-)

> > I am still experiencing problems when using Word.  Originally I was
> > finding file closure (in Word, Excel and Access all in Office 97)
taking
> > up to 20 seconds before the Application window disappeared.  In your

> > See if this article identifies the cause of the problem.

> > Problems opening Word
> > Word opens very slowly; or crashes (or gives an error message) as
soon
> > as it opens
> > http://www.mvps.org/word/FAQs/AppErrors/ProbsOpeningWord.htm

> > KB Q167081 appeared to deal with the problem, and I followed the
> > instructions to clear the check boxes in the Journal tab for MS
Outlook.
> > I now find that file closure in all three applications is much
faster
> > and virtually back to *normal*.  How much is due to taking these
steps
> > or to using the Code Cleaner I am not sure.

> > Opening Excel and Access is also quite quick but OPENING Word is now
a
> > very slow process.  When Word is called, initially the application
> > window appears fairly quickly but consists of only a title -
Microsoft
> > Word (but no document title), a light grey band across the top
(where
> > the toolbars should be) and the rest of the window is dark grey.
After
> > about 20 seconds the menu bar, toolbars, rulers and document title
then
> > appear.  Have you any suggestions as to the cause(s) and possible
cures
> > for this problem.  I would add that these opening/closing problems
have
> > only started in the last few weeks during the time I was frequently
> > editing VB code for a Word macro using an Access Table as the Source
> > document.

> This question would probably better go to
> microsoft.public.word.application.errors. The people there see this
kind of
> question all the time, and will be able to offer advise that is much
better
> informed than I can manage :-)

> > Hi Jonathan,

> > Thanks for your response re Code Cleaner.  I installed the program
but
> > got some odd results when I ran it.

> > Instead of getting the offer to back up the template I received the
> > following message: -
> > *Cannot make a backup of Normal.dot.  This you must do outside of
Word
> > while word is shut down.  Do you wish to continue?*

> > I don't understand why this happened - do you?

> No for sure, but I admit that I tend to put code in other templates
rather
> than in normal.dot, and have never tried running the code cleaner on
> normal.dot. Since normal.dot is in use whenever Word is open, it might
> simply be that the code cleaner cannot work on normal.dot.

> > With Word shut down I found Normal.dot in C:\Program Files\Microsoft
> > Office\Templates and manually made a copy.  Then opened Word and
clicked
> > the Yes button on the above mentioned message and the *clean* was
done
> > in a flash, and Normal .dot has been reduced from  368KB to 120KB.

> > The Help file says that the source code has not been protected and
can
> > be viewed using the VB Editor, but a macro named Cleaner Main has
the
> > Edit button greyed out, and clicking the Step Into button produces a
> > message *Project is unviewable*.  Very curious don't you think?

> That sounds like Word is getting confused by multiple copies of
normal.dot.
> Close Word, delete or rename all copies of normal.dot except your
cleaned
> version, and make sure that one is back in the correct place.

> > The following is not really a vba problem and this may be the wrong
> > group to post it to.  If so, please could you suggest a more
suitable
> > group?

> Code cleaner questions are fine here :-)

> > I am still experiencing problems when using Word.  Originally I was
> > finding file closure (in Word, Excel and Access all in Office 97)
taking
> > up to 20 seconds before the Application window disappeared.  In your

> > See if this article identifies the cause of the problem.

> > Problems opening Word
> > Word opens very slowly; or crashes (or gives an error message) as
soon
> > as it opens
> > http://www.mvps.org/word/FAQs/AppErrors/ProbsOpeningWord.htm

> > KB Q167081 appeared to deal with the problem, and I followed the
> > instructions to clear the check boxes in the Journal tab for MS
Outlook.
> > I now find that file closure in all three applications is much
faster
> > and virtually back to *normal*.  How much is due to taking these
steps
> > or to using the Code Cleaner I am not sure.

> > Opening Excel and Access is also quite quick but OPENING Word is now
a
> > very slow process.  When Word is called, initially the application
> > window appears fairly quickly but consists of only a title -
Microsoft
> > Word (but no document title), a light grey band across the top
(where
> > the toolbars should be) and the rest of the window is dark grey.
After
> > about 20 seconds the menu bar, toolbars, rulers and document title
then
> > appear.  Have you any suggestions as to the cause(s) and possible
cures
> > for this problem.  I would add that these opening/closing problems
have
> > only started in the last few weeks during the time I was frequently
> > editing VB code for a Word macro using an Access Table as the Source
> > document.

> This question would probably better go to
> microsoft.public.word.application.errors. The people there see this
kind of
> question all the time, and will be able to offer advise that is much
better
> informed than I can manage :-)

> --
> Regards
> Jonathan West - Word MVP
> MultiLinker - Automated generation of hyperlinks in Word
> Conversion to PDF & HTML
> http://www.multilinker.com
> Word FAQs at http://www.multilinker.com/wordfaq
> Please post any follow-up in the newsgroup. I do not reply to Word
questions
> by email