{"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":"<p>Hmmm&#8230;why oh why would Microsoft place the Office 2007 Quick Access Toolbar (.qat) files in the &#8220;%userprofile%\\<strong>Local Settings<\/strong>\\Application Data\\Microsoft\\Office&#8221; folder rather than the &#8220;%appdata%\\Microsoft\\Office&#8221; folder??? The &#8220;Local Settings&#8221; folder does not roam, nor would you want it to, so I don&#8217;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 <a target=\"_blank\" href=\"http:\/\/support.microsoft.com\/kb\/926805\">KB926805<\/a> for further information.<!--more--><\/p>\n<p>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&#8217;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&#8217;t have this luxury because it was in a Novell environment, and these variables are not automatically set to the correct places.<\/p>\n<p>LoadQAT.cmd<\/p>\n<pre name=\"code\" class=\"vb.net\">\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% &gt;\"%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%\" &gt;&gt;\"%TEMP%\\LoadQAT.log\"\r\n\r\n:TestFolder\r\nIF NOT EXIST \"%DefaultLocation%\" GOTO CreateFolder\r\n\r\nxcopy\u00a0\/Y \"%Office2007QuickAccessToolbarLocation%\\*.qat\" \"%DefaultLocation%\\\" &gt;&gt;\"%TEMP%\\LoadQAT.log\"\r\n\r\n:END\r\nEndLocal\r\nExit \/b\r\n\r\n:CreateFolder\r\nMD \"%DefaultLocation%\" &gt;&gt;\"%TEMP%\\LoadQAT.log\"\r\nGOTO TestFolder\r\n<\/pre>\n<p>SaveQAT.cmd<\/p>\n<pre name=\"code\" class=\"vb.net\">\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% &gt;\"%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%\" &gt;&gt;\"%TEMP%\\SaveQAT.log\"\r\n\r\nxcopy \/Y \"%DefaultLocation%\\*.qat\" \"%Office2007QuickAccessToolbarLocation%\\\" &gt;&gt;\"%TEMP%\\SaveQAT.log\"\r\n\r\n:END\r\nEndLocal\r\nExit \/b\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Hmmm&#8230;why oh why would Microsoft place the Office 2007 Quick Access Toolbar (.qat) files in the &#8220;%userprofile%\\Local Settings\\Application Data\\Microsoft\\Office&#8221; folder rather than the &#8220;%appdata%\\Microsoft\\Office&#8221; folder??? The &#8220;Local Settings&#8221; folder does not roam, nor would you want it to, so I don&#8217;t understand their thought process behind this one.\u00a0The only real workaround is to use logon &#8230; <a title=\"Managing MS Office 2007 Quick Access Toolbar(s) with Roaming Profiles\" class=\"read-more\" href=\"https:\/\/www.jhouseconsulting.com\/jhouseconsulting\/2008\/08\/04\/managing-ms-office-2007-quick-access-toolbars-with-roaming-profiles-35\" aria-label=\"Read more about Managing MS Office 2007 Quick Access Toolbar(s) with Roaming Profiles\">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":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.jhouseconsulting.com\/jhouseconsulting\/wp-json\/wp\/v2\/posts\/35","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.jhouseconsulting.com\/jhouseconsulting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.jhouseconsulting.com\/jhouseconsulting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.jhouseconsulting.com\/jhouseconsulting\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.jhouseconsulting.com\/jhouseconsulting\/wp-json\/wp\/v2\/comments?post=35"}],"version-history":[{"count":2,"href":"https:\/\/www.jhouseconsulting.com\/jhouseconsulting\/wp-json\/wp\/v2\/posts\/35\/revisions"}],"predecessor-version":[{"id":59,"href":"https:\/\/www.jhouseconsulting.com\/jhouseconsulting\/wp-json\/wp\/v2\/posts\/35\/revisions\/59"}],"wp:attachment":[{"href":"https:\/\/www.jhouseconsulting.com\/jhouseconsulting\/wp-json\/wp\/v2\/media?parent=35"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.jhouseconsulting.com\/jhouseconsulting\/wp-json\/wp\/v2\/categories?post=35"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.jhouseconsulting.com\/jhouseconsulting\/wp-json\/wp\/v2\/tags?post=35"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}