Join Walt Ritscher for an in-depth discussion in this video Making an Excel 2010 add-in, part of Visual Studio 2010 Essential Training.
Excel has found a permanent niche in most corporate environments.…Its usage is not limited to accounting tasks either.…In this movie, I'm going to show you how to extend it even further by…creating your own add-in.…Remember that an add-in is an application that is installed once and then loaded…each time Excel runs.…It's not tied to a specific document.…For this demonstration, I'm going to create a custom ribbon inside Excel 2010.…I'm inside a project called ProcessAnalyzer.…I've already written the demonstration code for today.…I'm going to start by showing you how to add your own custom ribbon to an Excel project.…
You right-click on the project, and choose Add > New Item.…Here is the ribbon designer that I want to use.…Now, I already have a ribbon, so I'm not going to go ahead and click on the Add button.…Instead, I'm going to cancel this one and show you the existing…ProcessMemoryRibbon I've written.…As you can see, it has a designer surface.…There's also a special section on the Toolbox that contains Office Ribbon Controls.…
- Creating a Visual Studio project
- Building the user interface
- Binding to an RSS feed
- Coding with IntelliSense
- Creating rich Internet applications with Silverlight
- Building Windows applications with Windows Forms
- Integrating with SQL Server
- Working with Microsoft Office applications
- Understanding extensibility in Visual Studio
- Working with data, ADO.NET and datasets
- Using source control
Skill Level Intermediate
Q: Which edition of Visual Studio 2010 do I need to follow along in this course?
A: The course is taught with Visual Studio 2010 Professional, but can also be used with the Premium or Ultimate editions. The Express editions of Visual Studio, including Visual Basic 2010 Express, Visual C# 2010 Express, and Visual C++ Express, are not covered in this course.
Q: I'm attempting to download the exercise files for this course, and my virus protection is blocking me from unzipping the downloaded file. Are the files corrupted?
A: The alert is a false-positive message. Your antivirus software is detecting the active code included in the exercise files, which in some ways resembles viral code. There is nothing to be alarmed about and you can ignore the warning. This is common among coding courses and environments.
1. Getting Started
2. Exploring the Visual Studio Workspace (IDE)
3. Building a Simple Application
4. Exploring the Code Editors
5. Working with Code
6. Understanding the Project Types
7. Digging Into Your Data
8. Debugging Your Application
9. Testing Your Application
10. Deploying Your Application
11. Working with Source Control
12. Integrating with Microsoft Office Applications
Making an Excel 2010 add-in5m 21s
13. Extending Visual Studio
14. Configuring Your Application
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.