How to export a list of recently opened files from Office:MAC? 2011?

I recently inherited some old mac machines and was told to look for anything important on the before formatting them.

One of the things that is installed on these machines is Office:MAC 2011, and everytime I open one of these documents I'm concerned that another falls off the recently opened list.

I'd like to save the list of recent files some how so that I don't loose anymore recently opened documents.

Is it possible to somehow export this list so I can view the list without destroying the list?

Solution 1:

You can do this, but it's complicated.

The recent documents for all Microsoft office products are stored in a preferences file (plist) in each users's library:

~/Library/Preferences/com.microsoft.office.plist

This file is in standard plist format, and can be viewed using the plist viewer built into Xcode. If you open it up it will look something like this:

The list of recent items for each application is stored in the key File MRU. The example above is for Word, which corresponds to the MSWD code. Each document compromises one numbered item under this plist key.

As you can see, unfortunately the values for these keys are binary encoded, not plain text, so you need to paste the Value strings into a Hex editor to see the file names and paths. (I use HexFiend .)

Bottom Line: Copy the com.microsoft.office.plist file to a safe location. With some elbow grease, you can pull all the recent files out of this document.

You could also check out this Python script that does some of this parsing automatically, but your mileage may vary.

Solution 2:

The location of the property list with the recently opened files has changed since BringMyCakeBack's answer was posted. They are now kept in ~/Containers/com.microsoft.Word/Data/Library/Preferences/com.microsoft.Word.securebookmarks.plist. The file is in a binary format that Xcode understands. See also here.