I found a more detailed answer.
Some Microsoft Office Development Tools Information for Visual Studio
Microsoft has released Office Developer tools for Visual Studio. tools are available in preview form and offer an alternative to Napa, the creator of Microsofts online applications on the Internet.
Extensions for Visual Studio can be used to write applications for Office, SharePoint, and Office 365. Earlier versions of Office used Visual Basic for Applications as a programming language. New extensions allow you to write applications for Office and SharePoint using web technologies such as HTML5, CSS, JavaScript, REST, OData and OAuth.
Developed applications can be sold in the office store or used inside your own company. The new release also allows you to write applications that use SharePoint without SharePoint on the local machine.
An application for Office is basically a web page hosted within Office, and the applications that you can write for Office and SharePoint consist of three categories
those that appear in the task pane of an Office application; those that appear inside the contents of an Office document, such as a worksheet; and mail applications for Outlook and Outlook Web Access. They appear next to an open Outlook item, such as an email message, a meeting request, a meeting response, a cancellation or appointment. The main components of the Office application are an XML manifest file and a web page. In the manifest there are various settings and points on the web page that implements the application user interface and user logic.
According to a review of new tools, an Office application can do almost anything a web page can do in a browser, for example providing an interactive user interface and user logic using JavaScript or using JavaScript frameworks such as jQuery.
The second development method for Office 13 and 365 is to use the Microsoft Napa Online Development Tool, which Microsoft describes as a lightweight companion for Visual Studio. Napa is a free browser-based application for SharePoint that you can use to write applications.
While lightweight applications can satisfy some needs, itβs worth noting that Visual Basic for Applications and VSTO work in Office 2013, the only drawback is that you cannot use them to create applications that can be sold in the office store .
For many existing Office developers, the push away from the rich client offered in Visual Basic for Applications is a drawback. the benefits of selling them in the store are available if you have an Office 365 Developer subscription that includes a SharePoint Online developer site set up to build and test applications, as well as a Microsoft Dashboard account for your in-store applications.
Some information regarding VSTO: -
VSTO, or Visual Studio Tools for Office, or Microsoft Visual Studio Tools are part of the Microsoft Visual Studio.NET toolkit and support the Microsoft.NET Framework. It is used by developers to write code connecting Microsoft Office Word, Excel, and Outlook Applications. Developers using VSTO can use C # or Visual Basic languages. It is an alternative to Visual Basic for Applications or VBA
You can use the Microsoft Office developer tools in Visual Studio to create .NET Framework applications that extend Office. These applications are also called Office solutions.
Office Developer Tools provides features to help you create Office solutions to meet your various business needs. The tools include project templates to help you create Office solutions using Visual Basic or Visual C # and visual designers to help you create user interfaces for your Office solutions.