Like this:

There are a few ways to integrate MS Office 2007 and SharePoint 2007. This first method uses the group policy editor to manually input locations that will show up in My Places bar in your Office applications.

This approach seems to be a little disconnected from the SharePoint environment but does work. I only tested this on a local machine group policy. I will test it on the domain controller to see if I can force it out to all desktops.

First, you need to get the Office Resource Kit or the Office12.adm file. This link will take you to the download for the administrative templates which includes the above mentioned file.

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

Download the file and extract to a location on your PC. You’ll find the file in the C:\..\ADM\en-us\ folder (English US version). Copy this file to your C:\Windows\INF directory. Now open the group policy editor, gpedit.msc from a command line. Either use the Start -> Run -> gpedit.msc or from a command prompt by typing gpedit.msc.

1. Right click Administrative Templates under the User Configuration and click Add/Remove Templates…
2. Click Add…
3. It should open in your C:\Windows\INF directory. If not, browse to it and select the file Office12.adm and click Open.
4. Click Close
5. Expand Administrative Templates and expand Microsoft Office 2007 system.
6. Expand File Open/Save dialog box and select Places Bar Locations.
7. You’ll see 10 items labeled Places Bar Locations 1, 2, 3…
8. Double click or right click and select properties.
9. Enable it, enter a logical name for the location and paste the link for the SharePoint site.  Do not add the default.aspx file in the link.
10. Click OK and close Group Policy Editor.
11. Open Word or Excel and select the Office Icon, Select Open and you should see the new location in the My Places Bar.

I will continue testing for more dynamic ways to update this information. I know it’s available through audience targeting but I haven’t tackled that yet.

Hopes this helps someone.

Jon

Advertisement