Rubberduck

[grovelli]

What's your opinion about Rubberduck?

[HansV]

I never heard of it before now, so I have no opinion on it.

[Rudi]

I have come across it before when searching for code indenters. I now see that this add-in has integrated Smart Indenter into it. I haven't tried it but with the indenter included it has my interest. I am still using Smart Indenter (in Excel 2013) but might have to revert to this if Smart Indenter does not successfully integrate with Excel 2016 (when I upgrade later this year!)

[grovelli]

I'm still using SmartIndenter and it does integrate with Office 2016. I'd venture saying Rubberduck takes VBE to another level, once you master all it brings on the plate, that is
By the way, what would you use instead of the TreeView control in Access 64 bit?

[HansV]

I don't see any reason for using 64-bit Office. It has lots of disadvantages and hardly any advantages compared with the 32-bit version. I strongly recommend avoiding the 64-bit version.

But if you really need to: the MS Forms TreeView control developed by Jan Karel Pieterse (with the help of Peter Thornton, Ben Clothier and Ron de Bruin) works on 32-bit and 64-bit versions of Office. See An MSForms (all VBA) treeview.

[grovelli]

Thank you Hans and Rudi, an added bonus of your last link is that it also mentions an alternative to the calendar control
I'm afraid 64 bit Win10 & 64 bit Office is the direction we're about to embark on. What are the main disadvantages?

[HansV]

64-bit Windows is fine, it shouldn't cause any problems. I don't think there are many users of 32-bit versions of Windows left.

64-bit Office is a different matter:

1) Compatibility problems!
- As you are already aware, ActiveX controls won't work in 64-bit Office.
- Many add-ins for Microsoft Office are incompatible with 64-bit Office.
- Sharing a database with users who have 32-bit Office will be problematic.
- A .mde or .accde database created in 32-bit Office won't work at all in 64-bit Office and vice versa.

2) VBA problems
- If you have code that uses Windows API functions, it will have to be modified to work in 64-bit Office. And to make it work in both 32-bit and 64-bit Office adds extra complications.

[Wendell]

64-bit Windows is fine, it shouldn't cause any problems. I don't think there are many users of 32-bit versions of Office left.

Did you really mean Office, or did you mean to say "32-bit versions of Windows left."?

[HansV]

Sorry, I meant Windows, of course. I will edit my reply.

Thanks, Wendell!

[jstevens]

I'm looking for an update on Rubberduck. Has anyone tried it?

Over the years I've written quite a bit of code (mostly Excel VBA) and am looking for a central repository. I'm trying to clean up what I have and at least have an inventory of said code.

[HansV]

I don't use Rubberduck, but apparently it is still being developed. The last official release is from 2021, but there is a prerelease of the next version that was released this week.