Which technology―VBA macros, managed add-ins built with Visual Studio, or apps for Office―is the best choice for your solution? It's important to note that all three technologies will be supported in the foreseeable future. This means that if you have an existing VBA project that you are satisfied with, you can be confident your investment is safe. However, if you're looking for a new way for users to interact with Office customizations, apps for Office is a great place to start.
VBA developer resources
Meet apps for Office
Deploy, update, and maintain your apps faster in the cloud. Publish and distribute IT approved apps within your organization using an internal app catalog, or sell your apps in the Office Store.
Connect to the largest install base of users for any productivity services so your app will be exposed to the largest potential audience possible.