[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.

[Graham Mayor]

See if http://www.gmayor.com/installing_macro.htm helps?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Rebecca Morris wrote:
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.

[Rebecca Morris]

This link doesn't work, it says "Service Unavailable"?

"Graham Mayor" wrote:

See if http://www.gmayor.com/installing_macro.htm helps?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Rebecca Morris wrote:
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.

[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/boo...x#AboutTheBook

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

"Rebecca Morris" wrote in message
...
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.

[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

"Rebecca Morris" wrote in message
...
This link doesn't work, it says "Service Unavailable"?

"Graham Mayor" wrote:

See if http://www.gmayor.com/installing_macro.htm helps?

Rebecca Morris wrote:
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.

[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.

"Beth Melton" wrote:

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/boo...x#AboutTheBook

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

"Rebecca Morris" wrote in message
...
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.

[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/boo...x#AboutTheBook

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

"Rebecca Morris" wrote in message
...
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.

[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).

"Beth Melton" wrote:

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/boo...x#AboutTheBook

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

"Rebecca Morris" wrote in message
...
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.

[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.

"Beth Melton" wrote:

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/boo...x#AboutTheBook

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

"Rebecca Morris" wrote in message
...
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.

[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/boo...x#AboutTheBook

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

"Rebecca Morris" wrote in message
...
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.

[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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Beth Melton wrote:
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

"Rebecca Morris" wrote in
message ...
This link doesn't work, it says "Service Unavailable"?

"Graham Mayor" wrote:

See if http://www.gmayor.com/installing_macro.htm helps?

Rebecca Morris wrote:
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.

[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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Rebecca Morris wrote:
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.

"Beth Melton" wrote:

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/boo...x#AboutTheBook

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

"Rebecca Morris" wrote in
message ...
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.

[Beth Melton]

Ah, I see that now. Previously I only saw the screen shots from the previous
version.

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/boo...x#AboutTheBook

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

"Graham Mayor" wrote in message
...
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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Beth Melton wrote:
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

"Rebecca Morris" wrote in
message ...
This link doesn't work, it says "Service Unavailable"?

"Graham Mayor" wrote:

See if http://www.gmayor.com/installing_macro.htm helps?

Rebecca Morris wrote:
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.