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.…
Author
Walt Ritscher
Released
11/16/2010- 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
Duration
Views
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.
-
Introduction
-
Welcome58s
-
Using the exercise files1m 1s
-
-
1. Getting Started
-
2. Exploring the Visual Studio Workspace (IDE)
-
Working with big projects3m 53s
-
Setting options for the IDE5m 56s
-
3. Building a Simple Application
-
Connecting your data8m 4s
-
Binding to an RSS feed5m 4s
-
4. Exploring the Code Editors
-
Writing a C# program6m 48s
-
Writing a VB program6m 29s
-
Working with C++6m 38s
-
Working with F Sharp6m 9s
-
Font and color options6m 50s
-
5. Working with Code
-
Formatting your code6m 43s
-
Navigating your code7m 44s
-
Using the Task List2m 26s
-
Commenting your code2m 45s
-
Documenting your code8m 26s
-
Working with code snippets6m 25s
-
Refactoring your code5m 15s
-
Generating code with T46m 29s
-
-
6. Understanding the Project Types
-
Creating a class library6m 26s
-
Creating a WCF service9m 1s
-
7. Digging Into Your Data
-
Creating typed datasets7m 55s
-
Using the data binding tools8m 38s
-
8. Debugging Your Application
-
Debugging code9m 32s
-
Other debugging techniques6m 50s
-
-
9. Testing Your Application
-
10. Deploying Your Application
-
Building your application4m 19s
-
Setting assembly information2m 12s
-
-
11. Working with Source Control
-
12. Integrating with Microsoft Office Applications
-
Making an Excel 2010 add-in5m 21s
-
13. Extending Visual Studio
-
Creating macros7m 16s
-
Creating an MEF add-in7m 9s
-
14. Configuring Your Application
-
Using the Settings Editor7m 29s
-
Using the Resources Editor6m 59s
-
Localizing your resources5m 28s
-
Conclusion
-
Goodbye1m 17s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press 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.
Share this video
Embed this video
Video: Making an Excel 2010 add-in