{"id":35,"date":"2008-08-04T17:45:50","date_gmt":"2008-08-04T08:45:50","guid":{"rendered":"http:\/\/www.jhouseconsulting.com\/index.php\/jhouseconsulting\/2008\/08\/04\/managing-ms-office-2007-quick-access-toolbars-with-roaming-profiles\/"},"modified":"2008-10-21T01:18:13","modified_gmt":"2008-10-20T16:18:13","slug":"managing-ms-office-2007-quick-access-toolbars-with-roaming-profiles","status":"publish","type":"post","link":"https:\/\/www.jhouseconsulting.com\/jhouseconsulting\/2008\/08\/04\/managing-ms-office-2007-quick-access-toolbars-with-roaming-profiles-35","title":{"rendered":"Managing MS Office 2007 Quick Access Toolbar(s) with Roaming Profiles"},"content":{"rendered":"

Hmmm…why oh why would Microsoft place the Office 2007 Quick Access Toolbar (.qat) files in the “%userprofile%\\Local Settings<\/strong>\\Application Data\\Microsoft\\Office” folder rather than the “%appdata%\\Microsoft\\Office” folder??? The “Local Settings” folder does not roam, nor would you want it to, so I don’t understand their thought process behind this one.\u00a0The only real workaround is to use logon and logoff scripts to copy them into place. Refer to Microsoft Technet article KB926805<\/a> for further information.<\/p>\n

Here are the scripts I have successfully used from a Group Policy Object (GPO) that copies these files to and from\u00a0the users home (H:) drive. I don’t usually usually hard code the homedrive\u00a0letter in scripts, and would have preffered to have used variables such as %HOMEDRIVE%%HOMEPATH%, but I didn’t have this luxury because it was in a Novell environment, and these variables are not automatically set to the correct places.<\/p>\n

LoadQAT.cmd<\/p>\n

\r\n@echo off\r\n:: This script should be used as a logon script to copy the MS Office 2007 Quick Access Toolbar (.qat)\r\n:: files to the users profile.\r\n:: Access 2007\u00a0\u00a0-\u00a0Access.qat\r\n:: Excel 2007\u00a0\u00a0-\u00a0Excel.qat\r\n:: Outlook 2007\u00a0\u00a0-\u00a0Olkaddritem.qat, Olkapptitem.qat, Olkdistitem.qat, Olklogitem.qat\r\n::\u00a0\u00a0\u00a0\u00a0Olkmailitem.qat, Olkpostitem.qat, Olktaskitem.qat\r\n:: PowerPoint 2007\u00a0-\u00a0PowerPoint.qat\r\n:: Word 2007\u00a0\u00a0-\u00a0Word.qat\r\n\r\n:: Written by Jeremy@jhouseconsulting.com on 4th August 2008.\r\n\r\n:: Modified by Jeremy@jhouseconsulting.com on 26th August 2008.\r\n:: We needed to use a direct UNC path because the H: drive was not presented in time by the Novell logon script.\r\n:: I also added a loop that to ensure the destination folder exists before the copy takes place.\r\n\r\nSetLocal\r\n\r\nEcho This is the LoadQAT Logfile for %username% >\"%TEMP%\\LoadQAT.log\"\r\n\r\n::IF NOT EXIST H:\\NUL GOTO :END\r\nIF NOT EXIST \"\\\\Netncs_flpool01\\Flvol01\\Users\\%username%\" GOTO :END\r\n\r\n::SET Office2007QuickAccessToolbarLocation=H:\\System\\MSOfficeQATFiles\r\nSET Office2007QuickAccessToolbarLocation=\\\\Netncs_flpool01\\Flvol01\\Users\\%username%\\System\\MSOfficeQATFiles\r\nSET DefaultLocation=%USERPROFILE%\\Local Settings\\Application Data\\Microsoft\\Office\r\n\r\nIF NOT EXIST \"%Office2007QuickAccessToolbarLocation%\" MD \"%Office2007QuickAccessToolbarLocation%\" >>\"%TEMP%\\LoadQAT.log\"\r\n\r\n:TestFolder\r\nIF NOT EXIST \"%DefaultLocation%\" GOTO CreateFolder\r\n\r\nxcopy\u00a0\/Y \"%Office2007QuickAccessToolbarLocation%\\*.qat\" \"%DefaultLocation%\\\" >>\"%TEMP%\\LoadQAT.log\"\r\n\r\n:END\r\nEndLocal\r\nExit \/b\r\n\r\n:CreateFolder\r\nMD \"%DefaultLocation%\" >>\"%TEMP%\\LoadQAT.log\"\r\nGOTO TestFolder\r\n<\/pre>\n
SaveQAT.cmd<\/p>\n
\r\n@echo off\r\n:: This script should be used as a logoff script to copy the MS Office 2007 Quick Access Toolbar (.qat)\r\n:: files to the users home drive.\r\n:: Access 2007\u00a0\u00a0-\u00a0Access.qat\r\n:: Excel 2007\u00a0\u00a0-\u00a0Excel.qat\r\n:: Outlook 2007\u00a0\u00a0-\u00a0Olkaddritem.qat, Olkapptitem.qat, Olkdistitem.qat, Olklogitem.qat\r\n::\u00a0\u00a0\u00a0\u00a0Olkmailitem.qat, Olkpostitem.qat, Olktaskitem.qat\r\n:: PowerPoint 2007\u00a0-\u00a0PowerPoint.qat\r\n:: Word 2007\u00a0\u00a0-\u00a0Word.qat\r\n\r\n:: Written by Jeremy@jhouseconsulting.com on 4th August 2008.\r\n\r\nSetLocal\r\n\r\nEcho This is the SaveQAT Logfile for %username% >\"%TEMP%\\SaveQAT.log\"\r\n\r\nIF NOT EXIST H:\\NUL GOTO :END\r\n\r\nSET Office2007QuickAccessToolbarLocation=H:\\System\\MSOfficeQATFiles\r\nSET DefaultLocation=%USERPROFILE%\\Local Settings\\Application Data\\Microsoft\\Office\r\n\r\nIF NOT EXIST \"%Office2007QuickAccessToolbarLocation%\" MD \"%Office2007QuickAccessToolbarLocation%\" >>\"%TEMP%\\SaveQAT.log\"\r\n\r\nxcopy \/Y \"%DefaultLocation%\\*.qat\" \"%Office2007QuickAccessToolbarLocation%\\\" >>\"%TEMP%\\SaveQAT.log\"\r\n\r\n:END\r\nEndLocal\r\nExit \/b\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
Hmmm…why oh why would Microsoft place the Office 2007 Quick Access Toolbar (.qat) files in the “%userprofile%\\Local Settings\\Application Data\\Microsoft\\Office” folder rather than the “%appdata%\\Microsoft\\Office” folder??? The “Local Settings” folder does not roam, nor would you want it to, so I don’t understand their thought process behind this one.\u00a0The only real workaround is to use logon … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[56,5],"tags":[49,51,50,52],"class_list":["post-35","post","type-post","status-publish","format-standard","hentry","category-ms-office","category-scripting","tag-office-2007-quick-access-toolbar","tag-qat","tag-quick-access-toolbar","tag-roaming-profile"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t