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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
"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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |