Archive for category Rubberduck
VBA and Git the Sequel: This Time it’s Integrated
Posted by Christopher J. McClellan in Rubberduck, VBA on June 29, 2015
I’ve talked before about using Git with VBA and also about the importance of using source control and other tools for our work. Truthfully though, using source control with VBA is still hard. This is mostly because getting the code modules into and out of the VB Project is hard, and harder to do right. Well, you may have heard that there’s a new duck in town. It’s taken me about 6 months of spare time, but Rubberduck v1.4 not only has a source control COM library that you can use right in VBA to work with Git VBA repositories, but you can also now branch, commit, pull, push, and merge right from inside of the editor.
Mocking the VBA Editor: Moq an IEnumerable that Works with Linq
Posted by Christopher J. McClellan in .NET, CSharp, Programming, Rubberduck, VBA on June 14, 2015
It’s been a rough morning here. I’ve just spent six hours trying to properly create a mock for the VBProject interface. There’s very little information out there about this, so I thought I’d take a moment to jot this down and save someone else the headache. For all the grief this gave me, the solution is amazing simple.
What’s Up Duck?
Posted by Christopher J. McClellan in Rubberduck on May 29, 2015
I’ve been promising you an update on my pet project, Rubberduck, for quite some time now. I apologize for taking so long to get around to it. Both the project and this blog tend to come last in the grand scheme of my life, so it sometimes takes me some time to get around to things. I’m afraid that may be more or less the theme of this post.
v1.21 is here! (yes, including for 64-bit Office!)
Posted by Christopher J. McClellan in Programming, Rubberduck, VBA on March 17, 2015
Fixed the bugs we did. Better we made it. =;)-
The Professional VBA Developer
Posted by Christopher J. McClellan in Life, Programming, Rubberduck, The Art Of Manliness, VBA on March 5, 2015
I came across a post on Programmer’s Stack Exchange yesterday that really irked me. It took me a little while to really digest what upset me about it, but I think I understand now. This developer was asking for more reasons to back up his claim that he should move his solution from VBA to C#. That in itself is fine. As I stated in my response, I understand his desire to move his solution to C#. I wish I could move all of my projects to the .Net platform myself.
No. Wanting to move to a more modern technology was not my issue with his question. My problem was with how he acted like working in an old technology gave him a pass on being a professional.
See a Need, Fill a Need
Posted by Christopher J. McClellan in Programming, Rubberduck, VBA on February 26, 2015
I’ve been fairly absent from this blog lately. I’ve been busy working on a new release of Rubberduck and, honestly, there are only so many hours in a day. More importantly, there are only so many concentrated thoughts to go around in 24 hours. So, I apologize for being gone for so long. I hope you can forgive me when you see the results. I’m really excited about our next release. There’s some really awesome things in there. You can download the pre-release now if you’re interested. There are a few kinks to work out, but things should be stable very soon.
To be truthful though, that project is the last thing I want to talk about right now. Rubberduck has become an obsession. There have been so many early mornings and late nights that I can’t possibly count them. There will be more. Many more. We’re only getting warmed up… and I’m going to talk about it anyway. It is an obsession after all. Like any addict, I just can’t let it go.
Test Driven Development in VBA: Eating Our Dogfood
Posted by Christopher J. McClellan in Programming, Rubberduck, VBA on December 14, 2014
You heard me right. TDD in VBA. It’s completely possible. I know because I’ve spent the last two weeks using Rubberduck’s Unit Testing framework doing it. Read the rest of this entry »
Unit Testing and Todo Lists in VBA: Announcing Rubberduck Version 1.0
Posted by Christopher J. McClellan in Programming, Rubberduck, VBA on November 30, 2014
Have you ever wanted to properly unit test your VBA code or simply wished the VBA editor had a Task List window that picked up your Todo comments? The wait is over friends. It’s here.