Hope this isn't a dumb question, but................

  • Thread starter Charlie_Chaplin
  • Start date
C

Charlie_Chaplin

I've noticed that the macros I've recorded show up in the "NewMacros"
under the "Normal" part of the Project Explorer in the VBA IDE. I
assume that means all the code is in the Normal.dot file in the Word
Startup folder.

[snare drum roll] So ... here's my dumb question:

What if I'd rather not add anything to to Normal.dot and would rather
create a file named "AllMyMacros.dot" that will always load no matter
what document I'm working in? Any macro I record or code should
automatically go in that file so that I can leave Normal.dot alone?
 
J

Jean-Guy Marcil

Charlie_Chaplin was telling us:
Charlie_Chaplin nous racontait que :
I've noticed that the macros I've recorded show up in the "NewMacros"
under the "Normal" part of the Project Explorer in the VBA IDE. I
assume that means all the code is in the Normal.dot file in the Word
Startup folder.

Normal.dot is not normally found in the start-up folder, but in the default
template folder or the user template folder. See Tools > Options > File
Locations tab for the different path/folder Word uses.
[snare drum roll] So ... here's my dumb question:

What if I'd rather not add anything to to Normal.dot and would rather
create a file named "AllMyMacros.dot" that will always load no matter
what document I'm working in? Any macro I record or code should
automatically go in that file so that I can leave Normal.dot alone?

Create a *.dot file and place it in the Word Start-Up folder (notice this
one does go into the Start-Up folder) so that it gets loaded every time you
start Word.

Now, when creating macros, make sure you select that template (you will need
to open it first) and not Normal.dot. I do not think you can automate this
part.
If you forget (or would rather not open it when creating your macros), just
drag the module from Normal to your template in the VBA IDE (Or cut/paste
the Sub) when you do et around to opening that template.

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org
 
S

Steve

Charlie_Chaplin said:
[snare drum roll] So ... here's my dumb question:

No such thing!
What if I'd rather not add anything to to Normal.dot and would rather
create a file named "AllMyMacros.dot" that will always load no matter
what document I'm working in? Any macro I record or code should
automatically go in that file so that I can leave Normal.dot alone?

I'm not too familiar with using VBA in Word, but have done so in Excel some
time ago. I seem to remember that Excel had a "Personal.xls" file that was
in the background that you could store all your macros in. Might be worth
checking if Word has an equivalent?

Probably not helping ... but worth a try!

Steve.
 
J

Jean-Guy Marcil

Steve was telling us:
Steve nous racontait que :
Charlie_Chaplin said:
[snare drum roll] So ... here's my dumb question:

No such thing!
What if I'd rather not add anything to to Normal.dot and would rather
create a file named "AllMyMacros.dot" that will always load no matter
what document I'm working in? Any macro I record or code should
automatically go in that file so that I can leave Normal.dot alone?

I'm not too familiar with using VBA in Word, but have done so in
Excel some time ago. I seem to remember that Excel had a
"Personal.xls" file that was in the background that you could store
all your macros in. Might be worth checking if Word has an
equivalent?

Probably not helping ... but worth a try!

Steve.

Template and macros storing are quite different between Excel and Word.

One striking example is that when you create a workbook from a template, the
code is part of the newly created workbook.
Not so in Word.
In this particular case, it means that if you update the code in the Word
template, documents already created will have access to the new code next
time you open them. In Excel, you would have to open all documents and
change the code in all of them...

Toolbars are also very different.

Etc.

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top