by Jonathan Halder | May 28, 2024 | MS Access, MS Access VBA Coding
Ok, next let’s try removing some parameters from a function and see what happens. Here is the code I set up for the test in a class module. HAL_BasicEncryption Option Compare Database Option Explicit Implements IHAL_Encryption Private Function...
by Jonathan Halder | May 27, 2024 | MS Access, MS Access VBA Coding, TDD
I extracted an interface in the last two articles for an encryption algorithm class. It’s pretty basic, but that’s ok, I’m just playing with the various refactoring tools to get familiar with them and understand how they work. Now I want to implement...
by Jonathan Halder | May 24, 2024 | MS Access, MS Access VBA Coding
I attempted to Extract Interface on a class module yesterday called HAL_Outlook in my code library. Here’s yesterday’s article: Refactoring in VBA with RubberDuck: Extract Interface part 1 | Access JumpStart The dialog came up and it “worked”...
by Jonathan Halder | May 23, 2024 | MS Access, MS Access VBA Coding
The next refactoring item in the menu is “Extract Interface”: This applies to a class module, so in order for it to be active, we need to have a class module selected. We would want to extract an interface in order to abstract an existing class to create a...
by Jonathan Halder | May 22, 2024 | MS Access, MS Access VBA Coding
The next refactoring to look at is “Extract Method” located here in the VBA IDE RubberDuck menu: I’m going to look at this code and attempt to use this on OldMatches to extract the line to a new function to make it easier to read. Here is the code I...
by Jonathan Halder | May 21, 2024 | MS Access, MS Access VBA Coding
Update 6/12/2024: Found another source of documentation On RubberDuckVBA’s github page they do have a section that mentions each of the refactoring options: https://github.com/rubberduck-vba/Rubberduck/wiki/Refactorings Original article I’m going to spend...
