How to Update Office File Format from 2007 to 2010
Greetings,
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!
Answers (2)
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.
If they all are iin a domain you can use a GPO to set these
http://technet.microsoft.com/en-us/library/dd723552(v=office.14).aspx
I've found the way to change word to .docx, running via vbs:
Set objWord = CreateObject("Word.Application")
objWord.DefaultSaveFormat = "docx"
objWord.Quit
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.
Comments:
-
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. - anonymous_9363 10 years ago-
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! - samzeeco 10 years ago