A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Macro help



 
 
Thread Tools Display Modes
  #1  
Old May 4th, 2005, 08:00 PM
Kathryn
external usenet poster
 
Posts: n/a
Default Macro help

I have a computer running Word 2000. I have a new computer running Word
2003. I have a couple of Word macros that I need to move to the new
computer. I have already looked through old messages and have looked at
http://addbalance.com/word/movetotemplate.htm and
http://word.mvps.org/FAQs/General/FilesToBackup.htm and
http://word.mvps.org/FAQs/Customizat...latesStore.htm but still
cannot figure out how to move the macros to my new computer. When I open
Word 2000, my computer does not behave the way that it should according to
the addbalance site. Using the Organizer button doesn't show my macros;
using the VBA Editor doesnt' show any macros either, yet they are there and
run when I use them.

I have tried to simply copy the .dot file over to the new computer but I put
it in the subdirectory that Word looks in for templates but it does not see
it there.

Any help?
  #2  
Old May 4th, 2005, 09:10 PM
Charles Kenyon
external usenet poster
 
Posts: n/a
Default

Hi Kathryn,

I wrote the article on the Add Balance site. I may have made assumptions
that you are not making. Sorry. The steps in it work when followed exactly.

You do not want your old template in the user templates folder or the
workgroup templates folder, you want them in the Word startup folder. I
suspect that you have done this. For more on the different kinds of
templates, tabs on the file new dialog, and locations of templates folders
see http://addbalance.com/usersguide/templates.htm.

The macros will not show up in the organizer because you do not have your
template _open_ in the organizer. They will not show up in the vba editor
because you do not have your template open. They run because you have your
template added as an Add-In. To get them available for editing, you need to
actually open the template so that it is visible on your screen. Doing this
will also make the macro modules available in the organizer. Note that
individual macros do not show up in the organizer, only modules.
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.



"Kathryn" wrote in message
...
I have a computer running Word 2000. I have a new computer running Word
2003. I have a couple of Word macros that I need to move to the new
computer. I have already looked through old messages and have looked at
http://addbalance.com/word/movetotemplate.htm and
http://word.mvps.org/FAQs/General/FilesToBackup.htm and
http://word.mvps.org/FAQs/Customizat...latesStore.htm but still
cannot figure out how to move the macros to my new computer. When I open
Word 2000, my computer does not behave the way that it should according to
the addbalance site. Using the Organizer button doesn't show my macros;
using the VBA Editor doesnt' show any macros either, yet they are there
and
run when I use them.

I have tried to simply copy the .dot file over to the new computer but I
put
it in the subdirectory that Word looks in for templates but it does not
see
it there.

Any help?



  #3  
Old May 5th, 2005, 12:17 AM
Suzanne S. Barnhill
external usenet poster
 
Posts: n/a
Default

Make sure you are saving the file to the folder specified for "User
templates" on the File Locations tab of Tools | Options.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Kathryn" wrote in message
...
I have a computer running Word 2000. I have a new computer running Word
2003. I have a couple of Word macros that I need to move to the new
computer. I have already looked through old messages and have looked at
http://addbalance.com/word/movetotemplate.htm and
http://word.mvps.org/FAQs/General/FilesToBackup.htm and
http://word.mvps.org/FAQs/Customizat...latesStore.htm but still
cannot figure out how to move the macros to my new computer. When I open
Word 2000, my computer does not behave the way that it should according to
the addbalance site. Using the Organizer button doesn't show my macros;
using the VBA Editor doesnt' show any macros either, yet they are there

and
run when I use them.

I have tried to simply copy the .dot file over to the new computer but I

put
it in the subdirectory that Word looks in for templates but it does not

see
it there.

Any help?


  #4  
Old May 5th, 2005, 04:56 AM
Charles Kenyon
external usenet poster
 
Posts: n/a
Default

Hi Suzanne,

My diagnosis, which may be off, is that the macros are currently stored in
an Add-In. That is the only way I know to have operational macros that don't
show up in the vb editor or the organizer. So the template needs to be moved
from the Startup folder on the old computer to the new computer.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Suzanne S. Barnhill" wrote in message
...
Make sure you are saving the file to the folder specified for "User
templates" on the File Locations tab of Tools | Options.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup
so
all may benefit.

