How to duplicate your VBE setup
авторSo you've got your new PC and you've copied over your Excel.xlb and
Personal.xls from the old machine. Now you go into the VBE and... oh yeah,
how do you copy over your VBE preferences, customizations and toolbars?
Here's how:

- Run RedEdit.exe
- Navigate to the key HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common
for Office 2000 or HKEY_CURRENT_USER\Software\Microsoft\VBA\Office for
Office 97.
- From the file menu pick Export Registry File and select a file name.
- Copy the resulting REG file to the new machine.
- On the new machine you can run RegEdit and pick Import Registry File or
from Windows Explorer right click on the file and select Merge.