[mso] Re: macros
- From: "Greg Chapman" <greg@xxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Sun, 21 Sep 2003 23:19:27 -0500
Why yes, there are more ways than one to do that. The methods I'll
describe are for Word. I'm sure you can do something similar for Excel and
other Offices apps. First, I should let you know that my answer is also
aimed at settling an argument silently, without revealing the details to
anyone.<g>
Macros in the Office world are almost always VBA code (very, very few
exceptions) and are almost always recorded by the Macro Recorder. In Word,
any macro you create using the recorder will be saved in the New Macros
VBA module of your normal.dot file, the default Word template. I mention
this so that, at any point in the future, you can explore the idea of
actually developing your macro code to suit your work rather than having
to record them for single tasks. So, here's how you can always have those
macros available:
- Rename your normal.dot template and copy it to Word's startup directory
- Open the VBEditor in Word (press Alt & F11) and copy/paste the recorded
macros from normal.dot to a new Module in a new or different template. Use
Word's Add-Ins dialog to add this template to its startup.
- Open the VBEditor and Export the New Macros module to a .BAS file. In
another template, import that .BAS file. Whenever you want to create a new
document but have those macros available, base your new document on this
new template.
By no means are these the only ways. I'd give a SWAG that these are
roughly half the possible methods of accomplishing what you ask with Word.
Greg Chapman
http://www.mousetrax.com
"Counting in binary is as easy as 01, 10, 11!
With thinking this clear, is coding really a good idea?"
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx
> [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf Of Pam
> Sent: Monday, September 22, 2003 12:04 AM
> To: MicrosoftOffice
> Subject: [mso] macros
>
>
> Is there a way to store macros that might be used in lots of
> applications in
> a central place so that they are available to you in any
> document you are
> in?
> Pam
>
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
