Microsoft Exam MS-600 Topic 13 Question 21 Discussion

D: Run the following command to create an add-in project using the Yeoman generator:

yo office

Visual Studio Code is a great tool to help you develop your custom Office Add-ins regardless if they are for Outlook, Word, Excel, PowerPoint and run in the web clients, Windows clients, iOS clients or on macOS.

Open the project in Visual Studio Code by entering the following on the command line from within the same folder where you ran the generator:

code.

E: You can create VSTO Add-ins for Excel.

To create a new Excel VSTO Add-in project in Visual Studio

*Start Visual Studio.

*On the File menu, point to New, and then click Project.

*In the templates pane, expand Visual C# or Visual Basic, and then expand Office/SharePoint.

*Under the expanded Office/SharePoint node, select the Office Add-ins node.

*In the list of project templates, select Excel 2010 Add-in or Excel 2013 Add-in.

*In the Name box, type FirstExcelAddIn.

*Click OK.

Visual Studio creates the FirstExcelAddIn project and opens the ThisAddIn code file in the editor.

References: https://docs.microsoft.com/en-us/office/dev/add-ins/tutorials/excel-tutorial

https://code.visualstudio.com/docs/other/office#_use-visual-studio-code-to-develop-your-office-addin

https://docs.microsoft.com/en-us/visualstudio/vsto/walkthrough-creating-your-first-vsto-add-in-for-excel