Microsoft Excel
Back to jkp-ads.com

Ron de Bruin
Excel Automation

Microsoft MVP Program

Com Addins for the VBE Editor

Important message to visitors of this page

Ron de Bruin decided to remove all Windows Excel content from his website for personal reasons. If you want to know why, head over to rondebruin.nl.

Luckily, Ron was kind enough to allow me to publish all of his Excel content here.

Most of these pages are slightly outdated and may contain links that don 't work. Please inform me if you find such an error and I'll try to fix it.

Kind regards

Jan Karel Pieterse


Two useful Com Add-ins created by Jim Rech

VBEBookmarks.dll is a COM Add-in for the Microsoft Office Visual Basic Editor which lets you bookmark up to five locations and have five copy buffers that you can use in your VBA projects.

ToolsRefSize.dll is a COM Add-in for the Microsoft Office Visual Basic Editor which enlarges the Tools, References dialog box so you can see long paths.

Note: If you are running Office 2013 read the information on the bottom of this page first.

Download the two dll files

 

How do I register the DLL files:

1: Unzip the dll anywhere on your machine.
2: Open a command prompt window

Windows XP :

Start>Programs>Accessories>Command Prompt

Change to the folder you've copied the DLL into with cd, I use a folder named Add-ins in C:\
Enter "cd C:\Add-ins" (without quotes) at the command prompt and press Enter.
Enter "REGSVR32 NameDLLFile.dll" (without quotes) at the command prompt and press Enter.

If you do it correctly you will see this:

Close the command prompt window.

 

Windows Vista/Windows 7:

Start>All Programs>Accessories

Make sure you start your Command Prompt with Administrator privileges.
Right click the Command Prompt shortcut and click Run as Administrator.

Change to the folder you've copied the DLL into with cd, I use a folder named Add-ins in C:\
Enter "cd C:\Add-ins" (without quotes) at the command prompt and press Enter.
Enter "REGSVR32 NameDLLFile.dll" (without quotes) at the command prompt and press Enter.

Note: See the word Administrator in the header now

If you do it correctly you will see this:

Close the command prompt window.

 

To unregister the DLL:

If you want to remove the add-in use /u after REGSVR32

If you do it correctly you will see this:

 

How do I use the Add-ins ?

Bookmarks and Copy buffer add-in

When you start your Office application and switch to the Visual Basic Editor the Bookmarks toolbar will appear automatically. If you don't like its location you can move it wherever you want and the add-in will try to remember that location for the future. The Bookmarks toolbar has five toolbuttons captioned "1" to "5" and a sixth toolbutton to reset or free up used toolbuttons. All toolbuttons are initially available and have the tooltip "Unused" when you mouseover them. When you find a place in a module you want to bookmark simply click an unused toolbutton. The toolbutton will appear "pressed" and its tooltip will change to the name of the parent Office document/workbook, etc., module and line number.To have a toolbutton that is already in use mark the current location instead hold the Shift key down when you click it. To return to this spot later simply click the same toolbutton. To reset all toolbuttons (mark them unused) click the R button.

There are also five toolbuttons captioned "A" to "E" and a sixth toolbutton to clear the copy buffers. You can select a few code lines or a complete macro or function and click one of the Buttons to copy the code in the buffer of that button. If you click on the button again it will paste the code where the curser is on that moment. If you want to change the copy buffer for one of the buttons hold the Shift key when you click on it. You see that the tooltip of the button will change also when you do this.

Tools, References dialog box enlarger

When you use Tools>References you see that the dialog box is much wider so you can read long paths

Note: Jim based this add-in on work previously done by Stephen Bullen in his VBE Tools v2.0 and thanks him for having made his code public.

Load or unload add-in

Use Add-Ins, Add-In Manager to control whether the add-in starts up automatically and to load and unload it manually. If you not want to use it anymore you can unregister the dll like I also show you on this page.

 

Problems when you use Office 2013 on your machine

On your Office 2013 machine, you also have to make sure the following DLL exists and is registered:

C:\Program Files (x86)\Common Files\DESIGNER\MSADDNDR.DLL  (path in a 64 bit OS)

In a 32 bit OS version to open the folder use Start>Run or use Start and use the Search box and enter:
%commonprogramfiles%\DESIGNER

In a 64 bit OS version to open the folder use Start>Run or use Start and use the Search box and enter:
%commonprogramfiles(x86)%\DESIGNER

This is required in order for VB6 COM add-ins that use the COM Add-In designer to work. It was installed by all previous versions of Office but not Office 2013. You can copy it from an Office 2010 computer if you don't find it on your Office 2013 machine, than you need to register it like I show you above.

You can also download the 2010 dll file from my site if you want so you can copy it to your 2013 machine.

Download MSADDNDR.DLL

See also the information in this KB from microsoft
http://support.microsoft.com/kb/2792179