"Kathryn" wrote in message
...
I have a computer running Word 2000. I have a new computer running Word
2003. I have a couple of Word macros that I need to move to the new
computer. I have already looked through old messages and have looked at
http://addbalance.com/word/movetotemplate.htm and
http://word.mvps.org/FAQs/General/FilesToBackup.htm and
http://word.mvps.org/FAQs/Customizat...latesStore.htm but still
cannot figure out how to move the macros to my new computer. When I open
Word 2000, my computer does not behave the way that it should according
to
the addbalance site. Using the Organizer button doesn't show my macros;
using the VBA Editor doesnt' show any macros either, yet they are there

and
run when I use them.

I have tried to simply copy the .dot file over to the new computer but I

put
it in the subdirectory that Word looks in for templates but it does not

see
it there.

Any help?




  #5  
Old May 5th, 2005, 05:55 PM
Suzanne S. Barnhill
external usenet poster
 
Posts: n/a
Default

Ah, okay, I got in on this late. In either case, I suspect that Kathryn is
putting them in the folder reserved for Word's own installed templates
rather than either the User Templates or the Startup folder.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Charles Kenyon" wrote in
message ...
Hi Suzanne,

My diagnosis, which may be off, is that the macros are currently stored in
an Add-In. That is the only way I know to have operational macros that

don't
show up in the vb editor or the organizer. So the template needs to be

moved
from the Startup folder on the old computer to the new computer.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Suzanne S. Barnhill" wrote in message
...
Make sure you are saving the file to the folder specified for "User
templates" on the File Locations tab of Tools | Options.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the

newsgroup
so
all may benefit.

"Kathryn" wrote in message
...
I have a computer running Word 2000. I have a new computer running

Word
2003. I have a couple of Word macros that I need to move to the new
computer. I have already looked through old messages and have looked

at
http://addbalance.com/word/movetotemplate.htm and
http://word.mvps.org/FAQs/General/FilesToBackup.htm and
http://word.mvps.org/FAQs/Customizat...latesStore.htm but

still
cannot figure out how to move the macros to my new computer. When I

open
Word 2000, my computer does not behave the way that it should according
to
the addbalance site. Using the Organizer button doesn't show my

macros;
using the VBA Editor doesnt' show any macros either, yet they are there

and
run when I use them.

I have tried to simply copy the .dot file over to the new computer but

I
put
it in the subdirectory that Word looks in for templates but it does not

see
it there.

Any help?





  #6  
Old May 5th, 2005, 08:28 PM
Kathryn
external usenet poster
 
Posts: n/a
Default



"Charles Kenyon" wrote:

Hi Kathryn,

I wrote the article on the Add Balance site. I may have made assumptions
that you are not making. Sorry. The steps in it work when followed exactly.

You do not want your old template in the user templates folder or the
workgroup templates folder, you want them in the Word startup folder. I
suspect that you have done this. For more on the different kinds of
templates, tabs on the file new dialog, and locations of templates folders
see http://addbalance.com/usersguide/templates.htm.


What *exactly* is the word startup folder? I have recorded a test macro
(named Test) on my new computer to see if I could locate exactly where the
macro should be stored but still can't find it. Microsoft can't find a file
with Test in the name.


The macros will not show up in the organizer because you do not have your
template _open_ in the organizer. They will not show up in the vba editor
because you do not have your template open. They run because you have your
template added as an Add-In. To get them available for editing, you need to
actually open the template so that it is visible on your screen.


If by open, you mean run the macro, I have done that. I run the macro and
then open the organizer, which is what the directions appear to want me to
do. What I get is box that will shows NewMacros in Normal.dot and NOTHING in
the other box. The only thing that it will allow me to do from there is copy
NewMacros(in Normal.dot) into the template I want to copy! I see nothing
that will allow me to copy FROM my macro/template.

Doing this
will also make the macro modules available in the organizer. Note that
individual macros do not show up in the organizer, only modules.
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.



"Kathryn" wrote in message
...
I have a computer running Word 2000. I have a new computer running Word
2003. I have a couple of Word macros that I need to move to the new
computer. I have already looked through old messages and have looked at
http://addbalance.com/word/movetotemplate.htm and
http://word.mvps.org/FAQs/General/FilesToBackup.htm and
http://word.mvps.org/FAQs/Customizat...latesStore.htm but still
cannot figure out how to move the macros to my new computer. When I open
Word 2000, my computer does not behave the way that it should according to
the addbalance site. Using the Organizer button doesn't show my macros;
using the VBA Editor doesnt' show any macros either, yet they are there
and
run when I use them.

I have tried to simply copy the .dot file over to the new computer but I
put
it in the subdirectory that Word looks in for templates but it does not
see
it there.

