What are the ways to share VBA code?

[bhinangt]

One I can think of is .exe. But is it possible to make exe?

Other could be add-in, again how to distribute is a question.

WHAT ARE THE OTHER WAYS OF DISTRIBUTION AND SOLUTION IF ANY?

 

[igold]

Hi,

You can export the modules. Right click on the Module name in the "VBAProject" and choose "Export File...". You will be prompted to choose a "Save" location. The module will be saved with the file extension of .bas, so Module1 wil be saved as Module1.bas

The problem with this though is that if your distribution method is going to be email then you must change the extension from bas to something else (I use bak), because most Email clients will prevent you from sending or receiving a file with a bas extension. The email recipient can then save the file on their on machine as a bas or as is and then rename it and change the extension back to bas.

You can take that bas file and drag and drop it into the VBE/VBAProject of any workbook.

I hope this helps.