Sending your macros independent of the document Office XP, 2003, 2007

Finally! The new macro is working as intended. Now, you want to email the macro to someone you know. However, the macro is embedded in the document, which you do not wish to send. Macros can be exported and imported independent of the document.

• For that, start the command ‘Tools | Macro | Macros’.
• Select the desired macro in the list and then click on ‘Create’.
• In the Visual Basic-Editor, now open ‘File | Export file’ in the menu.
• For sending through email, it is practical, to change the ‘File type’ to ‘All Files’ first and then entering a name in the field ‘File name’ such as ‘My-Macro.txt’.
• If required, change the destination folder and then click on ‘Save’.
• This text file can now be sent to anyone via email.
• With this you can avoid difficulties.
• Because when you send the Office-document with the macro, the email program many a times blocks the delivery to the addressee, since it constitutes a potential risk.
• Even though you can copy and paste the macro text while emailing, it is not recommended, especially for macros that are long.
• Unexpected line breaks can pave the way for errors, which are later difficult to find.
• To integrate the macro, the recipient must open a document and select ‘Tools | Macro | Visual Basic-Editor’.
• He can then import the macro by clicking on ‘File | Import file’.