We have published 54/101 Office Visual How-tos!
We started with some topics related to client development and now we are starting to publish the WSS and MOSS topics. If you are getting started with MOSS and WSS 3.0, I strongly recommend that you take a look at the following series of VHTs:
VHTs include code sample in VB.NET and C# + a video + an overview of the topic + links to related resources and blogs.
I compiled a list of all our published VHTs (including client development and VSTO) and I bolded the ones related to MOSS and WSS 3.0.
Visual How to: Creating Calculated Columns in Excel 2007
Tuesday, May 15, 2007
Visual How to: Enabling Users to Act on LOB Data with Business Data Catalog Actions in SharePoint Server 2007
Visual How To: Changing the Type of a Word 2007 Content Control
Visual How to: Hiding Tabs on the Office Fluent Ribbon Using a Toggle Button
Tuesday, May 08, 2007
Visual How to: Opening a Browser from a Button on the 2007 Office Fluent Ribbon
Visual How To: Reading Entries from the Audit Log in Windows SharePoint Services 3.0
Visual How To: Creating a Solution Package in Windows SharePoint Services 3.0
Visual How To: Running Commands with Elevated Privileges in Windows SharePoint Services 3.0
Visual How To: Displaying Data by Using the SPGridView Control in Windows SharePoint Services 3.0
Visual How To: Creating a Visual Studio Project for in Windows SharePoint Services 3.0
Visual How to: Pulling CRM Data into InfoPath 2007 Browser Forms
Tuesday, May 01, 2007
Visual How To: Creating a Feature for an Entry Control Block Item in Windows SharePoint Services 3.0
Visual How To: Creating a Feature for the Site Actions Menu in Windows SharePoint Services 3.0
Visual How To: Activating Auditing Programmatically for a Site Collection in Windows SharePoint Services 3.0
Visual How To: Activating Auditing Programmatically for a Single Document Library in Windows SharePoint Services 3.0
Visual How To: Creating an Application Page in Windows SharePoint Services 3.0
Visual How To: Reading ListID and ItemID from an Application Page in Windows SharePoint Services 3.0
Visual How To: Locking a Word 2007 Content Control
Visual How To: Automating PowerPoint 2007 Using a Custom Task Pane
Harry Miller, Kathleen McGrath, McLean Schofield
Visual How to: Synchronizing Two Combo Boxes on Forms Using Access 2007
Tuesday, April 24, 2007
Visual How to: Displaying Custom Dialog Boxes for Custom Delete Actions in Access 2007
Visual How to: Adding Chart Elements to Excel 2007 Charts
Visual How to: Setting Conditional Formatting in Excel 2007
Visual How to: Saving Word 2007 Documents to PDF and XPS Formats
Visual How To: Creating Content Sources to Crawl Business Data in SharePoint Server 2007 Enterprise Search
Visual How-to: Creating a Custom Search Page and Tabs in the Search Center of SharePoint Server 2007 Enterprise Search
Visual How to: Using Business Data Catalog Actions to Pass Parameters to InfoPath 2007 Browser Forms
Visual How To: Filtering the Building Block List in a Word 2007 Content Control
Visual How To: Inserting a Word 2007 Content Control into a Building Block
Visual How to: Saving Excel 2007 Workbooks Programmatically in PDF File Format and XPS File Format
Tuesday, April 17, 2007
Visual How to: Creating Managed-Code UDFs for Excel Services
Visual How To: Creating and Exposing Search Scopes in SharePoint Server 2007 Enterprise Search
Visual How to: Creating and Exposing Managed Properties in the Advanced Search Page of SharePoint Server Enterprise Search
Visual How to: Refining Business Data Catalog Search With Scopes
Visual How to: Retrieving Excel 2007 Workbooks or Snapshots Using Office SharePoint Server 2007 Excel Services
Siew Moi Khor, Danny Khen, Joel Krist (Akona Systems)
Tuesday, April 10, 2007
Visual How to: Adding Custom Buttons to the 2007 Office Fluent Ribbon
Visual How to: Adding Custom Check Boxes to the 2007 Office Fluent Ribbon
Visual How to: Creating Business Data Catalog Entities in SharePoint Server 2007
Visual How to: Filtering one Business Data Catalog List from Another by Using Associations in SharePoint Server 2007
Visual How to: Creating a Custom Building Block Gallery
Visual How to: Customizing the Office Fluent Ribbon in Visual Studio 2005 Tools for Office Second Edition
Visual How to: Creating Basic Column Charts in Excel 2007
Tuesday, April 03, 2007
Visual How to: Adding Custom Combo Boxes to the 2007 Office Fluent Ribbon
Visual How to: Adding DialogLauncher Controls to the 2007 Office Fluent Ribbon
Visual How to: Automating a Word 2007 Document Using Visual Studio 2005 Tools for Office SE
Kathleen McGrath, Harry Miller, McLean Schofield
Visual How to: Adding Tabs and Controls to the Ribbon in Access 2007
Wednesday, March 28, 2007
Visual How to: Programmatically Customizing the 2007 Office Fluent User Interface
Wednesday, March 21, 2007
Visual How to: Office Open XML Formats: Retrieving Lists of PowerPoint 2007 Slides
Thursday, March 15, 2007
Visual How to: Office Open XML Formats: Replacing PowerPoint 2007 Slide Images
Visual How to: Office Open XML Formats: Setting Custom Word 2007 Document Properties
Wednesday, March 14, 2007
Visual How to: Office Open XML Formats: Retrieving Excel 2007 Cell Values
Thursday, March 08, 2007
Visual How to: Use Office Open XML File Formats to Retrieve a List of Excel 2007 Worksheets
Visual How To: Building Document Templates in Word 2007 Using Content Controls
Erika Ehrli; Brian Jones; Lisa Wollin
Monday, January 29, 2007
Visual How To: Building Word 2007 Documents Using Open Office XML File Formats
Erika Ehrli Cabral; Brian Jones
You can find a complete list of VHTs and Office "How Do I…" articles at the Office Developer How To Center. We will publish at least 50 more VHTs before the end of July.
Shame on me for not blogging in such a long time! I just got busy with some Visual How-to articles and some other content that we are about to release.
Anyway, today I want to talk about the Office 2007 Object Model Maps that the Office Developer Documentation (aka Office Dev Docs) group published on MSDN. In the past we published the Office developer references and you had to use the MSDN Library table of contents or search to find reference documentation for an object. Office object models are huge so it's always useful to look at object model maps. Lisa Wollin and Office Dev Docs built a tool to read the different Office COM DLLs and generate a set of diagrams that allow you to drill-down to reference topics. The maps also highlight new objects and collections added to the different Office 2007 object models as compared to Microsoft Office 2003.
You can find the different Office 2007 OM maps at the MSDN TOC location: Office Solutions Development > 2007 Microsoft Office System> app > app Developer Reference > app Object Model Reference > app Object Model Apps
For instance, in Word, it's at:
The Office Dev Docs group also compiled a summary of the changes in the Office 2007 object models as compared to Office 2003, Office XP, Office 2000, and Office 97. These topics can help you understand compatibility challenges for VBA and Add-In applications between the different versions of Office. This information can be found at the MSDN TOC location: Office Solutions Development > 2007 Microsoft Office System> app > app Developer Reference > What's new > Object Model Changes Since <version>.
For instance, in Outlook, it's at:
Those topics can also be found in-the-box, at the TOC location <app> Developer Reference > What's new > Object Model Changes Since <version>
Some bloggers and third-party sites compile and provide a set of links to resources related to a topic and some of them are really good. Mark Kruger created a very cool list of 2007 MOSS Resource Links (Microsoft Office SharePoint Server) that he updates frequently and I enjoy looking at his list every now and then to see what's new.
After one year of publishing Office 2007 content, we figured it was time to start building resource pages on MSDN to share with everyone. We took a deep dive to the MSDN Library – Office Solutions Development node and pulled tons of useful links and categorized them by content type.
These are all new resources pages that compile links to articles, code samples, and how-to articles for Office 2007:
We also built some resource pages for Office 2003:
We have so much content that I always thought it would be nice to have a single stop for Office development articles, code samples, and how tos. We will update these pages as we publish more content.
ASP.NET 2.0 provides a new set of possibilities for SharePoint developers. Jo-Anne West and I were talking about the cool things you can do with Windows SharePoint Services 3.0. Both of us have a background working with ASP.NET and SharePoint Products and technologies, so this is a fascinating topic for us.
We think there's a lot of documentation on the topic in little pieces everywhere, but we were missing an article that compiles the theory, best practices, recommendations, and a real-world code sample. That's how we decided to take the chance, research, and write an article that can help you understand advanced concepts of the ASP.NET Web Part infrastructure and learn how to build custom Web Parts that work in both standard ASP.NET 2.0 and Office SharePoint Server 2007 Web sites. The article also talks about deployment and security settings.
You can find it here:
Working with ASP.NET 2.0 Web Parts and Windows SharePoint Services 3.0
The Windows SharePoint Services 3.0 SDK documentation provides an overview of the Windows SharePoint Services Web Part Infrastructure. However, we wanted to introduce you to the different approaches you can follow to build Web parts for Windows SharePoint Services 3.0.
Our advice: In general, you should create ASP.NET 2.0 Web Parts whenever you can. However, there are a few exceptions where using SharePoint-based Web Parts might offer advantages and the article explores those options.
Also, if you have worked with the ASP.NET 2.0 Web Part framework you possibly know that you can build Web Parts following different approaches. Only one approach will work with WSS 3.0: Create a custom class library project that contains a control that inherits from the System.Web.UI.WebControls.WebParts.WebPart class.
We do a deep dive to the ASP.NET 2.0 Web Part Infrastructure to complement the Windows SharePoint Services 3.0 SDK Web Parts Overview. In ASP.NET 2.0 you need to worry about personalization, while in SharePoint it's built-in for you. We consider relevant to explain the differences and what will work in both worlds.
If you like Hello World samples, you can find a cool Web Part sample here. For this article, we wanted to provide a walkthrough that goes beyond "Hello World." So we built a sample Web Part that displays driving directions on a Virtual Earth map. You may need driving directions from your home or office. Usually, you select the same start point, so we show you how to create a Start property that you can personalize. The Web part also provides a textbox that allows you to pick a destination and get driving directions in a Virtual Earth map.
This sample shows how you can display custom data in a Web Part. Anything can be done here!
The new Microsoft Office Fluent UI replaces the previous system of layered menus, toolbars, and task panes with a simpler system optimized for efficiency and discoverability. The new UI, including the Office Fluent Ribbon, provides improved context menus, enhanced screen tips, a Mini toolbar, and keyboard shortcuts that help to improve user efficiency and productivity. The new Office Fluent UI is implemented in several applications in the 2007 Microsoft Office suite, including Access, Excel, Outlook, PowerPoint, and Word.
You can extend the Ribbon using XML and one of several conventional programming languages to manipulate the components that make up the Ribbon UI. To extend the Ribbon you use different callback signatures depending on the control types. We have seen a lot of questions related to this subject. For instance, onAction for a gallery may be different from onAction for a button.
We wanted to provide a complete set of Ribbon XML snippets for every control/callback combination, and the corresponding function definitions, so Frank Rice built over 100 snippets divided between C# and VB .NET for Excel, PowerPoint, and Word. You can combine the snippets with your VSTO project if you want to and you can find the snippets here:
Frank is currently working on a new set of Office Visual How-tos where he shows how to customize the 2007 Office Fluent User interface programmatically. You can find the first Visual How-To of the series here:
I will update this blog entry to list more as we publish them.
Frank has done a fantastic job teaching all of us how to customize the 2007 Office Fluent User interface. Make sure you visit his blog and the Office Fluent Ribbon Developer Portal.
Lucky me! I had the great opportunity to meet several of the Open XML developers at the Open XML workshop in Redmond last week.
The workshop was quite interesting in terms of content and delivery. Tons of advanced samples related with WordProcessingML, SpreadsheetML, PresentationML, and more. The code for the labs was awesome and of course the best part was having to opportunity to watch Doug + Wouter, Brian, Tristan, and Sanjay showing lots of practical demos. After the workshop, Doug recorded some Channel 9 interviews with some of them. You will be able to watch a Linux/Java interoperability with Open XML (Sonata Software) demo, an Open-source Open XML API for Java (Julien Chable) demo, and the Package Explorer for Open XML (Wouter Van Vugt) demo. Pretty neat stuff you can do with the Office Open XML Formats.
While all this happened, I had my own Office Open XML Formats + MSDN stuff going on.
Last week we published the first two PowerPoint 2007 + Office Open XML Formats code samples + articles + videos on MSDN. Yes! We have two more Office Visual How-tos by Mr. Ken Getz:
I think it's great that we finally have two samples available. Curious minds want to learn how to manipulate PPT slide decks using the System.IO.Packaging library, XML, and the PowerPoint Open XML Format. These samples come quite handy when you are considering server-side PPT manipulation.
You probably read the MSDN Magazine article: Setting Word Document Properties the Office 2007 Way by Ken Getz. This was one of the first articles related to the Office Open XML Formats published by MSDN and it really helped me understand the Word document manipulation possibilites offered by the Office Open XML Formats.
Today we published a new Office Visual How-to by Ken Getz: Office Open XML Formats: Setting Custom Word 2007 Document Properties.
This article provides code in VB.NET and C# and a cool video that will help you understand how to set and retrieve custom document properties using the System.IO.Packaging library, XML, and the Word Open XML Format.
We have some documentation on Word and the Office Open XML Formats, but few documentation about Excel and PPT + the Office Open XML Formats. I am working with Joanna Bichsel and Mr. Ken Getz to get you all more samples that show you how to work with the System.IO.Packaging API to manipulate Excel workbooks and PPT slide decks. These samples have code in C# and VB.NET and they include a cool video that walks you through the process.
Ken repurposed 5/40 of the Office 2007 Open XML File Format code snippets and wrote great walkthroughs and videos that show you how it all works together. Today we published two of them:
We have three more coming soon:
We have more Office Visual How-Tos about Excel, Access, Excel Services, the BDC, PPT, the Fluent Ribbon extensibility, and Item-Level Auditing that will be available soon. We will start updating the MSDN Office Developer How To Center as soon as we publish them.
I love training labs because they are always great walkthroughs that show you how to get started with new features. Today I can share with you some labs that are available online.
The InfoPath team and Mark Roberts from my group worked on authoring and publishing a new set of InfoPath 2007 labs and all are now live on MSDN. All this labs walk the users through a real-life scenario, introducing them to a new InfoPath feature in the process. Here are the new labs:
I also want to share with you the URL where you can download the Microsoft 2007 Office System Redistributable Primary Interop Assemblies (PIA).
These will help you develop managed applications using the latest Office PIAs.
These will help you develop managed applications using the latest Office PIAs.
I love tools that help integrate data from SQL Server with Office programs. I just learned about a new one via JamieMac's WebLog...
Some time ago I was working as a consultant and most of my projects were related to financial services. Today I can identify a lot of business opportunities for the banking industry that you can address using different combinations of Office clients, servers, tools, and services.
Most solutions involve using MOSS for the presentation and services layer of a banking solution. The MOSS platform provides a rich application-services layer that enables many reusable services for your enterprise's SOA. These services include, but are not limited to Enterprise Content Management, Workflow, Digital Rights Management, Enterprise Search, Business Data Catalog, InfoPath Forms Services, Excel Services, and more.
The following diagram represents the conceptual architecture of a loan application solution built as an Office Business Application:
You can connect different Office programs, tools and technologies depending on what you are trying to accomplish. You can use Visual Studio Tools for Office, the Extensible UI (Fluent Ribbon and Custom Task Panes) and the Office Open XML Formats to bring together different building blocks to create a custom financial services OBA.
The loan application solution not only takes advantage of MOSS built-in features, but also integrates Outlook 2007 and Excel 2007 to build a richer presentation layer for the user. You can learn more details about this sample solution reading the Financial Services OBA article by Mike Walker.
If you are interested in learning more about OBA Financial Services, here are some other resources you might find useful.
Building Compelling Financial Applications with VSTO 2005 SE and Excel Services
Tuesday, February 20, 2007 1:00 – 2:30 PM Eastern Time (US & Canada)
With the release of 2007 Microsoft Office System clients, servers, and tools, Microsoft delivers a true application platform that can be used to create collaborative, role-based, easy-to-use solutions that extend the traditional line-of-business (LOB) applications and enterprise systems. In this webcast we will review two important building blocks of the extensibility and programmability of the 2007 Microsoft Office System: Visual Studio 2005 Tools for Office Second Edition (VSTO 2005 SE) and Microsoft Excel Services. These building blocks enable architects and developers to build a new breed of services-based, composite applications known as Office Business Applications. This session will show how you can leverage your existing skills and company's investments in Office to build compelling applications.
Just a little follow-up blog entry to let you know that the following developer references are now live on MSDN!
This is so exciting!
Patrick Tisseghem beat me to it (you are so fast man), but I thought posting three blog entries in the same day was crazy.
Today I will blog about a project that has kept us busy for a while: "The Office Visual How Tos."
We know that the internet has changed the way in which developers learn about new products, features, tools and technologies. People are learning more about Office development thanks to blogs and videos. Office development blogs are quite active and inviting for developers trying to reduce their learning curve for new enhancements added to the 2007 Microsoft Office system. Readers love short articles (1 – 3 pages) with code samples that show how to do discrete tasks such as Using Parameters In Dashboards, What About Workflow and ASPX Forms?, How To Load Win32 dlls Dynamically In VBA and the list keeps going.
On the other hand, we know videos are an excellent resource for evangelizing new technologies. Developers love to see things in action. We published some developer screencasts and the Office Developer Conference videos after Beta 2 and we got an amazing response. People enjoy this kind of content, and I don't know if you are, but I am a very visual person. Sometimes a demo says more than 10,000 words, specially if you are fast learner and have few time to explore new technologies.
So we built a v-team and created a new type of MSDN article and we named it "Visual How To."
A "Visual How To" is a new content type that combines some of the best elements of blogs, video, and technical articles by providing a brief (1-3 page) page of content. The idea is that developers have 2 minutes, 5 minutes, or 15 minutes to spend on a task. Developers can look at the code sample on the page (2 minutes), view the video (5 minutes), and explore the additional resources and other added benefits. We think this will help developers learn how to work with specific new features of different 2007 Microsoft Office system programs, servers, services, tools and technologies by providing different flavors of content to fit your learning style.
A Visual How To article includes four basic components:
Finally, Visual How Tos provide MSDN Wiki support, so you can add links to related resources or comments to these articles.
We built the first two based on most common How Do I…in Word 2007 questions and you can find them here:
I know two articles is not enough but this is only the beginning. The good news is that we have a list of dozens and dozens of this articles that we plan to build in the next couple of months. Our list includes How Do I articles about Office Open XML Formats, Word, PowerPOint, Excel, Excel Services, BDC, Search, Workflow, Project Server, Outlook, InfoPath, Access and more. Of course, I'll let you know when we start publishing the next set of Visual How Tos.
You will be able to find them at the Office Developer How To Center or at the MSDN Library listed as Visual How Tos. Also, the Office Developer How To Center is the new section of the site where we will start listing all Office 2007 How tos, even when they are not Visual How Tos.
Let us know if you like the concept and if you have suggestions for must-have Office Visual How Tos. We are really excited about this, but you have the last word!
It's our lucky day! This was supposed to happen later this week, but some of the launch surprises arrived ahead of time.
I am glad to announce that the following developer references are now live on MSDN:
By the end of this week we will publish the following ones:
We will publish the last two in the subsequent weeks:
I will be updating this blog entry as soon as we take them live.
Hey! This is a happy day for Microsoft J. Today we start celebrating the consumer release of Windows Vista and the 2007 Microsoft Office system. Bill Gates and Steve Ballmer will kickoff a celebration in New York. Details for the WebCast here:
Bill Gates Celebrates Worldwide General Availability of Windows Vista and the 2007 Microsoft Office System
January 29, 2007 - 1:45 p.m. PST / 4:45 p.m. EST
From Times Square in New York City, join Microsoft Chairman Bill Gates for a live webcast celebrating the worldwide launch of Windows Vista and the 2007 Microsoft Office System. The celebration pays tribute to the millions of Microsoft customers, partners and product testers around the world who provided input and feedback on these products -- helping Microsoft transform the way people communicate, create and share content, and access information and entertainment in the new digital age.
Last November we announced the business launch of Windows Vista, the 2007 Office system, and Exchange Server 2007 and this the happy week when we announce the consumer launch. Starting tomorrow you will be able to buy your copy of Windows Vista and the 2007 Microsoft Office system in stores. You can find pricing details for Windows Vista editions here and for Office editions here.
You can find great pointers to developer resources for Windows Vista and Office at the MSDN Developer Resources Center.
Starting today we will start publishing more developer documentation for Office 2007, so stay close to the MSDN Office Developer Center.
It all started with a few bloggers a little before Beta 2. People started blogging about the Ribbon, the cool ASP.NET 2.0 platform and WSS 3.0, Excel Services, the Office Open XML File Formats and InfoPath Forms Services. Lots of great features to build solutions using Office as a platform!
Office development blogs are quite active and inviting for developers trying to learn what's new with the Microsoft Office system and diving more into specific products and technologies. When all this started, I added RSS feeds every week to Outlook until it became just a joke to have so many bloggers added to my RSS feed. There's hundreds if not thousands of people blogging about Office development and every day new blogs are born. I built a new list of Office development bloggers and a few days before launch, my list adds up to 70!
#region /* mads's thoughts */
[XaMaLa] - Le poste de travail, un gisement de productivitÃ© encore peu exploitÃ©
A discussion of what's new in Access 2007
Andrew May's WebLog
Andy Simonds Blog
Arpan Shah's Blog
Bill Morein's Weblog
Brian Jones: Open XML Formats
Building Office Business Applications
Chris Castillo's WebLog
Chris Pratley's OneNote Blog
Chris's unofficial Office Live developer blog
Clint's Access blog
Coding for Office Small Business Accounting
Cum Grano Salis
Evil Doctor PorkChop
Fabulous Adventures In Coding
InfoPath Team Blog
Jan Tielens' Bloggings
Jensen Harris: An Office User Interface Blog
Joe Friend: Microsoft Office Word
John R. Durant's WebLog
Kevin Boske - Office Development
Larry's Project Dev Blog
Microsoft Excel 2007 (nee Excel 12)
Microsoft Office PowerPoint
Microsoft Office Project 2007
Microsoft SharePoint Products and Technologies Team Blog
Microsoft Small Business Applications
Microsoft Visual Studio Tools for the Microsoft Office System
Microsoft Visual Studio Tools for the Microsoft Office System, Version 2003
Murray Sargent: Math in Office
Office SharePoint Document Services (ECM)
On Microsoft Publisher and more
Owen Braun: OneNote 12
Pashman's InfoPath Goldmine
Patrick Smith: Office Programmability
Patrick Tisseghem's Blog [MVP SharePoint]
Project Server 201
Rob Mauceri's FrontPage Blog
Ryan's Look at Outlook Programmability
search.subscribe.share in outlook 2007
SGriffin's [MSFT] WebLog
SharePoint Content and Resources
SharePoint Products and Technologies - Pointing to Share the Knowledge
Tasks and Time Management in Outlook
The Microsoft Office Word Team's Blog
The wonder that is the Microsoft Office system
Third Of Five - just another voice in the Collective
Visio 12 - Eric Rockey
Westin's Technical Log
Windows Sharepoint Services etc.
Wouter van Vugt
When I started posting lists of bloggers someone suggested that I should build an OPML list of Office Development Bloggers, so I did. You can download the OPML file here:
You can use Outlook, Windows Live or other OPML readers to open this file and add your favorite RSS feeds.
MSDN blogs: pending to add!
How could I leave them out: Kathleen McGrath, Paul Stubbs, and the new Microsoft SharePoint Designer Team Blog
Pranav's blog: You should check this one out, I hate me for not finding Pranav's blog before: This blog is all about Office Automation, VSTO, InfoPath and other programming stuff and the thing i believe on is "Real Stuff is Out Of The Box."
Make sure you check out Rob Barker's: Where in the "OBA" am I? and his first post.
I am sure there's more blogs out there that I didn't list here. If you have an Office development blog or know of great bloggers that talk about VSTO, SharePoint, WSS or anything else related with Office, please let me know so we add them to the list. You don't need to have an MSDN or TechNet blog, you only need to be passionate about development with Office products and technologies. The list keeps growing every day.
Community blogs: pending to add!
Ricardo MagalhÃ£es - http://techtalkpt.wordpress.com
Portuguese Community of MOSS and WSS - http://mosspt.officeisp.net
Portal Integration: http://blogs.infosupport.com/porint
Adding Visio Guy: http://visguy.com/
Happy New Year 2007!
I am little late to the party (again) and in fact this is my first blog entry of the year. Things are quite busy here in Office-land. We are getting ready for launch and finalizing details on new content that we will continue to publish this year. As always, we have more surprises for you.
Some I can't tell now, but here's two I can disclose now.
We will publish finally the Developer Reference documentation and object model diagrams for the following programs:
You will be able to find them inside the Office Solutions Development node of the MSDN2 library. I will let you know when they go live.
Starting this month, Frank Rice and I will start a new Office Talk column series where we will be discussing lots of tips and tricks to develop applications with different Office products and technologies. Frank is an Office expert and an excellent programmer writer, so I am very happy to work with him on a new column series. We hope we can help answer some of the most frequently asked questions we have seen in the newsgroups.
In some more weeks I will be able to talk about the other surprises.
I also want to list some cool things posted recently in blogs and MSDN you should not miss:
The book VSTO for Mere Mortals from Kathleen McGrath and Paul Stubbs is available for customers now. If your company has tons of VBA applications, this book is the best guide ever. In my own words, "Kathleen and Paul are great technical evangelists who enjoy sharing their knowledge and passion for VSTO. With this book, VBA developers have access to a great guide that will help them understand essential concepts of managed code and best practices to migrate VBA solutions to Visual Basic 2005 and Visual Studio 2005 Tools for Office. This book goes beyond an introduction to VSTO and helps you evolve your current Office development knowledge and dive into the new world of VSTO 2005 SE and the 2007 Microsoft Office system."
Kathleen is creating a new video screencasts series that demonstrates Office development concepts as described in the book. You should visit Kathleen's blog.
Check out this great post by Frank Rice where he discusses how to work with AutoFilters and sorting from the UI and programmatically.
Have you seen the new Office Live screencast series posted by Don Campbell? He did an awesome job putting these together. View these screencasts to get ideas for exciting solutions you can develop for Office Live customers. You can find more about Office Live here.
If you have a sense of humor (I do) and want to have some fun, please watch this little comedy about Clippy. I think it's hilarious and yes, those were the days… so glad Office help has evolved J.
I have seen some great articles about the 2007 Microsoft Office System, but if you are an architect or solution developer, this is one you don't want to miss: Compliance Features in the 2007 Microsoft Office System. This paper talks about business opportunities and technical aspects of extending the 2007 Microsoft Office system features to facilitate compliance.
Joanna Bichsel wrote this paper. She is a subject matter expert and she is doing an excellent job to help customers understand how to build Office Business Applications. She runs demos in developer conferences and her blog is a must stop. She will be posting a lot of short walkthroughs for developers and architects.
I loved this paper piece of art, and the two things I liked the most are:
I know there are tons of papers, documentation, webcasts, and technical articles. But this is one you should definitely send to the printer and enjoy.
Steve Ballmer announced yesterday the business availability of Vista, Office and Exchange. This means that businesses can deploy and start developing solutions that integrate these three products. You can read the executive e-mail here and you can watch the Webcast here. In case you are wondering, the consumer launch is scheduled for 1/31/2007. Microsoft also launched the Vista + Office PowerTogether site.
So you have the products and it's always useful to find information that can help you get started. I compiled my top ten 14 list of resources for architects and solution developers that plan to start building solutions using the 2007 Microsoft Office system (including SharePoint of course) and VSTO.
Overwhelming? Yes, can be a lot of information if you are just entering the Office development zone. But once you start diving every site and hunting for resources you'll see it's not enough. We still have lots of code samples to build and technical articles to write. Lots of fun stuff is still scheduled in our queue.
Just some random thoughts before I go on vacation, stay a week OOF without my laptop, and try not to think about the things I didn't finish before I leave.
We fixed a typo and added required EULA information to the download page. We republished the three Office development posters as pdf files:
The download family page is still the same:
A lot of people complained about the packaging and we are commited to make you happy.
Office Live is ready to rock:
This week we launched the new release of Office Live. Check out the CNBC news story and the Office Live site. Office Live provides a platform for developers to create a wide range of online business solutions for small businesses including hosted Web sites and collaborative applications. You can explore developer resources that will help you create your custom online solutions at the Office Live Developer Portal.
Office 2007 is now available to MSDN Subscribers!
As an MSDN subscriber, you can download the final version of Office 2007 and begin building your applications today. If you are an MSDN subscriber, you can download the final version here.
See you in a week,
We are in the process of migrating the Office Developer Center and all the MSDN Library Office developer content to MSDN2! I love to blog about anything related to Office development, but this time I will share with you some information related with MSDN that you might find interesting.
What is MTPS and MSDN2?
Tim Ewald, Kim Wolk and Craig Andera are the principal architects behind a new online delivery and rendering infrastructure better known as MSDN/TechNet Publishing System (MTPS). This new platform supports MSDN2 and the alpha version was released to customers on September 2004. The MSDN Library was the first to use the new system.
MSDN provides two major venues for developer content. The MSDN Library allows users to browse developer content for all Microsoft products and technologies that have a developer story. It contains technical articles, reference documentation, and sample code, and organizes nodes in a new treeview navigation that avoids the use of frames and reflects the current page URLS's. On the other hand, MSDN Developer Centers pull together content and resources around specific products and technologies. They connect developers with code samples, community sites, technical articles and documentation, upcoming events, and much more. The MSDN Office Developer Center (ODC) provides a road map to help developers understand and work with Office System programs, servers, services, tools, and technologies. The MSDN Library and some MSDN Developer Centers have been migrated to MSDN2.
Some of the key benefits offered by MSDN2 are:
And there are more benefits such as alternates, revisions, and versions. I strongly recommend you to read Tim Ewald's article Designing URLs for MSDN2 if you want to learn more about MSDN2 URL improvements. Read also Craig Andera's MSDN article: Consuming MSDN Web Services.
We are migrating!
The MSDN Office Developer Center team has been working for the past few months on migrating all Office MSDN Library content and the MSDN Office Developer Center to MSDN2. The volume of technical content assets and ODC pages for Office were a great challenge for us, and I am pleased to say that we are almost done. The new MSDN2 Office Developer Center went live a few minutes ago! I have to warn you though; we are still migrating, so in the next couple of weeks you may find some broken links on some ODC pages. We published all Office 2007 articles and content on MSDN2, but had to migrate all the Office 2003, Office XP, and Office 2000 developer content to the MSDN2 servers. We are still working on updating ODC links for these versions and things may be a little flaky for a couple of weeks but hopefully will be fixed soon. Just as I write this blog entry, MSDN is loading redirects from our old pages to the new site. While we conclude our migration process, you can find all Office Solutions Development technical content on the MSDN Library and I encourage you to see how cool our new MSDN Office Developer Center looks like.
MSDN Office Developer Top Pages
The following table shows new URLs for some of our most viewed pages in case you are wondering what happened to them.
I am also attaching a spreadsheet with all our new URLs in case you get lost. Please feel free to send me comments if you can't find content; I will be glad to help you find your way.
Jim Alchin says it's time! More info about the press release coming soon. In the meantime, every developer should download the .NET Framework 3.0 and start having fun!
Congratulations to the Windows Division.
In case you haven't heard the news, Microsoft announced today the 2007 Microsoft Office system release to manufacture. In terms of scope, this is the most significant release for Office since Office 95 and everyone who made this possible celebrated last Friday at our RTM party. There's a lot of people who made this possible (including beta testers and TAP customers) and we are quite satisfied with the outcome. To me it has been amazing to be part of this change and learn from all MVPs and early adopters that are already building applications with Office 2007.
In case you:
Office evolved from a set of programs to a complete family of products and technologies. Today you can extend Office and add functionality and make it be a front-end for your business applications. If you want to extend Office 2007, you must consider exploring the new Visual Studio Tools for Office Second Edition release to the web announced today!
Read more here:
Just to be a little philosophical and to make this blog entry a little more emotional than informative. I just think sometimes human beings lose their capacity to be surprised with things. We take for granted stuff that makes our life easier and sometimes we don't stop to think of how amazing things are and the work it takes to build them. I think Office has changed the World in terms of software and it continues to change the World and the way we all work. I just want to say congratulations and thank you to all the people who made this possible. Office 2007 is brilliant.
This is an absolute MUST SEE. You should visit the new redesigned Office Online site! http://www.office.microsoft.com
The site has a new information architecture and a very cool Ribbon-like UI. It also provides personalization and tons of how-to topics to help you work with all Office versions. I love their tabs!
Congrats to the Office Online team, the site is absolutely awesome!
A couple of weeks ago I blogged about the treasure map for Office developers that we were building and I am glad to announce that we finished two weeks ago the poster version and it's ready to download! This is the third poster of the 2007 Office System Document: Developer Posters download family.
The Developer Map for the 2007 Microsoft Office system helps developers visualize the different programs, servers, services and tools that will help them build solutions. You can drill down to each product and technology and learn about new features, objects, Web services, namespaces and schemas requiered to extend Office. There are more than 50 persons who worked to make this possible with the motivation of building a cool tool to evangelize Office. Based on the fact that Office 2007 is more than you think, we thought this was a great way to help developers understand the bigger picture and learn how Office products and technologies relate to each other.
The goals of this poster are:
BTW, if you have plans to attend Dev Connections in Las Vegas or Tech Ed Barcelona, you should visit the Office booths. We are sending nicely printed copies of this poster. I encourage you to get one (or more) b/c there's a lot of text and it looks better if you print it on a bigger piece of paper.
I can't describe how happy I am because of this poster. I enjoyed working with all the people who made this possible, but what makes me happier is that I know this will help other developers understand quickly what took me months to figure out.
Cheers to Office and the whole galaxy of developer technologies it represents!