|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Customized Ribbon update macro locations when transfer Personal.xls file to different location
Hi there
Consider my Source_Laptop. I have many macros defined located in many different modules. The personal.xls file is located at Source_Laptop_Folder_Loc. I copy the personal.xls file from my Source_Laptop to my Dest_Laptop. The proper location of the personal.xls on my Dest_Laptop is DIFFERENT to that of my Source_Laptop. This is because my windows account name is different. Is there any way to edit the file location in my ribbon for all macro entries? Something along the lines of FIND field = shaun REPLACE field = shaun.louw As I write this I think to myself, I wonder if I can do that in the Excel Customizations Target.exportedUI file I exported from Source_Laptop and imported into Dest_Laptop? So I open Excel Customizations Target.exportedUI with a text editor and voila there is an XML like text file. I do precisely the find and replace above (128 repalcements. Imagine doing that all by hand) Import the Excel Customizations Target.exportedUI into Dest_Laptop and... it seems I am good! Hope this helps someone |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Update date once and have it appear in numerous locations | Mattress14 | PowerPoint | 2 | 09-05-2016 03:30 PM |
How to transfer/import a customized color theme created on another computer | JPB | PowerPoint | 7 | 11-20-2014 06:54 AM |
How to import the customized ribbon to Word without overwriting the existing Ribbon? | SharonSh | Word VBA | 0 | 09-26-2013 11:47 PM |
customized ribbon in Excel 2007 | jd1 | Excel Programming | 0 | 10-19-2012 11:37 PM |
Personal Folders transfer | antonstef | Outlook | 1 | 07-13-2010 01:12 PM |