What is the difference between Microsoft Developer Developer Tools and Visual Studio Tools for Office

What is the difference between Microsoft Office Developer Tools and Visual Studio for Office aka VSTO ?

When I set the opportunity below, which of these two technologies do I use?

enter image description here

TIA.

+7
c # visual-studio-2010 ms-office vsto
source share
3 answers

Visual Studio Tools for Office (or VSTO) is the Microsoft environment for managed add-ins in office applications, starting with Office 2003 with later versions that only support Office 2007 +.

Office Applications is the Microsoft environment for HTML5 applications in office applications since Office 2013.

Office development tools are tools (usually in the form of Visual Studio project templates) for developing VSTO applications and applications for Office.

Therefore, when you create the Excel Workbook 2007 project, as in the screenshot, you use the VSTO project template installed as part of the Office developer tools.

+4
source share

I found a more detailed answer.

What are the similarities and differences between Microsoft Office Developer Tools for Visual Studio and Visual Studio Tools for Office?

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.

+2
source share

Visual Studio Tools for Office (aka VSTO ) is half of MS Office.

Microsoft Office Development Tools - Half of Visual Studio.

-4
source share

All Articles