+ Reply to Thread
Results 1 to 5 of 5

Export Excel.officeUI to multiple users

  1. #1
    Registered User
    Join Date
    10-01-2014
    Location
    canada
    MS-Off Ver
    2010
    Posts
    2

    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.

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    5,898

    Re: Export Excel.officeUI to multiple users


    Hi,

    amend the source folder to a common one on every PC, for example C:\Users\ …
    Last edited by Marc L; 10-06-2014 at 02:51 AM. Reason: typo …

  3. #3
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Export Excel.officeUI to multiple users

    Make an add-in and do it properly: http://www.rondebruin.nl/win/s2/win001.htm
    It will be much easier in the long run, believe me.
    Remember what the dormouse said
    Feed your head

  4. #4
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    5,898

    Re: Export Excel.officeUI to multiple users


    I agree but could be difficult for a beginner …

  5. #5
    Registered User
    Join Date
    10-01-2014
    Location
    canada
    MS-Off Ver
    2010
    Posts
    2

    Re: Export Excel.officeUI to multiple users

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 10-13-2021, 01:03 AM
  2. Macro to Export and Save as PDF - MAC and PC USERS
    By TruBeast in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-12-2013, 11:37 PM
  3. Inputting data from multiple instances from multiple users into a main Excel Workbook
    By smooth_beaker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2013, 12:18 AM
  4. Multiple Users to Use Excel
    By JezLisle in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-14-2009, 05:28 PM
  5. Need to export file name to users sheet to the next row
    By Brad in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-29-2005, 05:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1