Excel

Office Development with Visual Studio Tutorial Series – Part 3 (Beth Massi)

A couple months ago Robert Green , VSTO MVP, started a series of tutorials on building on Office 2007. Yesterday we published part 3 of his step-by-step tutorials.

More:
Office Development with Visual Studio Tutorial Series – Part 3 (Beth Massi)

Excel

Northwind Office Business Application Updated for Visual Studio, Office & SharePoint 2010

Last year we built a business application for order management for Northwind Traders on the Office and SharePoint platform using Visual Studio 2008 and Office & SharePoint 2007. Recently I started releasing articles that show how to upgrade the VS2008 version to VS2010: Migrating an Outlook Client to .NET Framework 4 in Visual Studio 2010 Build WPF Data Controls for Outlook Addins Easily with VS2010 Migrating a 2007 Workflow to Visual Studio & SharePoint 2010 Today I updated the sample with some more goodies including some SharePoint 2010 web parts that I’ll write about soon

Go here to see the original: 
Northwind Office Business Application Updated for Visual Studio, Office & SharePoint 2010

Excel

Access 2010 deprecated features and components

This post provides an overview of features and components that will be deprecated in the upcoming release of Access 2010. A decision to remove a feature or component from the product is never a trivial one; we therefore have put a lot of thought when deciding to remove functionality.

Read more:
Access 2010 deprecated features and components

Excel

Excel VBA Cells and Hyperlinks

I track some information in Excel, and one of the columns is for a link to some location (blogs, Web sites, etc.). One of the things is that I don’t want the URL to appear as it creates display issues (as shown here). I really want it to look like this: I prefer to just display the word “Link” that is marked up with the actual link.

The rest is here:
Excel VBA Cells and Hyperlinks

Excel

Using Content Controls vs. Custom XML Elements

In my last post, What is “Custom XML” . .

Original post:
Using Content Controls vs. Custom XML Elements

Excel

Announcing the Release of the December 2009 CTP for the Open XML SDK

I’m really happy to announce the 4 th CTP for the Open XML SDK 2.0 for Microsoft Office ! There were four major improvements we made to the SDK: Full support for the Office 2010 Open XML formats Office 2010 schema and semantic level validation General improvements based on a recent Open XML SDK usability study Open XML SDK tools improvement Full Support for the Office 2010 Open XML Formats With the latest CTP you are able to create, edit, and consume Office generated Open XML formats for either Office 2007 or Office 2010.

Here is the original post:
Announcing the Release of the December 2009 CTP for the Open XML SDK

Excel

Preparing your Existing Solutions to Run on Outlook 2010

This post is about issues you might want to be aware of if you plan to update your existing Microsoft Outlook solutions to run on Outlook 2010. This information is also available in the Outlook 2010 Developer Reference which you can download at Office 2010: Developer References .

Go here to see the original:
Preparing your Existing Solutions to Run on Outlook 2010

Excel

Building an Office Business Application Part 2 – Generating Automobile Quotes

In this second part of a series of tutorials on Office Business Applications, learn how to create a Word 2007 price quote generation solution using Visual Studio 2008.

Read more here: 
Building an Office Business Application Part 2 – Generating Automobile Quotes

Excel

Helpful Content Links for Getting Started with Office Development

