Export Editor Format?

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • Hello,


    For sure you do know these settings are stored at the Application level ...


    So basically, once you have modified them, your Excel application will apply them for each and every new workbook ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • Do not know how familiar you are with Excel ...


    But ... the only path is I can think of is for you to dive into VBIDE ... to program VBA ...


    You would need to search into the following library :


    Microsoft Visual Basic For Applications Extensibility 5.3


    Hope this will help

    :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • Hi Wilker,


    Thanks for your Thanks :)


    What you are telling me is a confirmation of what I had anticipated ...


    Indeed, Developers did not bother to dig that deep ;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • They're all stored in the registry (there's more than one key for the various options you can set). The exact location will change depending on the version of Office (and therefore VBA) that you have, but it will be something like:


    HKEY_CURRENT_USER\Software\Microsoft\VBA\7.1\Common


    and you can export that as a .reg file, copy it to the new machine (assuming the same version) and then just double-click to install to the registry.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!