R – How to deliver an Excel 2007 VBA script

excel-2007scriptingvba

Once I've finished writing an Excel 2007 VBA script how to I deliver the Excel 2007 VBA script to the rest of the team members?

Is there a way to package an Excel 2007 VBA script so that it can be provided to other team members?

Thanks again for any feedback.

Best Solution

You could deliver as an Excel add-in (no need for VSTO if you want, can be pure VBA). or you could export the module to a .bas file and send to your coworker.