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

Office 2007 Service Pack 2 Download and Improvements for Developers

Office 2007 Service Pack 2 Download and Improvements for Developers

  • Comments 7
dd490655.DeskApps(en-us,MSDN.10)[1] The Office 2007 SP2 is available now for download: http://www.microsoft.com/downloads/details.aspx?familyid=B444BF18-79EA-46C6-8A81-9DB49B4AB6E5&displaylang=en

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: http://www.rondebruin.nl/pdf.htm

    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
Leave a Comment
  • Please add 4 and 4 and type the answer here:
  • Post
  • PingBack from http://asp-net-hosting.simplynetdev.com/office-2007-service-pack-2-download-and-improvements-for-developers/

  • Hi Erika

    I have VBA page with code to save and mail as PDF for Excel on my site.

    http://www.rondebruin.nl/pdf.htm

  • Hi Erika,

    Is there a simple way to check whether the "Save As PDF" option is available.

    At the moment I check to see if the addin is installed, but I guess now I'm also going to need to check the word version.

    Is that the correct way to do it or is there a better way?

    Thanks

    LJ

  • Here is the code part

    If Dir(Environ("commonprogramfiles") & "\Microsoft Shared\OFFICE" _

            & Format(Val(Application.Version), "00") & "\EXP_PDF.DLL") <> "" Then

  • Ron,

    Thanks for that. I do already have working code that does the trick, but in a much more convoluted way than your suggestion (I currently assume it's installed if the word version is greater than or equal to the 2007 SP2 version and check the uninstall list from the registry for the "PDF" or "PDF & XPS" addins).

    Your way or mine still seems a bit of a hack to me - it would be nice if there was some easy way to tell in the word object model or failing that what Microsoft's recommended method would be.

    LJ

  • Hi John

    I think my code line is easy and I not think MS will add this to the object model.

    But maybe I am wrong (not the first time <g>)

    I create my test line in the 2007 beta and the MS people not have a better suggestion on that moment to test it.

  • Ron! Thanks for the pointer to your sample. I updated my blog entry and posted a link.

    John, Ron's solution should work. You can also experiment with the following vbs script:

    Set oWI = CreateObject("WindowsInstaller.Installer")

    For Each prod In oWI.Products

       If UCase(Right(prod, 7)) = "0FF1CE}" Then _

               sOutput = sOutput & prod & vbTab & _

                                 oWI.ProductInfo(prod, "VersionString") & vbTab & _

                                 oWI.ProductInfo(prod, "ProductName") & vbCrLf

    Next

    wscript.echo sOutput

    This scripts helps you determine the version of an installed 2007 Office language pack.

    This is the info you should get if you have the Microsoft Save as PDF or XPS Add-in for 2007 Microsoft Office programs installed:

    {90120000-00B2-0409-0000-0000000FF1CE}  12.0.4518.1014  Microsoft Save as PDF or

    XPS Add-in for 2007 Microsoft Office programs

    More info here:

    http://support.microsoft.com/kb/945598

Page 1 of 1 (7 items)