Unable to find reg key for MS-Excel setting
Hi There,
I've been working all day now to package MS-Office 2003 Pro Dutch.
With the ORK that shouldn't be so hard but the Profile Wizard only saved MS-Word Settings it seems. My MS-Access and MS-Excel settings were gone after installation.
Luckily I was able to set all but one settings in the Custom Installation Wizard.
There is, however, one setting I'm unable to do.
I want to set the following:
In MS-Excel 2003 : Tools => Customize => Show standard and formatting toolbars on two rows
(In Dutch the setting says to do the opposite (Standaard en opmaakwerkbalk weergeven in één rij; show them on one row. But it works the same so the Dutch version does the opposite from what it says. It's default is off in both versions).
I tried a Wise snapshot, I exported HKLM\Software\Microsoft\Office, HKCU\Software\Microsoft\Office, HKLM\Software\Microsoft\VBA and HKCU\Software\Microsoft\VBA from the registry and tried if that would change the setting (when I first changed it by hand ofcourse), I used RegMon and FileMon, I browsed the Internet but I can't find it.
If I knew what to set I could easily add it to the MST but I really can't find it.
Can anybody please help me out?
Thanks in advance.
Marcel
I've been working all day now to package MS-Office 2003 Pro Dutch.
With the ORK that shouldn't be so hard but the Profile Wizard only saved MS-Word Settings it seems. My MS-Access and MS-Excel settings were gone after installation.
Luckily I was able to set all but one settings in the Custom Installation Wizard.
There is, however, one setting I'm unable to do.
I want to set the following:
(In Dutch the setting says to do the opposite (Standaard en opmaakwerkbalk weergeven in één rij; show them on one row. But it works the same so the Dutch version does the opposite from what it says. It's default is off in both versions).
I tried a Wise snapshot, I exported HKLM\Software\Microsoft\Office, HKCU\Software\Microsoft\Office, HKLM\Software\Microsoft\VBA and HKCU\Software\Microsoft\VBA from the registry and tried if that would change the setting (when I first changed it by hand ofcourse), I used RegMon and FileMon, I browsed the Internet but I can't find it.
If I knew what to set I could easily add it to the MST but I really can't find it.
Can anybody please help me out?
Thanks in advance.
Marcel
0 Comments
[ + ] Show comments
Answers (8)
Please log in to answer
Posted by:
dj_xest
19 years ago
Hi ZhuBaJie,
Since you are familiar with ORK tools, I believe you also have knowledge about using the Custom Maintenance Wizard (CMW)? This is very great for updating the features installed with MS Office. YOu can try this if you're getting tired with the Custom Installation Wizard (MST). Here is what you should do:
1. Install your MS Office 2003 to default settings.
2. Customize your MS 2003 settings using Custom Maintenance Wizard so that you can have the CMW file that you can use.
3. Apply this to the machine.
4. Verify the changes that you want.
5. If successful, send me beers.. [;)]
Since you are familiar with ORK tools, I believe you also have knowledge about using the Custom Maintenance Wizard (CMW)? This is very great for updating the features installed with MS Office. YOu can try this if you're getting tired with the Custom Installation Wizard (MST). Here is what you should do:
1. Install your MS Office 2003 to default settings.
2. Customize your MS 2003 settings using Custom Maintenance Wizard so that you can have the CMW file that you can use.
3. Apply this to the machine.
4. Verify the changes that you want.
5. If successful, send me beers.. [;)]
Posted by:
ZhuBaJie
19 years ago
ORIGINAL: dj_xest
Hi ZhuBaJie,
Since you are familiar with ORK tools, I believe you also have knowledge about using the Custom Maintenance Wizard (CMW)? This is very great for updating the features installed with MS Office. YOu can try this if you're getting tired with the Custom Installation Wizard (MST). Here is what you should do:
1. Install your MS Office 2003 to default settings.
2. Customize your MS 2003 settings using Custom Maintenance Wizard so that you can have the CMW file that you can use.
3. Apply this to the machine.
4. Verify the changes that you want.
5. If successful, send me beers.. [;)]
Hi DJ_Xest,
Thanks for your reply.
I looked at the CMW yesterday but as far as I can see it offers the same settings as the CIW. Further I have to offer an MSI/MST combination to the customer.
I just need the regkey to set this feature but it's virtually unfindable.
No guru's out there who know where to look for it?
Marcel
Posted by:
dj_xest
19 years ago
Hi ZhuBajie,
CMW is great for updating features in MS Office..
By the way, have you tried doing a snapshot to find that Reg entries? Here is something I usually do:
1. Install application in full mode and making sure the feature I want to check is unselected.
2. After the successful install, I do a before snapshot using any tool I have in hand. My favorite for a quick finder is "InstallWatch" tool.
3. I reinstall the application and making sure I now choose the feature that I want to check.
4. I do an after snapshot and look for differences.. You may need to check the results very carefully after that. I believe you know what I am saying.. Hope this help.. [;)]
CMW is great for updating features in MS Office..
By the way, have you tried doing a snapshot to find that Reg entries? Here is something I usually do:
1. Install application in full mode and making sure the feature I want to check is unselected.
2. After the successful install, I do a before snapshot using any tool I have in hand. My favorite for a quick finder is "InstallWatch" tool.
3. I reinstall the application and making sure I now choose the feature that I want to check.
4. I do an after snapshot and look for differences.. You may need to check the results very carefully after that. I believe you know what I am saying.. Hope this help.. [;)]
Posted by:
rikx2
19 years ago
toolbar customization informations are stored in the excel10.xlb located in "profiles folder\Application Data\Microsoft\Excel".. just copy and paste it to your target computer.
hope this helps
rick
hope this helps
rick
Posted by:
ZhuBaJie
19 years ago
Thanks for your replies guys.
version 10 is Office XP a.f.a.i.k. I looked for .xlb files but didn't find any.
I only found .pip files but they didn't do the trick.
Yes I did but I got nothing useful out of it.
riks2
toolbar customization informations are stored in the excel10.xlb located in "profiles folder\Application Data\Microsoft\Excel".. just copy and paste it to your target computer.
version 10 is Office XP a.f.a.i.k. I looked for .xlb files but didn't find any.
I only found .pip files but they didn't do the trick.
dj_xest
By the way, have you tried doing a snapshot?
Yes I did but I got nothing useful out of it.
Posted by:
rikx2
19 years ago
sorry.. it should be excel11.xlb for 2003 [8D]
maybe this could help
http://exceltips.vitalnews.com/Pages/T0574_Backing_Up_Your_Customized_Toolbars.html
maybe this could help
http://exceltips.vitalnews.com/Pages/T0574_Backing_Up_Your_Customized_Toolbars.html
Posted by:
ZhuBaJie
19 years ago
ORIGINAL: rikx2
sorry.. it should be excel11.xlb for 2003 [8D]
maybe this could help
http://exceltips.vitalnews.com/Pages/T0574_Backing_Up_Your_Customized_Toolbars.html
Howdy!
You're right, this works!
I couldn't find the file with the filesearch in explorer but found it in a jiffy with FileLocator Pro.
Thanks for your help.
Marcel
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.