I have made a custom ribbon tab and would like to distribute this to several computers. I am able to get it installed but the process seems rather ridiculous unless I am missing something. I was wondering if anyone has a good system for this.
The xlam file is no problem and neither is exporting the custom UI file and importing it. However the issue that occurs is when you export the UI file it retains the macro paths from the computer you exported it from. For example the exported UI file will show C:\_users_"username of the person who exported". When you import this UI file it still retains the exporting PCs path which means none of the macros will run. I have to search and replace the UI file with the new persons name and then import it. I suppose I can try the "all users" approach but that seems like its the same brute force approach.
Any ideas on how to make distributing this easier? This ribbon will be revised frequently as I add functionality and this seems like there is something I am missing.
Any ideas?
The xlam file is no problem and neither is exporting the custom UI file and importing it. However the issue that occurs is when you export the UI file it retains the macro paths from the computer you exported it from. For example the exported UI file will show C:\_users_"username of the person who exported". When you import this UI file it still retains the exporting PCs path which means none of the macros will run. I have to search and replace the UI file with the new persons name and then import it. I suppose I can try the "all users" approach but that seems like its the same brute force approach.
Any ideas on how to make distributing this easier? This ribbon will be revised frequently as I add functionality and this seems like there is something I am missing.
Any ideas?
