Moving Macro from Word 2003 to 2007

[Kristie Cochran]

I have a macro that I run in Word 2003. I have a button on the tool bar
that I just click and it runs the macro for me. How do I move this
macro from Word 2003 to Word 2007? Is it saved somewhere? I didn't
create the macro, I just somehow copied it from the creator (this has
been many years ago), and was able to copy it to to my computer.

TIA!

Kristie

 

[Graham Mayor]

The macro will be stored in a template, probably the normal template.
http://www.gmayor.com/installing_macro.htm should help explain how it all
works. Copy it to normal.dotm and add a button the the QAT (Quick Access
Toolbar) - the linked page explains how.

It will probably work as it stands, but if not, you will need to tell us
what it does.

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

My web site www.gmayor.com

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

 

[Kristie Cochran]

Thanks for the info! I found the original document that (I thought)
contained the macro, but when I open the Macro dialog box, there are no
macros listed. I'll see if I can get the Macro sent to me again. The
person I'm getting it from is using Word 2003 and I just recently
upgraded to Word 2007 and Windows 7. Can you direct me to a link that
will show to forward the macro to me?

The macro just formatted the current document, changing fonts, spacing,
hanging indents, that kind of thing. I don't know that I could recreate
it on my own.

Thank you for your help!

Kristie

 

[Graham Mayor]

The macro can be forwarded as a plain text listing.
The macro you describe seems to duplicate the function of a template. It
might be better to simply create a template with the paragraph styles and
layout that you require.

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

My web site www.gmayor.com

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

 

[Suzanne S. Barnhill]

I'll second Graham's recommendation that a template is a much more suitable
tool for this purpose. To get started, see
http://word.mvps.org/FAQs/Customization/CreateATemplatePart1.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

 

[Kristie Cochran]

I do have a template, but what we're doing is taking an existing
document (a transcript of a tv show) and then we have to copy/paste
parts of that document and make a new document. So, we run the macro to
get the formatting correct first (for our template), then the copy and
paste the parts we need. When we have to transcribe something from
scratch, then we use the template.

So we do need the macro to do that for us.

Kristie

 

[Kristie Cochran]

In talking with my DH, all we did on my computer is to upgrade from
Windows Vista to Windows 7 (beta) and upgrade my Office 2003 to 2007.
Sooo, I would assume that the macro is still on my computer, but I don't
know how to find it. When I open Word, go to Macros, that Macro is not
listed in my now Normal.dotm. Should I look for the Normal.dot and see
if it is there? And do you know where that template (normal.dot) is
stored??

It's been years (since 2003 or so) since I installed that macro and
assigned it a toolbar button. I just didn't think about it when we
upgraded to Office 2007 and now I need it!

Kristie

 

[Graham Mayor]

'Upgrades' are designed to retain personal settings so the probability is
that you still have normal.dot on your PC. I don't know anything about the
file structure of Windows 7 but a search for normal.dot should find it if
present (tell your search tool to look for hidden and system files).

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

My web site www.gmayor.com

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

 

[Graham Mayor]

Fellow MVP Jay Freedman has reminded me that the Word 2007 installer renames
the normal.dot template to Normal11.dot. If you put this file in the Word
startup folder, it should bring with it the macros and may bring the toolbar
which would be added to the add-ins tab of the ribbon - however it may not,
so my then previous suggestion to add a button to the QAT (Quick Access
Toolbar) would apply.

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

My web site www.gmayor.com

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

 

[Kristie Cochran]

Thanks for your help. I did find the Normal1.dot last night, but the
macro is still not showing. I even changed the macro security settings
to see if that was the problem (enable all macros), but it's still not
showing up.

I did copy Normal1.dot to the Startup folder in Office 12 (there was an
Office 11 also, maybe that's from 2003??) and when I look at the Add-in
Options, Normal1.dot shows up. My macro is still not showing up.

I'll see if I can get it sent to me again. Can the code just be copied
from VB into a doc and then I can copy it into VB on my end and create a
new macro?

I really appreciate all of your help with this!

Kristie

 

[Graham Mayor]

Macro listings are simply plain text (see
http://www.gmayor.com/installing_macro.htm ) and can be copied and pasted
from the vba editor into e-mail messages (or you can get your correspondent
to send you a copy of the template or document that contains it).

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

My web site www.gmayor.com

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

 

[Kristie Cochran]

Thank you!!! I got the text and got it all working now!! I've saved
the text into a Word doc so that I'll have it in the future.

Kristie