I’m often asked for helpful content links for content around VBA, Microsoft Office Backstage view, and Ribbon. Here’s a collection: VBA Video Title URL Visual Basic for Applications Overview http://msdn.microsoft.com/en-us/isv/bb190543.aspx Getting Started with VBA in Office 2010 http://go.microsoft.com/?linkid=9698470 Getting Started with VBA in Excel 2010 http://go.microsoft.com/?linkid=9698471 Getting Started with VBA in Outlook 2010 http://go.microsoft.com/?linkid=9698472 Getting Started with VBA in PowerPoint 2010 http://go.microsoft.com/?linkid=9698473 More Articles http://social.msdn.microsoft.com/Search/en-US/?Query=Office+Visual+Basic+for+Applications+development User Scenarios Title URL Office Business Application for Sales Proposal Document Management http://msdn.microsoft.com/en-us/library/cc185135.aspx Northwind Office Business Application http://code.msdn.microsoft.com/OBANorthwind FabriKam, a Microsoft Office System Solutions Learning Platform http://msdn.microsoft.com/en-us/library/aa20305829.aspx Creating an Organization Chart using a List of Employees http://msdn.microsoft.com/en-us/library/aa14020329.aspx More Articles http://msdn.microsoft.com/en-us/office/aa905352.aspx Basic Solution Ingredients Title URL Microsoft Office/Visual Basic Programmer’s Guide http://msdn.microsoft.com/en-us/library/aa14139329.aspx Advanced Microsoft Office Documents Inside Out: VBA Primer http://msdn.microsoft.com/en-us/library/dd721892.aspx Developing Office Applications Using VBA http://msdn.microsoft.com/en-us/library/aa14098029.aspx Taking the Office System Further with VBA and Open XML Formats http://msdn.microsoft.com/en-us/library/dd547378.aspx More Articles http://social.msdn.microsoft.com/Search/en-US/?Query=Office+Visual+Basic+for+Applications Enabling the Tools Title URL Microsoft Office Excel Programming Inside Out: Chapter 20: Creating Advanced User Forms http://msdn.microsoft.com/en-us/library/aa19253829.aspx Creating Word Templates Programmatically http://msdn.microsoft.com/en-us/library/bb266219.aspx XML and Microsoft Office Excel: Creating an Expense Report Template http://msdn.microsoft.com/en-us/library/aa20371729.aspx More Articles http://social.msdn.microsoft.com/Search/en-US?query=Office20Basic20Applications22user22%20controls&ac=8 Understand How to Make the Application Do Things through Code Title URL Developers Guide to the Excel Application Object http://msdn.microsoft.com/en-us/library/bb978780.aspx Developers Guide to the Excel 2007 Range Object http://msdn.microsoft.com/en-us/library/bb978779.aspx Super-Easy Guide to the Microsoft Office Excel 2003 Object Model http://msdn.microsoft.com/en-us/library/aa20371429.aspx How Do I… in Excel http://msdn.microsoft.com/en-us/library/bb257110.aspx More Articles http://social.msdn.microsoft.com/Search/en-US?query=Visual20for2020object22&ac=8 Add Code Title URL Using VBA to Access Document Content in the 2007 Office System http://msdn.microsoft.com/en-us/library/dd630624.aspx Take Control of Microsoft Word Through Events http://msdn.microsoft.com/en-us/library/aa14027929.aspx Ten Tips for Microsoft Office VBA Library Development http://msdn.microsoft.com/en-us/library/aa16401929.aspx Extending Word, Excel, and PowerPoint with a Single Line of VBA Code http://msdn.microsoft.com/en-us/library/dd535470.aspx Programming Concepts: Custom Classes and Objects http://msdn.microsoft.com/en-us/library/aa14095429.aspx More Articles http://social.msdn.microsoft.com/Search/en-US?query=Office20Basic20Applications20sample&ac=8 Backstage View Video Title URL Extending the Office 2010 Backstage View and Other UI http://msdn.microsoft.com/en-us/office/ee722027.aspx Customizing the Backstage view and Ribbon UI in Office 2010 http://blogs.msdn.com/johnrdurant/archive/2009/10/27/customizing-the-backstage-view-and-ribbon-ui-in-office-2010.aspx Adding Event Code to Microsoft Office Backstage View Customizations http://blogs.msdn.com/johnrdurant/archive/2009/10/28/adding-event-code-to-microsoft-office-backstage-view-customizations.aspx More Articles http://social.msdn.microsoft.com/Search/en-US/?Refinement=68&Query=Backstage&ir=1 Extensibility Level Title URL Architecture of Document-Level Customizations http://msdn.microsoft.com/en-us/library/zcfbd2sk.aspx Architecture of Application-Level Add-Ins http://msdn.microsoft.com/en-us/library/bb386298.aspx VSTO: Creating Your First Application-Level Add-in for Word http://msdn.microsoft.com/en-us/library/cc442946.aspx Developing Add-ins (XLLs) in Excel http://msdn.microsoft.com/en-us/library/aa730920.aspx More Articles http://social.msdn.microsoft.com/Search/en-US?query=Office20application20add-in&ac=8 Ribbon Video Title URL Developer Overview of the User Interface for Microsoft Office System http://msdn.microsoft.com/en-us/library/aa338198.aspx Customizing the Office Fluent Ribbon for Developers http://msdn.microsoft.com/en-us/library/aa338198.aspx Automating a Word Document Using Visual Studio 2005 Tools for the Office System SE Ribbon Support http://msdn.microsoft.com/en-us/library/bb426919.aspx More Articles http://social.msdn.microsoft.com/Search/en-US/?Query=office+ribbon+fluent+ui+overview User Scenarios Title URL Extend The Office System With Your Own Ribbon Tabs and Controls http://msdn.microsoft.com/en-us/magazine/cc163469.aspx RibbonGadgets Sample: Ribbon Gadgets Application http://msdn.microsoft.com/en-us/library/bb982410.aspx Outlook Sample: Ribbon Extensibility Add-In http://www.microsoft.com/downloads/details.aspx?familyid=11ab93bf-48dc-4f73-8f6b-62b4482a92bc&displaylang=en More Articles http://msdn.microsoft.com/en-us/office/aa905352.aspx Basic Ingredients Title URL Ribbon Overview http://msdn.microsoft.com/en-us/library/bb38609729.aspx Ribbon Extensibility Overview http://msdn.microsoft.com/en-us/library/aa94286629.aspx Automation an Application from Controls on the Ribbon http://msdn.microsoft.com/en-us/library/aa94295529.aspx More Articles http://social.msdn.microsoft.com/Search/en-US/?Query=office+ribbon+fluent+ui Define the User Interface Using XML Markup Title URL Adding Custom Dyanmic Menus to the Office Fluent User Interface http://msdn.microsoft.com/en-us/library/bb462634.aspx Hiding Groups on the Office Fluent Ribbon Using a Toggle Button http://msdn.microsoft.com/en-us/library/bb545350.aspx Programmatically Customizing the Office Fluent User Interface http://msdn.microsoft.com/en-us/library/bb335359.aspx Extend The Office 2007 Office System With Your Own Ribbon Tabs And Controls http://msdn.microsoft.com/en-us/magazine/cc163469.aspx Adding Custom Buttons to the 2007 Office Fluent User Interface http://msdn.microsoft.com/en-us/library/bb410115.aspx More Articles http://social.msdn.microsoft.com/Search/en-US/?Query=office+ribbon+fluent+ui+designer Add Code Title URL Customizing the Office Fluent User Interface with Visual Studio 2005 Tools for Office Second Edition http://msdn.microsoft.com/en-us/library/bb410108.aspx Customizing the Office Fluent Ribbon for Developers http://msdn.microsoft.com/en-us/library/aa338202.aspx Customizing the Ribbon in Outlook http://msdn.microsoft.com/en-us/library/bb226712.aspx More Articles http://social.msdn.microsoft.com/Search/en-US/?Query=office+ribbon+fluent+ui+code+sample Extensibility Level Title URL Architecture of Document-Level Customizations http://msdn.microsoft.com/en-us/library/zcfbd2sk.aspx Architecture of Application-Level Add-Ins http://msdn.microsoft.com/en-us/library/bb386298.aspx VSTO: Creating Your First Application-Level Add-in for Word http://msdn.microsoft.com/en-us/library/cc442946.aspx Developing Add-ins (XLLs) in Excel http://msdn.microsoft.com/en-us/library/aa730920.aspx More Articles http://social.msdn.microsoft.com/Search/en-US?query=Office20application20add-in&ac=8 MSDN Developer Resources Title URL Office Developer Resources http://go.microsoft.com/?linkid=9698691 Word Developer Center http://msdn.microsoft.com/en-us/office/aa905482.aspx Excel Developer Center http://msdn.microsoft.com/en-us/office/aa905411.aspx Outlook Developer Center http://msdn.microsoft.com/en-us/office/aa905455.aspx MSDN Office Development Library http://msdn.microsoft.com/en-us/library/bb726434.aspx Product and Solutions Information Title URL Office Online http://www.microsoft.com/office Office Business Applications Center http://www.obacentral.com Excel Developer Center http://msdn.microsoft.com/en-us/office/aa905411.aspx Outlook Developer Center http://msdn.microsoft.com/en-us/office/aa905455.aspx MSDN Office Development Library http://msdn.microsoft.com/en-us/library/bb726434.aspx

More here:
Helpful Content Links for Getting Started with Office Development

Excel

New Learning Resources on the VSTO Developer Center (Beth Massi)

Last week we revamped the Learn pages on the VSTO Developer Center with more content that allows you to pivot on more fine-grained topics and tasks under each type of Office solution. We’ve changed the layout of these pages so that you can browse for a type of solution (right now we have Excel , Word , Outlook and Deployment ) and then you can drill down into the specific topics to reveal articles and videos underneath. As you select a topic on the left, the content changes on the right so check it out

The rest is here: 
New Learning Resources on the VSTO Developer Center (Beth Massi)

Next Page »