The following content items were published last June.
Book excerpt: Book Excerpt: Chapter 3: Customizing and Extending the Microsoft Office SharePoint 2007 Search (Part 2 of 2) MVP Patrick Tissegham shows how to execute a search via a custom Web Part that can be dropped on SharePoint sites.
2007 Microsoft Office System
Microsoft Office SharePoint Server 2007
Book excerpt: Book Excerpt: Chapter 3: Customizing and Extending the Microsoft Office SharePoint 2007 Search (Part 1 of 2) Learn to customize and extend Office SharePoint Server Search in this book excerpt from MVP Patrick Tisseghem.
Microsoft Office SharePoint Server 2007
Code sample: Sample: SharePoint Server 2007 Sample: Windows Compute Cluster Server Job Submission Sample for Excel Services and Excel 2007 Download this SharePoint Server 2007 code sample and learn how to use a compute cluster to improve workbook performance when running a parametric sweep. http://download.microsoft.com/download/A/B/5/AB5CF9F0-E366-4F2D-A908-931FC224F784/OfficeExcelServicesECSCCSSamples.exe
Microsoft Office Excel 2007
Technical article: Converting InfoPath 2003 Managed Code to the New InfoPath 2007 Object Model Learn how to convert managed code created in InfoPath 2003 to use the new InfoPath 2007 object model so that your form can be deployed to Office Forms Server 2007 or Office SharePoint Server 2007. http://msdn2.microsoft.com/en-us/library/bb643160.aspx
Microsoft Office Forms Server 2007
Microsoft Office InfoPath
Microsoft Office InfoPath 2007
How-To article: Visual How To: Creating Outlook Form Regions by Using Visual Studio 2005 Tools for Office SE VSTO 2005 SE provides tools to help you add managed code to form regions that you design in Outlook, and add the form regions to Outlook add-ins. http://msdn2.microsoft.com/en-us/library/bb608179.aspx
Microsoft Office Outlook 2007
Visual Studio Tools for Office
Harry Miller; Kathleen McGrath; Norm Estabrook
Download: Download: Access 2007 Developer Extensions The Access 2007 Developer Extensions make it easy to deploy and manage solutions built using Access.http://www.microsoft.com/downloads/details.aspx?familyid=d96a8358-ece4-4bee-a844-f81856dceb67&displaylang=en
Microsoft Office Access 2007
SDK: SDK: Excel Services and Excel 2007 Windows Compute Cluster Server 2003 Job Submission Developer Guide Learn how to build an integrated solution to improve the performance and reliability of Excel 2007 workbooks. The sample demonstrates how you can use a compute cluster to improve workbook performance when running a parametric sweep by using Windows CCS 2003 and SharePoint Server 2007. http://msdn.microsoft.com/library/?=/library/en-us/XL2007JobSubDevGuide/html/filename.asp
Development guide: SDK: Microsoft Office Live Developer Guide (Update) The new June 2007 version of the Microsoft Office Live Developer's Guide includes documentation for the latest code samples and instructions to help you package solutions. http://msdn2.microsoft.com/en-us/library/aa751764.aspx
Microsoft Office Live
How-To article: Visual How to: Hiding Groups on the Office Fluent Ribbon Using a Toggle Button Performing various actions on the 2007 Microsoft Office Fluent UI, such as hiding groups, requires only a few lines of XML and programming code. http://msdn2.microsoft.com/en-us/library/bb545350.aspx
2007 Microsoft Office System
Technical article: Development Tools and Techniques for Working with Code in Windows SharePoint Services 3.0 (Part 2 of 2) Explore Windows SharePoint Services solutions, solution architecture, and techniques for creating, deploying, maintaining, and upgrading Windows SharePoint Services solutions. http://msdn2.microsoft.com/en-us/library/bb530301.aspx
Windows SharePoint Services v3
Technical article: Development Tools and Techniques for Working with Code in Windows SharePoint Services 3.0 (Part 1 of 2) Learn the skills you need to develop for Windows SharePoint Services 3.0, about the differences from traditional ASP.NET development, about the required development environment, and the steps to build a Windows SharePoint Services solution with Visual Studio 2005 Extensions for Windows SharePoint Services 3.0. http://msdn2.microsoft.com/en-us/library/bb530302.aspx
Book excerpt: Book excerpt: Chapter 6: Integrating Spreadsheets into the Enterprise Learn to enhance Excel Services to incorporate methods of a .NET class, connect a workbook to external systems, databases, and Web services, perform calculations, and incorporate workbook calculation logic into a custom application.
Ed Hild and Susie Adams
How-To article: Visual How To: Troubleshooting Deployment Errors in Visual Studio Tools for Office Second Edition Review code access security policy and learn how to avoid common deployment errors when developing custom solutions that use VSTO 2005 SE. http://msdn2.microsoft.com/en-us/library/bb510371.aspx
Visual Studio Tools for Office
How-To article: Visual How to: Mapping Word 2007 Content Controls to Custom XML Using the XMLMapping Object Learn how to map content controls to elements in a custom XML part that is attached to a document by using the Developer tab in the Office Fluent Ribbon and the XMLMapping object.
Microsoft Office Word 2007
Technical article: Working with XML Data Using the XPathNavigator Class in InfoPath 2007 Form Templates Learn how to use the XPathNavigator and XPathNodeIterator classes to access and work with data in business logic written with managed code in InfoPath 2007 form templates. http://msdn2.microsoft.com/en-us/library/bb509311.aspx
Microsoft Office InfoPath 2007
How-To article: Visual How to: Temporarily Repurpose Commands on the Office Fluent Ribbon Learn how repurposing controls and commands requires only a few lines of XML and programming code. http://msdn2.microsoft.com/en-us/library/bb462633.aspx
How-To article: Visual How to: Adding Custom Dynamic Menus to the Office Fluent User Interface Learn how adding controls, such as dynamic menus and buttons, requires only a few lines of XML and programming code. http://msdn2.microsoft.com/en-us/library/bb462634.aspx
Technical article: Evaluating and Customizing Search Relevance in SharePoint Server 2007 Learn to improve relevance in Enterprise Search for SharePoint Server 2007, and how to implement an evaluation process to determine the impact of your adjustments. http://msdn2.microsoft.com/en-us/library/bb499682.aspx
Dmitriy Meyerzon, Microsoft Corporation; Avi Schmueli, Microsoft Corporation; Jo-Anne West, Microsoft Corporation
Column: OfficeTalk: Publishing and Synchronizing Excel 2007 Tables to SharePoint Lists (Jun 2007) In Excel 2007, the ability to synchronize the data between a table and a list in Windows SharePoint Services is deprecated. Learn how to use an add-in to update the information in a SharePoint list from Excel 2007. http://msdn2.microsoft.com/en-us/library/bb462636.aspx
Download: Download: 2007 Office System: Microsoft SDK for Open XML Formats Technology Preview for Open XML Formats Technology Preview Download the June 2007 Community Technology Preview of the Microsoft SDK for Open XML Formats now. http://download.microsoft.com/download/7/7/3/7737344c-40f6-47f3-9f5e-be8e7a7a0a89/OpenXMLSDK.msi
SDK: Microsoft SDK for Open XML Formats Technology Preview The Open XML object model encapsulates many common tasks that developers perform on OpenXML packages, so you can perform complex operations with just a few lines of code. Find documentation, code samples, "How to" articles, and programming references to help simplify the task of manipulating Open XML packages. http://msdn2.microsoft.com/en-us/library/bb448854.aspx
Code sample: Sample: Excel 2007 Add-in: Synchronizing Tables with SharePoint Lists Use this Excel 2007 add-in to synchronize data in a table with a list on a SharePoint site. http://download.microsoft.com/download/a/a/2/aa2fcd30-332d-426f-82c1-2e4e8d783e91/XL2007SynchronizeWSSandExcel.exe
Frank Rice, Jon Adams
If you couldn't make it to TechEd - or even if you did - check out Virtual TechEd.
I loved attending Tech Ed this year because I had a chance to be at the Open XML File Formats booth and chat with MVPs and developers that are really passionate about this technology. It was great week to be there because we launched the Open XML SDK and there was a lot of interest in the new API. In case you haven't seen all the Open XML SDK news and announcements, Doug Mahugh has a great blog post with useful links and the whole story.
I also had a great opportunity to meet and share booth duty with Stephanie Krieger and Doug Mahugh.
Stephanie Krieger is a Microsoft Office MVP and the master of document production. Stephanie is the author of the Office 2007 documents bible: Advanced Microsoft Office Documents 2007 Edition Inside Out. This is the book you need if you want to learn tons of cool tips and tricks for advanced document generation. Stephanie included Office Open XML and VBA code samples.
It was so fun to hang out with her because I got private black-belt lessons about Office 2007 documents. One of the things Stephanie showed me was the super cool Office Online interactive reference guides. This is a fun set of tools to use if you are getting started with Office 2007 and trying to figure where commands are located.
If you want your own private lesson with Stephanie, you should check out her blog and her webcast Advanced Tips and Tricks: What You Can Really Do with Your Documents Across the 2007 Office Release.
Doug Mahugh is the traveling encyclopedia of the Open XML File Formats. He has visited all continents to share with the community the latest tips and tricks for developing solutions using the Open XML File Formats. He has one of the most visited and coolest MSDN blogs and he has quite a following. I was surprised by how many people were looking for him at the booth.
Doug delivered two great sessions at Tech Ed: Office Open XML File Format Fundamentals and Working with Custom Schemas in the 2007 Microsoft Office System. He is currently traveling all around the globe delivering Office Open XML workshops. Last time I saw him, he was returning from Africa. Read Doug's personal blog and follow him around the globe.
I also had a chance to meet Stephen Peront, a co-founder of XINNOVATION, Inc. Stephen is so smart! He managed to learn the Open XML API and migrate a PowerPoint presentation generator tool in a weekend. He demoed the before and after code at the Office Open XML File Format Fundamentals session and it just made me proud to see in action a happy consumer of the first release of the Open XML API. You can find all details about Stephen's tool and adventures with the Open XML API here: Announcing the API with a hands-on example.
I also met Mick Lohan. He is the Technical Director of South East Software and a great enthusiast for the Open XML File Formats. He is Irish and he gave me a "Celtic Sounds & Songs" CD as a gift for answering some Open XML questions. I have to say that Irish people are the best. They are super fun, smart, and nice. Mike has a nice blog and he compiled a huge number of pictures at Tech Ed.
Finally, I met the Altova team. They were very nice to give me a demo of the new XMLSpy. If you work with XML technologies it comes quite handy to have an XML editor tool and XMLSpy rocks. Altova announced at Tech Ed some great news for Office developers. They just released a new version of XMLSpy that provides support for accessing, editing, transforming, and querying XML data saved in Microsoft® Office 2007 documents and other zipped files. My favorite feature is the intellisense support. It's really helpful when you are working with WordProcessingML. You can find a free trial and all info here: http://www.altova.com/features_office_2007.html
The Open XML File Formats booth gang
This is me in my new orange dress with the Open XML Gang: Stephen Peront, Stephanie Krieger, and Doug Mahugh.
The Microsoft Office Developer booth
I visited every now and then my friends at this booth. Jim Corbin aka Mr. Project Server was at this booth doing demos of an Office Business Application solution and the Microsoft Office Interactive Developer Map.
MSDN news and the Microsoft super heroes gang!
I get to work with all of them, so it was cool that I got my picture with my v-team J.
MSDN launched recently a new UI (Tobago) and the MSDN gang showcased the new navigation and search improvements. Verna Appel DeLuna and Karen Bass from MSDN migrated the MSDN Office Developer Center last week to the new UI. In case you haven't seen it, come look!
MSDN also ran demos for the three new Microsoft Community Betas.
The Atlantis Shuttle launch with the IIS gang
My lovely husband CarlosAg and friends from IIS kidnapped me to go watch the launch of Atlantis. This was such a happy ending for Tech Ed and an experience I'll share with my kids one day. Thank you Brian for organizing such a fun trip! BTW. Brian is Irish too.
Interesting fact. The Atlantis crew landed last Friday (6/22). Can you believe it took them less time to go to space and come back, than the time it took me to download my Tech Ed 2007 pictures and blog?
Part 2 of this blog will list the top ten questions from the Open XML File Formats booth. I'll provide answers with code samples and pointers to resources.
We just published a must see paper written by Patrick Tisseghem of U2U, Mike Fitzmaurice, and heavy consultation from Mike Ammerlaan:
Have you wanted information on how to package Web Parts, event receivers, list/feature/site definitions into solutions? How to deploy those solutions from a development environment to a test environment into production? How application assets deployment is different from content deployment? How to push a new version of a Web Part/feature/application page out to a site that has the old version already in production?
This paper covers it. Go get it!
What a day at Tech ED! Today Doug Mahugh announced during his session the new Open XML Object Model and Brian Jones has a must see post in his blog.
The Open XML object model encapsulates many common tasks that developers perform on Open XML packages, so you can perform complex operations with just a few lines of code. As you can imagine, this API is a great time saver for those of you that write code to manipulate Open XML packages using the System.IO.Packaging APIs. I was lucky enough to play with this API some weeks before the release and I strongly recommend that you download your copy and get your hands dirty. I can tell you that with this new API you write ~70% less code.
The following is a partial class diagram of the API.
My dear friend Frank Rice did a fantastic job creating an SDK for the API. We included the previous diagram and some how-to articles that Frank and I wrote J. You can download the SDK and the API from this link: http://www.microsoft.com/downloads/details.aspx?FamilyId=AD0B72FB-4A1D-4C52-BDB5-7DD7E816D046&displaylang=en
Additionally you can find online documentation here: http://msdn2.microsoft.com/en-us/library/bb448854.aspx
Some must see MSDN topics:
Keep in mind this is a CTP, so we are expecting to get a lot of customer feedback to polish this API into a better one.
If you are at Tech ED, you should stop by at the Open XML File Formats booth. Stephanie, Doug, and I will be happy to chat with you.
If you are not at Tech Ed and are interested in providing feedback, you can submit a post at the Microsoft SDK Open XML MSDN Forum. Additionally, if you want to submit feedback about the documentation, you can use our Wiki enabled articles in MSDN.
Have fun with the API and PLEASE let us know what you think.
Just a quick and late night blog entry after packing my blue Microsoft T-shirts :). I am looking forward to being at TechEd this year in Orlando and will be at the Open XML File Formats booth.
Watch the news and check out techedbloggers here:
Hope to see there!