Reusing Scripts

You can develop scripts directly in the main VBA project; however, this approach makes reusing the scripts more difficult. Instead, you should store subroutines in a separate module and then call these subroutines from the main project when you want to reuse the scripts. This allows you to export and then import the scripts into a new project with minimal modification, and also provides a more modular, component-based design.