Export Excel.officeUI to multiple users

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:

Capture.PNG

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.

I agree but could be difficult for a beginner …

Thanks for the Responses guys. I would try and recreate the addins. it would be my first time trying to build one but Im sure I could find tons of resources online. Would keep you posted.