Sunday, November 22, 2015

Registering VBEBookmarks.dll on 64 bit Windows 10 and Microsoft Office 2013

I've been using VBE Bookmarks for a long time. The VBA IDE that comes inside every Microsoft Office program (Word, Excel, Powerpoint, Access, Visio, Project) was the zenith of useability and productivity during the Visual Basic VB 6 days. And even in 2015, the year I am writing this, it is in Microsoft Office 2016. However, jumping around your code is tough because the native bookmarks are not numbered or fun.

Ron de Bruin hosts two 32 bit .dlls authored by Jim Rech (Excel MVP) - one of them is VBE Bookmarks. The thing you have to do is to download the .dll and register it (a.k.a. install it) on your machine. Before Windows 10 64 bit, I did not have difficulty doing that. But I did this time, I did. So with help from friends +Paul Pavlinovich +Greg Kerr and a Stack Overflow discussion thread, I managed to make it work.

1. To register a .dll, ensure the .dll has no dependencies on other .dlls which may be missing. In this case, vbebookmarks.dll relies on msaddndr.dll which may or may not be already registered.

2. Ensure that the .dll you want to register is in a folder where there is no uncertainty about access rights. I gave up and copied it to the %systemroot%\syswow64 folder.

3. For 64 bit .dlls use regsvr32.exe in %systemroot%\system32, for 32 bit .dlls use regsvr32 in %systemroot\sysWoW64.

4. Use an elevated command prompt by running cmd.exe as Admin.

No comments: