 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / August 2005save macros in other projects other than normal
Can macros be saved with names other than "normal"? If yes, is there any way to make macros available to many different files (grouped in some way)? > Can macros be saved with names other than "normal"? Of course! Just save the file as a template (*.DOT) file > If yes, is there any way to make macros available to many different > files (grouped in some way)? Either attach your template to the document in place of the "Normal" template, or install your template as a global add-in Eddie Edward, Thanks. But, the problem is that I can't figure out how to do that. My macros start in Normal/New Macros. Now what? How do I get part of that file into a new file connected to only my current document or if possible, to a series of documents? I would like to send my documents to others with the macros available. I would prefer not to have to embed the macros in each of the files. Nor to I want to send it as "Normal" since that would overwrite the other person's Normal macros. > > Can macros be saved with names other than "normal"? > [quoted text clipped - 7 lines] > > Eddie See the article "Distributing macros to other users" http://www.word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm  SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > Edward, > [quoted text clipped - 21 lines] >> >> Eddie Thanks. I have been poking around in this topic and have found some other good links. I will follow up on them and get back here if I am still left with questions. You guys are really helpful. > See the article "Distributing macros to other users" > http://www.word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm [quoted text clipped - 24 lines] > >> > >> Eddie Hi Esther, There are at least two ways to move your macros from template to template. 1. Create a new blank template. (In Word 2000 and earlier, you could just click the Template option button in the File > New dialog. In Word 2002/2003, it's easiest to make a new blank document and use the "Save as type" dropdown in the File > Save As dialog to save it as a template.) Start the VBA editor. Select the code from the NewMacros module in the Normal project, and copy it to the clipboard. Click the project of the new template, click Insert > Module, and paste the code into the code window. Save the new template. 2. Create a new blank template. Start the Organizer (Tools > Templates & Add-Ins > Organizer). Click the Macro Project Items tab. Copy the NewMacros project from Normal.dot to the new template. Close the dialog and save the template. If necessary, go into the VBA editor and delete macros that aren't needed there. One other technique is to record your macros directly into the template where you want them. If the document that's active when you start the recorder is based on some template other than Normal.dot, the initial dialog offers that template in the "Save macro in" dropdown. When the template contains the correct macros, see http://word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm for what to do with it. You may also get some useful hints from http://word.mvps.org/FAQs/MacrosVBA/ModifyRecordedMacro.htm. SignatureRegards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org > Edward, > [quoted text clipped - 19 lines] >> >> Eddie See http://addbalance.com/word/movetotemplate.htm for step-by-step instructions on moving / sharing / copying / backing-up customizations including AutoText, AutoCorrect, keyboard assignments, toolbars, macros, etc. You can choose to record macros in templates other than normal.dot including a particular document template or the document itself. You can then move them using the visual basic editor to other open projects. SignatureCharles 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. > Can macros be saved with names other than "normal"? > If yes, is there any way to make macros available to many different files > (grouped in some way)? Thanks for the response and the info. I got to your article Template Basics in Microsoft Word in that website by following leads of previous responders. I will definitely look at it. > See http://addbalance.com/word/movetotemplate.htm for step-by-step > instructions on moving / sharing / copying / backing-up customizations [quoted text clipped - 5 lines] > > If yes, is there any way to make macros available to many different files > > (grouped in some way)?
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.