Import macro from Normal.dot to 2007 Normal.dot?

R

Rebecca Morris

I'm a new user of Word 2007 with Vista. I have a macro that's in my
Normal.dot from my older version of Word (2003?). I would like to convert
the entire Normal.dot to the new format (Normal.dotx? Normal.dotm?) and I've
read the posts about that with no luck following the suggestions. I have one
macro in particular that I really need to insert in the new normal so that
it's available for all of my word documents and templates. It's a merge
macro in MVB that brings in data from a windows-based program that uses
Access for its database and has its own mergefields for Word. I have found
the macro (PCMerge) in MVB and exported it, but I can't figure out how to
bring it in. Thank you.
 
B

Beth Melton

If you want just the macro, in Word 2007, click the Microsoft Office Button
and then click Word Options. In the Popular section, make sure "Show
Developer tab in the Ribbon" is selected. Click OK to close Word Options.

Open your old Normal.dot in Word. Then on the Developer tab, click Document
Template and at the bottom, click Organizer and select the Macro Project
Items tab. Make sure you have your old Normal.dot and your Normal.dotm both
open in the Organizer. Then select the macro (it will have the Module name -
not the macro name) and then click Copy to copy it to your Normal.dotm.
Close the Organizer and save the files if prompted.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
B

Beth Melton

Plus it's for previous version of Word, not Word 2007. :)

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
 
R

Rebecca Morris

Please excuse my ignorance, I have a very basic understanding of this stuff.
:) Ok, I have made it so I can access the macro by adding the Macro menu to
the Quick Start toolbar. This macro is one I use in ALL documents and want
it to be available via the Quick Start Toolbar all by itself. Can't seem to
figure it out. so far, I can click the Macro button on the QST and a window
opens where I can choose the macro, click Run, and it works. How can I
eliminate the additional steps of clicking Macro, then selecting - can I just
add the macro to the QST?

Or, maybe I'm asking how can I make the Add-In toolbar always availabe? If
I open my old Normal.dot in Word 2007, the Add-In toolbar is there and my
macro is there as well.
 
B

Beth Melton

You almost have it. :)

If you want to add the macro to your QAT, select Macros from the "Choose
commands from" drop down. Add the macro and then use the Modify button to
modify the icon used or the ScreenTip. Note if you do not know how to get in
to the QAT customization, right-click your QAT and then click the Customize
command.

Now, if you'd prefer to use their template as an add-in (so the add-in tab
displays) then place their template in one of your Startup folders and it
will load when Word starts. To find the location of your Word Startup
folder, click the Microsoft Office Button, click Word Options, and then
click Advanced. Scroll down to the bottom of the options and click File
Locations. Your Word Startup folder should be in the list that appears in
the File Locations dialog box. Select Startup and then click Modify to
determine the full path.

You'll probably need to open the Look in drop down to see it. What I do is
click the Up One Level button, right-click the Startup folder and then click
Explore to open the folder in an Exploring window. That makes it easier to
move the file. Note if you use this method then you'll want to delete the
macro from your Normal.dotm. It shouldn't cause a conflict, since it's in
two different templates, but it could cause some confusion at some point.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
R

Rebecca Morris

I think I did add this to my QAT before and deleted it because it didn't
work. I re-did this and when I click on the button for the macro it says
"Argument Not Optional". I have no idea what this means. I went to the help
box and I have no clue what an argument is (on the computer, that is).
 
R

Rebecca Morris

Ok! I used the 2nd method and it's there. I guess I thought the macro
needed to be in the templates rather than the Startup. If you happen to know
what the Argument error message means, I would rather have it that way, but
this at least works. Thank you. :)
 
B

Beth Melton

I'd say the "argument not optional" error message means that there are other
macros/procedures in the template that are being called from your main macro
and they were missing. Based on what you described it does sound more
complex than a single macro. (If you really want to know what "argument not
optional" means I can explain that as well but it would involve a little
techo-speak, just to forewarn you. ;-) )

You should be able to add the macro to your QAT now, just use the one from
the global template instead. It sounds like it's functioning correctly since
it's no longer missing components.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email cannot be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Coauthor of Word 2007 Inside Out:
http://www.microsoft.com/MSPress/books/9801.aspx#AboutTheBook

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/
 
G

Graham Mayor

The page is neither unavailable nor limited to Word 2003? I have updated all
the pages on my web site to reflect the differences in Word 2007.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
G

Graham Mayor

You'll need to post your code and indicate which line the error occurs on.
Word 2007 has some changes in its vba that means some earlier code will not
run.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 

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

Similar Threads

Retain normal.dot (Word 2003 settings) in Word 2007 0
Missing of Normal.dot 3
Word - Normal.dot 2
Location of "normal.dot" file in Word 2007 under Vista ULTIMATE? 8
Transferring Word 2002 template to Word 2007 template 2
Convert 2002 Word Autotext into 2007 Word Auto Text 7
How to apply normal.dot setting for new doc created by right clic. 3
Convert normal.dot in W2000 to normal.dotm in W2007 3

Top