Scripting Question

How to Update Office File Format from 2007 to 2010

07/18/2013 2813 views


I've been given a task where I need to update the file format for 600+ copies of Microsoft Office 2010. See when we created and deployed it, they refused to update to the new 2010 file format (.docx, .xlsx, etc). But now after a few years they're needing to go to the new 2010 format. The only issue is that I'm not sure how to make such a change on a wide scale. Doing it from the program is easy enough, but that's not really practical for 600+ users.

I was curious if anyone knew if there was a registry key I could use to make the change, or if it really is an xml document somewhere that I have to update. I'm hoping somebody else had this issue, even if it was going from 2010 to 2007 reversing the order should work.

Thanks in advance!

Answer Summary:
I ended up finding the Office 2010 Administrative Template that allows me to control all the settings of the Office 2010 suite. You can check out more here: https://www.microsoft.com/en-us/download/details.aspx?id=18968 - 2010 ADM Templates http://www.mydigitallife.info/change-office-2007-default-file-save-formats-and-extensions-using-group-policy-gpo/ - How to guide for 2007, comparable to 2010 http://support.microsoft.com/kb/816662 - How to use ADM files if you don't already know.
0 Comments   [ + ] Show comments


Community Chosen Answer


If they all are iin a domain you can use a GPO to set these



Answered 07/18/2013 by: SMal.tmcc
Red Belt

All Answers


I've found the way to change word to .docx, running via vbs:

Set objWord = CreateObject("Word.Application")
objWord.DefaultSaveFormat = "docx"

The only issue is that fails when duplicated with excel or powerpoint. I'm still doing some research on those. The error I'm getting is "Type Mismatch: 'objExcel.DefaultSaveFormat' I've tried xlsx and xlExcel12 as the format to no avail.

Answered 07/18/2013 by: samzeeco
10th Degree Black Belt

  • Ah! You were expecting consistency between apps from the same vendor. You clearly haven't been doing this job long!! Ha, ha, ha! Jeez, MS can't even make Excel save backups the same way Word does!!

    Use an object explorer to find out what the app's objects, methods and properties are. The "cheapest" way to do that is open the VBA Editor in any Office app (Alt+F11) then hit F2 to get the Object Browser. Add the required AppID to the "project" and browse away.
    • Haha no kidding. I actually ended up finding Office 2010 Administrative templates that allow me to control all the options for Office 2010. I'm just going to use that. Thanks though!
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