Office DevelopmentThe Microsoft Office System is the world's standard in desktop productivity software and, with Visual Basic and Visual Studio Tools for Office, you can create solutions that leverage this broad platform. Find the information you need here to help you develop applications for Office. For complete information on developing for the Microsoft Office System, see the Microsoft Office Developer Center. Videos | Articles | Blogs
How Do I: Add Columns to a Data-Bound List Object at RunTime?Discover how to add a data-bound list object in Excel, copy and paste data into another list object, add columns to the new list object, and insert formulas into the new column to create a Calculated Column. Length: 12 minutes 23 seconds
Tuesday, May 13, 2008 3:00:00 PM
Video How to: Add or Remove Inclusion List Entries (2007 System) When a user starts a Microsoft Office solution that has not been granted trust for that user, the solution prompts him or her for a security decision with a ClickOnce trust prompt. If the user decides to trust the solution, it is added to the inclusion list, and the user is no longer prompted when customization runs. If you want to add your solution to the inclusion list without prompting the user, you can add the solution to the inclusion list programmatically.Monday, May 05, 2008 10:45:00 AM
Video How to: Calling Code in an Application-Level Add-in from VBA You can expose an object in an application-level add-in to other Microsoft Office solutions, including Visual Basic for Applications (VBA) solutions and COM add-ins. This video shows you how to write a method in an add-in for Microsoft Office Excel 2007 that you can call from VBA code in the workbook.
Monday, May 05, 2008 11:00:00 AM
Video How to: Creating a Custom Tab by Using the Ribbon Designer You can add new tabs to the Ribbon in Microsoft Office applications, and customize the built-in tabs. This gives you control over what features are presented on the Ribbon, and enables you to add your own custom features to the Office application UI. This video shows you how to create a custom Ribbon tab by using the Ribbon Designer and add controls that show and hide the actions pane.
Monday, May 05, 2008 10:05:00 AM
How Do I: Debug a VSTO Application?Debugging a VSTO application in Visual Studio provides a different debugging experience versus the debugging experience in VBA. Steve Hansen demonstrates the debugging tools in Visual Studio 2008 and how they differ versus those offered in VBA. Duration: 19 minutes 41 secondsTuesday, March 25, 2008 1:20:00 PM
How Do I: Call VSTO Code from VBA?Discover the VBA/VSTO interoperability feature, one of the new features in Visual Studio Tools for Office 3.0 (VSTO). Steve Hansen shows you how to call VSTO code from Visual Basic for Applications (VBA), and then use this feature to gradually port a VBA application to VSTO. Duration: 18 minutes, 29 seconds
Tuesday, January 29, 2008 2:25:00 PM
How Do I: Add a Custom Menu Item to Outlook 2007?Join Steve Hansen as he shows you how to add a custom menu item to the main Outlook 2007 command bar in an Internet Explorer window. Duration: 15 minutes, 38 secondsTuesday, January 15, 2008 3:10:00 PM
How Do I: Transfer Data Into an Excel Worksheet?In this video, Steve Hansen from VSTOTips.com demonstrates how to write data out to an Excel worksheet in an efficient manner. Writing data to a worksheet is a common task when programming on top of Excel and depending on the amount of data you need to write, you can dramatically improve the performance of your code by putting the data into an array and then assigning the array to a range. Duration: 11 minutes, 55 secondsTuesday, December 18, 2007 2:45:00 PM
How Do I: Deploy an Office Solution Using ClickOnce in Visual Studio 2008?In this video, Steve Hansen presents an overview of publishing and deploying a Visual Studio 2008 Excel workbook solution using ClickOnce. Visual Studio Tools for Office 3.0, part of Visual Studio 2008, uses a significantly improved process for deploying solutions to client computers compared to previous versions. Duration: 9 minutes, 28 secondsTuesday, December 04, 2007 2:30:00 PM
How Do I: Create an Add-in for Microsoft PowerPoint?Steve Hansen demonstrates how to build an add-in for PowerPoint that allows you to apply a consistent template and remove speaker notes from a batch of PowerPoint presentations. Duration: 18 minutes, 54 secondsTuesday, November 20, 2007 3:20:00 PM
How Do I: Use WPF Controls Inside an Excel Actions Pane?In this video, Steve Hansen demonstrates how to use a Windows Presentatoin Foundation (WPF) flow document as a means for displaying context-sensitive Help. Duration: 11 minutes, 0 seconds
Tuesday, November 06, 2007 12:00:00 AM
How Do I: Interact with Web Services from Microsoft Excel?In this video, learn the basics of consuming Web services from within an Excel workbook and discover a technique to make Web services data resemble an Excel query table. Duration: 25 minutes, 29 seconds
Tuesday, October 30, 2007 2:50:00 PM
Creating a Text-to-speech add-in for Microsoft Word 2007 with Visual Studio 2008
Visual Studio 2008 includes tools for Office that allow developers to build custom components, such as add-ins, for Microsoft Office System applications writing managed code. See how you can create a custom task pane for Microsoft Word 2007 and how to integrate Text-to-Speech capabilities provided by .NET Framework.Wednesday, June 11, 2008 12:00:00 AM
Extend Your VBA Code With VSTOVSTO brings you the full feature set of Visual Studio including LINQ, WPF, WCF, and the .NET Framework 3.5. Wednesday, August 01, 2007 10:35:00 AM
Databinding best practices for ExcelAs a best practice you can create one dataset in ThisWorkbook designer and then programmatically reference it from your code in other sheets. Here’s how.
Monday, April 28, 2008 3:30:00 PM
Deploying an Office solution using Windows InstallerVisual Studio 2008 offers a ClickOnce deployment experience for solutions developed for the 2007 Microsoft Office system. However, if you want to deploy additional files, add extra registry keys, or use SMS, you may still be interested in creating a Windows Installer package. Thursday, April 10, 2008 3:30:00 PM
Visual Studio Command Bar for Arranging Controls on Documents and Worksheets One of the lesser-known features of Visual Studio Tools for Office is the Microsoft Office Word and Microsoft Office Excel command bar. When you are developing a document-level project for Word or Excel (for example, a Word Document or Excel Workbook project) and you have the document or one of your worksheets open in the designer, this command bar appears in Visual Studio, just above the designer. Thursday, April 10, 2008 2:05:00 PM
Developing an add-in for multiple versions of OfficeTheoretically, you can develop an add-in for multiple versions of Microsoft Office by catering to the lowest common denominator. This means if you use an Excel 2003 add-in template in Visual Studio 2008, you would be able to develop and debug this with Excel 2007. Thursday, March 20, 2008 3:35:00 PM
Word Object Model: Getting Information from Word DialogsAlthough VSTO provides many features that help simplify Office development (especially UI development), nearly every VSTO solution needs to dip into the underlying Office object model to get some work done. Because information about using the Office object models can be spread out in many different places, I thought it might help some readers who are just getting started with Office development using VSTO to talk about a Word object model question that came across my desk recently. Tuesday, February 19, 2008 4:00:00 PM
| |