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...
by Jonathan Halder | May 20, 2024 | MS Access, MS Access VBA Coding
I’ve probably clicked on this button before, but I must say, I have absolutely no idea off the top of my head what this does: I noticed it today in the VBE editor. “Clean Project”. No 3 dots. I’m going to try to click it and see what happens!...
