Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-19-2023, 08:22 PM
slouw slouw is offline Customized Ribbon update macro locations when transfer Personal.xls file to different location Windows 7 64bit Customized Ribbon update macro locations when transfer Personal.xls file to different location Office 2010 64bit
Novice
Customized Ribbon update macro locations when transfer Personal.xls file to different location
 
Join Date: Mar 2016
Posts: 4
slouw is on a distinguished road
Default 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
Attached Images
File Type: png 2023-04-20 13h13m29 FIND and REPLACE.png (162.6 KB, 6 views)
Reply With Quote
Reply

Thread Tools
Display Modes


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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft