Rubberduck
-
- 4StarLounger
- Posts: 528
- Joined: 26 Jan 2010, 15:14
Rubberduck
What's your opinion about Rubberduck?
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- gamma jay
- Posts: 25455
- Joined: 17 Mar 2010, 17:33
- Location: Cape Town
Re: Rubberduck
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!)
Regards,
Rudi
If your absence does not affect them, your presence didn't matter.
Rudi
If your absence does not affect them, your presence didn't matter.
-
- 4StarLounger
- Posts: 528
- Joined: 26 Jan 2010, 15:14
Re: Rubberduck
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?
By the way, what would you use instead of the TreeView control in Access 64 bit?
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Rubberduck
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.
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.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 528
- Joined: 26 Jan 2010, 15:14
Re: Rubberduck
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?
I'm afraid 64 bit Win10 & 64 bit Office is the direction we're about to embark on. What are the main disadvantages?
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Rubberduck
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.
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.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 482
- Joined: 24 Jan 2010, 15:02
- Location: Colorado, USA
Re: Rubberduck
Did you really mean Office, or did you mean to say "32-bit versions of Windows left."?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.
Wendell
You can't see the view if you don't climb the mountain!
You can't see the view if you don't climb the mountain!
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Rubberduck
Sorry, I meant Windows, of course. I will edit my reply.
Thanks, Wendell!
Thanks, Wendell!
Best wishes,
Hans
Hans
-
- GoldLounger
- Posts: 2631
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
Re: Rubberduck
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.
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.
Regards,
John
John
-
- Administrator
- Posts: 78608
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Rubberduck
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.
Best wishes,
Hans
Hans