Any help?




  #7  
Old May 5th, 2005, 08:36 PM
Kathryn
external usenet poster
 
Posts: n/a
Default

When I made these macros, I followed directions from a Word user's group. I
stored them wherever it is that Word defaulted to. Is there not a simple way
to find a file and copy it to disk and then put it where it needs to be on
the new computer? I've been able to do that with all other files.

"Charles Kenyon" wrote:

Hi Suzanne,

My diagnosis, which may be off, is that the macros are currently stored in
an Add-In. That is the only way I know to have operational macros that don't
show up in the vb editor or the organizer. So the template needs to be moved
from the Startup folder on the old computer to the new computer.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Suzanne S. Barnhill" wrote in message
...
Make sure you are saving the file to the folder specified for "User
templates" on the File Locations tab of Tools | Options.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup
so
all may benefit.

"Kathryn" wrote in message
...
I have a computer running Word 2000. I have a new computer running Word
2003. I have a couple of Word macros that I need to move to the new
computer. I have already looked through old messages and have looked at
http://addbalance.com/word/movetotemplate.htm and
http://word.mvps.org/FAQs/General/FilesToBackup.htm and
http://word.mvps.org/FAQs/Customizat...latesStore.htm but still
cannot figure out how to move the macros to my new computer. When I open
Word 2000, my computer does not behave the way that it should according
to
the addbalance site. Using the Organizer button doesn't show my macros;
using the VBA Editor doesnt' show any macros either, yet they are there

and
run when I use them.

I have tried to simply copy the .dot file over to the new computer but I

put
it in the subdirectory that Word looks in for templates but it does not

see
it there.

Any help?





  #8  
Old May 5th, 2005, 08:44 PM
Kathryn
external usenet poster
 
Posts: n/a
Default

Please explain to me how to find the user template folder. Word doesn't seem
to want to tell me. I have gone into tools/options/file locations/user
templates and when I put the template into that folder word doesn't see it.
Also, when I made a test macro it shows up when I try to run it but it is not
in the folder I see when I check the tools/options/file locations/user
templates.

"Suzanne S. Barnhill" wrote:

Ah, okay, I got in on this late. In either case, I suspect that Kathryn is
putting them in the folder reserved for Word's own installed templates
rather than either the User Templates or the Startup folder.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Charles Kenyon" wrote in
message ...
Hi Suzanne,

My diagnosis, which may be off, is that the macros are currently stored in
an Add-In. That is the only way I know to have operational macros that

don't
show up in the vb editor or the organizer. So the template needs to be

moved
from the Startup folder on the old computer to the new computer.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Suzanne S. Barnhill" wrote in message
...
Make sure you are saving the file to the folder specified for "User
templates" on the File Locations tab of Tools | Options.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the

newsgroup
so
all may benefit.

"Kathryn" wrote in message
...
I have a computer running Word 2000. I have a new computer running

Word
2003. I have a couple of Word macros that I need to move to the new
computer. I have already looked through old messages and have looked

at
http://addbalance.com/word/movetotemplate.htm and
http://word.mvps.org/FAQs/General/FilesToBackup.htm and
http://word.mvps.org/FAQs/Customizat...latesStore.htm but

still
cannot figure out how to move the macros to my new computer. When I

open
Word 2000, my computer does not behave the way that it should according
to
the addbalance site. Using the Organizer button doesn't show my

macros;
using the VBA Editor doesnt' show any macros either, yet they are there
and
run when I use them.

I have tried to simply copy the .dot file over to the new computer but

I
put
it in the subdirectory that Word looks in for templates but it does not
see
it there.

Any help?





  #9  
Old May 5th, 2005, 10:01 PM
Charles Kenyon
external usenet poster
 
Posts: n/a
Default


For more on the different kinds of templates, tabs on the file new dialog,
and locations of templates folders see
http://addbalance.com/usersguide/templates.htm.
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Kathryn" wrote in message
...
Please explain to me how to find the user template folder. Word doesn't
seem
to want to tell me. I have gone into tools/options/file locations/user
templates and when I put the template into that folder word doesn't see
it.
Also, when I made a test macro it shows up when I try to run it but it is
not
in the folder I see when I check the tools/options/file locations/user
templates.

"Suzanne S. Barnhill" wrote:

Ah, okay, I got in on this late. In either case, I suspect that Kathryn
is
putting them in the folder reserved for Word's own installed templates
rather than either the User Templates or the Startup folder.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup
so
all may benefit.

