Publishing a VBA add-in

[dbryant99]

I apologize for not knowing the right words to use here (and if i knew the words i could look up the answer )

I have written a piece of VBA code that does what i need it to and have installed it in the spreadsheet that i was testing it on. So far so good.

I now want to give the code to other people so that they can use the functionality - it is a routine that takes a specific Excel formatted file and creates an srt file (a video caption file)

So i would like to know how to create a module that i can send to people so that they can add it to their generic Excel application so that they can use the functionality with an easy way to run it.

I hope this makes sense to you.

Thanks in Advance

Dave

 

[RoryA]

Put the module in a new blank workbook and save that as an add-in. You can then distribute that to users, though you will need to provide some means of running the code, such as a custom ribbon tab/button.