Good Day all,
Recently one of our users created a number of Macros in which she placed on two customized tabs for Excel 2010. Later, as the administrator I was asked to add the customized tabs to 72 other users. I have very limited experience with either VBA or XML so I simply copied her Personal.XLSB to my %appdata%\Roaming\Microsoft\Excel\XLSTART\ Folder and her Excel14.xlb to my %appdata%\Roaming\Microsoft\Excel\ Folder.
I then discovered that although the macros were available in my Excel, the customized tabs did not copy. I recreated the Tabs which were saved to C:\Users\mdurham\AppData\Local\Microsoft\Office\Excel.officeUI on my computer.
I then created a batch file which would copy the Personal.xlsb, Excel14.xlb and Excel.officeUI to the respective user folders when they ran it.
When I opened excel on one of the computer the custom tabs showed up but when I clicked on one of the macros I got the following message stating that it was still trying to access the macros from my computer:
I checked the Excel.officeUI file and noticed it was still referencing my user profile on the other computer.
Is there any way I can modify this file or the Personal.xlsb file to be used on multiple user computers? Any help would be most appreciated and most info would be provided if needed.
Recently one of our users created a number of Macros in which she placed on two customized tabs for Excel 2010. Later, as the administrator I was asked to add the customized tabs to 72 other users. I have very limited experience with either VBA or XML so I simply copied her Personal.XLSB to my %appdata%\Roaming\Microsoft\Excel\XLSTART\ Folder and her Excel14.xlb to my %appdata%\Roaming\Microsoft\Excel\ Folder.
I then discovered that although the macros were available in my Excel, the customized tabs did not copy. I recreated the Tabs which were saved to C:\Users\mdurham\AppData\Local\Microsoft\Office\Excel.officeUI on my computer.
I then created a batch file which would copy the Personal.xlsb, Excel14.xlb and Excel.officeUI to the respective user folders when they ran it.
When I opened excel on one of the computer the custom tabs showed up but when I clicked on one of the macros I got the following message stating that it was still trying to access the macros from my computer:
I checked the Excel.officeUI file and noticed it was still referencing my user profile on the other computer.
Is there any way I can modify this file or the Personal.xlsb file to be used on multiple user computers? Any help would be most appreciated and most info would be provided if needed.
