Back to jkp-ads.com |
Ron de Bruin
|
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
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.
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.
If you want to remove the add-in use /u after REGSVR32
If you do it correctly you will see this:
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.
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.
See also the information in this KB from microsoft
http://support.microsoft.com/kb/2792179