From the course: Microsoft Office Add-Ins for Developers
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Repurposing
- [Instructor] Our starting point is the default template for an Excel task pane add-in in Visual Studio. The Script Lab tool has a very rich set of samples for Excel. Rather than going to the documentation, a great way of getting sample code is just to open up Script Lab and see if there is some code that does something close to what we want. I'm gonna start another Excel instance and open a blank workbook and bring up Script Lab. Click on code. So I've gone to the Script Lab tab on the ribbon and clicked on code and let's just make this a little bit larger. And if look at samples, I get a very long rich list of samples to pick from. Now let's pick one that gives, for example, 3D charts. So I'm gonna choose the create additional chart types sample and have a look at the code inside there. And let's just see what that does when we run it. So I get a series of buttons. I get one to setup some data. That looks very useful. And then if I see down here the different types of chart I can…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.