"Charles Kenyon" wrote in
message ...
Hi Suzanne,

My diagnosis, which may be off, is that the macros are currently stored
in
an Add-In. That is the only way I know to have operational macros that

don't
show up in the vb editor or the organizer. So the template needs to be

moved
from the Startup folder on the old computer to the new computer.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Suzanne S. Barnhill" wrote in message
...
Make sure you are saving the file to the folder specified for "User
templates" on the File Locations tab of Tools | Options.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the

newsgroup
so
all may benefit.

"Kathryn" wrote in message
...
I have a computer running Word 2000. I have a new computer running

Word
2003. I have a couple of Word macros that I need to move to the new
computer. I have already looked through old messages and have
looked

at
http://addbalance.com/word/movetotemplate.htm and
http://word.mvps.org/FAQs/General/FilesToBackup.htm and
http://word.mvps.org/FAQs/Customizat...latesStore.htm but

still
cannot figure out how to move the macros to my new computer. When I

open
Word 2000, my computer does not behave the way that it should
according
to
the addbalance site. Using the Organizer button doesn't show my

macros;
using the VBA Editor doesnt' show any macros either, yet they are
there
and
run when I use them.

I have tried to simply copy the .dot file over to the new computer
but

I
put
it in the subdirectory that Word looks in for templates but it does
not
see
it there.

Any help?







  #10  
Old May 5th, 2005, 10:05 PM
Charles Kenyon
external usenet poster
 
Posts: n/a
Default

By open, I mean having the template in front of you on the screen in Word so
that you could type in it.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"Kathryn" wrote in message
news


"Charles Kenyon" wrote:

Hi Kathryn,

I wrote the article on the Add Balance site. I may have made assumptions
that you are not making. Sorry. The steps in it work when followed
exactly.

You do not want your old template in the user templates folder or the
workgroup templates folder, you want them in the Word startup folder. I
suspect that you have done this. For more on the different kinds of
templates, tabs on the file new dialog, and locations of templates
folders
see http://addbalance.com/usersguide/templates.htm.


What *exactly* is the word startup folder? I have recorded a test macro
(named Test) on my new computer to see if I could locate exactly where the
macro should be stored but still can't find it. Microsoft can't find a
file
with Test in the name.


The macros will not show up in the organizer because you do not have your
template _open_ in the organizer. They will not show up in the vba editor
because you do not have your template open. They run because you have
your
template added as an Add-In. To get them available for editing, you need
to
actually open the template so that it is visible on your screen.


If by open, you mean run the macro, I have done that. I run the macro and
then open the organizer, which is what the directions appear to want me to
do. What I get is box that will shows NewMacros in Normal.dot and NOTHING
in
the other box. The only thing that it will allow me to do from there is
copy
NewMacros(in Normal.dot) into the template I want to copy! I see nothing
that will allow me to copy FROM my macro/template.

Doing this
will also make the macro modules available in the organizer. Note that
individual macros do not show up in the organizer, only modules.
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.



"Kathryn" wrote in message
...
I have a computer running Word 2000. I have a new computer running Word
2003. I have a couple of Word macros that I need to move to the new
computer. I have already looked through old messages and have looked
at
http://addbalance.com/word/movetotemplate.htm and
http://word.mvps.org/FAQs/General/FilesToBackup.htm and
http://word.mvps.org/FAQs/Customizat...latesStore.htm but
still
cannot figure out how to move the macros to my new computer. When I
open
Word 2000, my computer does not behave the way that it should according
to
the addbalance site. Using the Organizer button doesn't show my
macros;
using the VBA Editor doesnt' show any macros either, yet they are there
and
run when I use them.

I have tried to simply copy the .dot file over to the new computer but
I
put
it in the subdirectory that Word looks in for templates but it does not
see
it there.

Any help?






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro and sub rountines The Good Deeds Team General Discussion 1 March 23rd, 2005 11:26 PM
Keyboard Shortcut Only Runs Part of the Macro Jonnyboy117 General Discussion 2 July 14th, 2004 08:27 PM
Need Entry Point 18 Help On Access Executable File Jeff Conrad General Discussion 26 July 14th, 2004 06:00 AM
Macro when a font in a range changes whisperinghill General Discussion 0 June 14th, 2004 07:21 PM
Cannot delete macro LookupMW Min New Users 7 June 10th, 2004 03:27 AM


All times are GMT +1. The time now is 12:12 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.