Sign in
 
Home20132010Other VersionsLibraryForumsGallery
TechCenter >
> 
> 
Office 2010 (SP1) VBA IDE Save Settings.

Pertanyaan Office 2010 (SP1) VBA IDE Save Settings.

  • Tuesday, May 08, 2012 1:39 AM
     
     
    Sign In to Vote
    0

    Hello Office Forum,

    I'm ready to rebuild my PC hence re-installing Office 2010 SP1 Pro. As with every rebuild there are multitudes of custom settings one configures to set their PC to their liking.

    Not a big issue, but to save me configuring all those toolbar command button (custom) settings once again. Is there anywhere in the registry in Windows 7 Ultimate where I can export my custom VBA IDE settings, then set them back to retain my personal configuration?

    I ask because in Office 2003 there was a "Save My Settings" wizard that did this. I can't find this functionality in Office 2010 SP1. This is to configure all VBA IDEs, Excel, Access, PowerPoint, and Access.

    While I'm asking, I set many parameters in Excel (Spreadsheet not VBA) Options, and few in Word (Document not VBA), can I save these settings too somehow?

    Thanks and regards,

    BotRot

     

All Replies

  • Wednesday, May 09, 2012 7:11 AM
    Moderator
     
     
    Sign In to Vote
    1

    Hi,

    We can save the templates to save the setting in Office 2010.

    The location of templates in windows 7 is：

    C:\Users\ user name \AppData\Roaming\Microsoft\Templates

    More information, please refer to the link:

    http://support.microsoft.com/kb/924460

    Jaynet Zhang

    TechNet Community Support

     
  • Thursday, May 10, 2012 2:02 AM
     
     
    Sign In to Vote
    0

    Hello Jaynet,

    Thank you for your response, I shall try it out.

    Thanks and regards,

    BotRot