Office 2007 Service Pack 2 Download and Improvements for Developers

Office 2007 Service Pack 2 Download and Improvements for Developers

Erika Ehrli Cabral

29 Apr 2009 11:45 AM

Comments 7

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:

Leave a Comment

Name
Comment
Please add 6 and 5 and type the answer here:
Post

Comments

Office 2007 Service Pack 2 Download and Improvements for Developers | ASP NET Hosting

29 Apr 2009 3:29 PM

PingBack from http://asp-net-hosting.simplynetdev.com/office-2007-service-pack-2-download-and-improvements-for-developers/
Ron de Bruin

6 May 2009 4:44 PM

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
Laughing John

12 May 2009 12:29 PM

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
Ron de Bruin

12 May 2009 3:49 PM

Here is the code part

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

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

14 May 2009 8:49 AM

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
Ron de Bruin

14 May 2009 10:50 AM

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.
Erika Ehrli Cabral

14 May 2009 3:15 PM

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