Access JumpStart 2.0 | Blog

Using some sample code I was playing with in my last Refactoring article, we will see what RubberDuck does when reordering parameters. Here's the code: HAL_BasicEncryption Option Compare Database Option Explicit Implements IHAL_Encryption Private Function...

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...

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" and created the new...

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 dumbed down...

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 am going to...