Erika Ehrli - Adventures with Office Products & Technologies
MSDN & TechNet: Releasing Office, SharePoint, Exchange & Lync Centers and content for developers and IT professionals.

April, 2009

  • Erika Ehrli - Adventures with Office Products & Technologies

    Office “14” – Microsoft Office 2010 Products and Technologies: Names & Availability


    Today as part of the Exchange 14 annoucement we officially announced the name and availability of Office “14” products and technologies!

    Exchange Server 2010 will become available in the second half of 2009. Microsoft Office 2010 and related products will enter technical preview in the third quarter of 2009 and become available in the first half of 2010.

    Microsoft Office 2010, Microsoft SharePoint Server 2010, Microsoft Visio 2010 and Microsoft Project 2010 are scheduled to enter technical preview in the third quarter of 2009 and release to manufacturing in the first half of 2010.

    I am looking forward to share with the developer community the latest news related to our Microsoft Office 2010 release.

    Bookmark and Share
  • Erika Ehrli - Adventures with Office Products & Technologies

    Open XML SDK 2.0 April CTP Live & Silverlight DeepZoom Class Architecture Diagrams


    For all of those fans of Open XML and followers of updates done to the Open XML Format SDK 2.0, one more happy day has arrived. The Office Client Developer Content team and the Open XML SDK product team released the Open XML Format SDK 2.0 April CTP on MSDN! Zeyad has a great blog post where he explains in detail what’s new with the latest version of the SDK.

    Brief Class Architecture Overview

    The Open XML Format SDK 1.0 is a licensed version of the Open XML SDK that allows you to manipulate Open XML package parts. However, you need to create your own code to manipulate XML content in each part. The Open XML SDK Format SDK 2.0 provides a set of strongly typed classes and objects that allow you to manipulate packages and XML content in each part. Here’s a list of the namespaces that you can find in the latest version of the SDK:

    • DocumentFormat.OpenXml
    • DocumentFormat.OpenXml.AdditionalCharacteristics
    • DocumentFormat.OpenXml.Bibliography
    • DocumentFormat.OpenXml.CustomProperties
    • DocumentFormat.OpenXml.CustomXmlDataProperties
    • DocumentFormat.OpenXml.CustomXmlSchemaReferences
    • DocumentFormat.OpenXml.Drawing
    • DocumentFormat.OpenXml.Drawing.ChartDrawing
    • DocumentFormat.OpenXml.Drawing.Charts
    • DocumentFormat.OpenXml.Drawing.Diagrams
    • DocumentFormat.OpenXml.Drawing.LegacyCompatibility
    • DocumentFormat.OpenXml.Drawing.LockedCanvas
    • DocumentFormat.OpenXml.Drawing.Pictures
    • DocumentFormat.OpenXml.Drawing.Spreadsheet
    • DocumentFormat.OpenXml.Drawing.Wordprocessing
    • DocumentFormat.OpenXml.ExtendedProperties
    • DocumentFormat.OpenXml.Internal.SchemaValidation
    • DocumentFormat.OpenXml.Math
    • DocumentFormat.OpenXml.Office.ContentType
    • DocumentFormat.OpenXml.Office.CoverPageProps
    • DocumentFormat.OpenXml.Office.CustomDocumentInformationPanel
    • DocumentFormat.OpenXml.Office.CustomUi
    • DocumentFormat.OpenXml.Office.CustomXsn
    • DocumentFormat.OpenXml.Office.Excel
    • DocumentFormat.OpenXml.Office.LongProperties
    • DocumentFormat.OpenXml.Office.MetaAttributes
    • DocumentFormat.OpenXml.Office.Word
    • DocumentFormat.OpenXml.Packaging
    • DocumentFormat.OpenXml.Presentation
    • DocumentFormat.OpenXml.Spreadsheet
    • DocumentFormat.OpenXml.Vml
    • DocumentFormat.OpenXml.Vml.Office
    • DocumentFormat.OpenXml.Vml.Presentation
    • DocumentFormat.OpenXml.Vml.Spreadsheet
    • DocumentFormat.OpenXml.Vml.Wordprocessing
    • DocumentFormat.OpenXml.Wordprocessing

    You can find documentation on MSDN for each of the previous namespaces here:

    Also, if you are into graphical content, I have created a couple more Silverlight DeepZoom Class Diagrams. Spent some time experimenting with Silverlight 2.0 to please everyone who asked me to update my previous Silverlight DeepZoom Class Explorer. As you can see from the list above, the entire OM is huge! I only created diagrams for the namespaces bolded above.

    A few notes about the diagrams:

    1. The second diagram is a large image, so rendering quality is not always the best. Looks great on my local computer, but sometimes I’ve noticed that images and rendering are blurry on the version I made available on my personal Web site. Some F5s and a good network connection make it better.
    2. If you want to run them locally, I attached to this blog entry copies of both VS projects.

    Download: DocumentFormat.OpenXML

    Download: Document.Format.OpenXML.Packaging

    To view the diagrams locally, download and extract the zip files and locate the \…\…\DeepZoomProjectWeb\ClientBin\*.html file on each project.  DocumentFormatOpenXML_CD.html is the preview file for the first project and DocumentFormatOpenXMLPackaging_CD.html is the preview file for the second project.

    3. Make sure you download VS2008 SP1 + Silverlight 2 Tools for VS 2008 SP1 if you want to open the source code in VS 2008.

    Open XML SDK 2.0 resources:

  • Download the SDK
  • Online Documentation
  • Ask a Question- MSDN Forum: Open XML Format SDK
  • Latest MSDN articles
    1. Creating Documents by Using the Open XML Format SDK 2.0 CTP, Part 1
    2. Creating Documents by Using the Open XML Format SDK 2.0 CTP, Part 2
    3. Creating Documents by Using the Open XML Format SDK 2.0 CTP, Part 3

    We have about 10 articles + videos, and 50~ code samples coming soon!

  • Great bloggers to follow:
    1. Brian Jones / Zeyad Rajabi
    2. Eric White
    3. Doug Mahugh
    4. Stephen Peront


  • Bookmark and Share
  • Erika Ehrli - Adventures with Office Products & Technologies

    Office 2007 Service Pack 2 Download and Improvements for Developers

    dd490655.DeskApps(en-us,MSDN.10)[1] The Office 2007 SP2 is available now for download:

    Here are some improvements on SP2 that matter to developers:

    • Save as PDF and XPS: One of the coolest things you can do from Office 2007 Word, Excel, and PowerPoint is “Save As” PDF or XPS. You can also programmatically Save AS ODF or XPS using the OM. Here’s a cool video that shows how to do this:
    • Update: Also, here's a great sample VBA sample code from Ron de Bruin:

      Before SP2, you could download a free add-in to get this functionality. The SP2 offers this functionality out-of-the box.

    • Save as ODF 1.1 for Word, Excel, and PowerPoint: OpenDocument 1.1 (ODF) has been added as an available file format for saving documents in Word, Excel and PowerPoint. Our decision to support ODF is just one aspect of Office's broad commitment to choice and interoperability, as covered by Tom Robertson today on the Microsoft on the Issues blog. See Doug Mahugh’s great blog post for details.
    • New External File Format Converter API: In addition to allowing you to edit the ODF 1.1 format within Office 2007, SP2 also supports a new External File Format API that can be used to edit other document formats as well. With this API, users can choose to save their documents in any format they want. You can find more details at Stephen Peront’s blog. We are planning to release some developer documentation that shows how to work with this API on MSDN.
    • Charting Object Model for Word and PowerPoint: A charting Object Model (OM) for Word and PowerPoint has been added to align with the charting support in Excel. Many customers expressed a need to programmatically insert, manipulate the size, and set the formatting of the charts similar to what was provided in the Office 2003 release. David Hale has a great blog post where he explains all the details.
    • SharePoint and WSS 3.0 updates: Microsoft® Windows® SharePoint® Services 3.0  Service Pack 2 (SP2) and Microsoft® Office SharePoint® Server 2007  Service Pack 2 (SP2) include updates designed to improve performance and availability in your SharePoint server farm, along with fixes to known issues across SharePoint Products and Technologies. In addition, SP2 provides enhancements designed to support greater interoperability, improve user experience and reduce administrative burden. Finally, SP2 provides the groundwork for an eventual upgrade to the next major version of SharePoint Products and Technologies. You can find a high-level overview of what Sharepoint SP2 offers here and at the SharePoint Team blog.

    Gray Knowlton has a couple great posts that explain more details of this release:

    Bookmark and Share
  • Erika Ehrli - Adventures with Office Products & Technologies

    Announcing the MSDN Office Developer Bookstore


    We have some great news for Office and SharePoint developers. We launched this morning a new section on the MSDN Office Developer Center where you can find Office and SharePoint books that matter to developers. We also provide free book chapters!

    MSDN Office Developer Bookstore

    Here’s the set of links where you can find our bookstore pages:

    Why books matter to developers?

    Research has shown that books are one of the most popular learning resources among developers. I agree with Research. Devs love books and most of us like collecting books with code samples. Why not have a place where we can have a live inventory of cool books that matter to Office and SharePoint developers?

    Also, MVPs and experts from our development community have authored more than 40 Office and SharePoint top-seller books. Why not help promote their work and wisdom? To make it even better for the community, the Office Developer Documentation group has contacted different publishers and acquired more than 70 book chapters. You can access book chapters on MSDN for free from our bookstore. Some book chapters are already published and some are coming soon. We will keep adding them to our book excerpts page as we publish more.

    We joined the Amazon Associates program, so you if you want to buy a book, you can go directly from our bookstore pages to Amazon.

    Not a developer? If you are an IT professional or an Information Worker and want to find Office and SharePoint books that matter to you, you can also find books on TechNet and Office Online (coming soon).

    We’d like to invite everyone from the community to make our bookstore even better by referring more books. We are interested in hearing your recommendations for Office and SharePoint books that matter to developers. You can contact us through our Facebook group, our MSDN_Office twitter feed,  or you can leave your comments @ this blog entry.


  • Erika Ehrli - Adventures with Office Products & Technologies

    Office Palooza: Join the contest to test & sharpen your VBA programming skills!


    MSDN® is sponsoring a coding contest for Office 2007, named OfficePalooza! This sweepstakes will run two weeks beginning April 20, 2009, and features ten fun Visual Basic of Applications™ (VBA) coding challenges in the form of puzzles and games. Each entrant will earn a chance to win one of hundreds of available prizes, determined by a random drawing at the end of the contest.

    About OfficePalooza

    About OfficePalooza
    What’s this all about, and where did this crazy idea come from, anyway?

    OfficePalooza Challenge Preview

    OfficePalooza Challenge Preview
    Get a preview of the types of challenges you’ll be seeing with these short summaries. We’ve also included deadlines so you’ll be able to plan ahead.

    Introduction to VBA

    Getting Started with VBA

    If you’re new to Visual Basic for Applications (VBA), this article might help prepare you for the challenges.

    Binder Clippy

    The Story of Binder Clippy
    An introduction to our mascot, Binder Clippy!

    Find all details about this contest at the Office Palooza Web site:

    In conjunction with this contest, an Advanced Business User theme will run on Microsoft Office Online from mid-April to mid-May, and will showcase the automation and extensibility aspects of Office 2007 through macros, custom VBA coding, the Fluent UI, and Office Open XML.  This collaborative effort will also highlight existing and newly-created content on the MSDN Microsoft Office Developer Center.

    Share the news!

    Some other bloggers who have already blogged about this contest:





    Join the contest and have fun!

    Bookmark and Share
  • Page 1 of 1 (5 items)