how to send macro to another user

[nilesh pardeshi]

Hi friends,


i made one macro in excell 2003,but i need to send this macro to another user ,,
could u please help me out?

 

[RichardMGreen]

You could right-click on it in the VBA window and export the module. You should be able to email that (depending on your email client) for them to save somewhere and import.

 

[VoG]

You could create an add-in

http://www.rondebruin.nl/personal.htm

http://www.fontstuff.com/vba/vbatut03.htm

 

[nilesh pardeshi]

Hello,

Could please tell me in detail how to send text code through Mail..

Nil

 

[RichardMGreen]

If you go into the VBA editor (Alt-F11) and the choose then right-click on the module you want to send, it will give you various option.
If you then choose "Export" and select a save location it will export a small file.
This can then be attached to an email for someone to import at the other end.