Archives: 2020
VBA & POWERSHELL: THE TECHNIQUE TO EXTRACT A SPECIFIC STRING FROM MODULES, CLASSES OR SQL OF QUERIES IN ACCESS DATABASE
Access
VBA
PowerShell
HOMEMADE
EXCEL VBA: A MACRO TO SEARCH AND REPLACE A TEXT OF SHAPES IN EXCEL BOOK
Excel
VBA
EXCEL VBA: TYPICAL PATTERNS FOR EXCEPTION HANDLING & SAMPLE OF HOW TO USE
Excel
VBA
HOMEMADE
VBA: THE BENEFIT OF USING CLASS AND THE WAY TO USE, WITH A SIMPLE SAMPLE PART 2
Excel
VBA
HOMEMADE
object-oriented
VBA: THE BENEFIT OF USING CLASS AND THE WAY TO USE, WITH A SIMPLE SAMPLE PART 1
Excel
VBA
HOMEMADE
object-oriented
WINDOWS10'S VIDEO RECORDING APP CAN'T RECORD FORMS OF EXCEL AND ACCESS. ABOUT IT WE SHOULD ...
Access VBA: A SIMPLE SAMPLE OF INSERTING AND DELETING A RECORD ON A SUBFORM
Access
VBA
HOMEMADE
Access VBA: THE THING YOU NEED TO BE AWARE OF WHEN CREATING EVENT LISTENER BY USING WITHEVENTS FOR FORM CONTROLS
Access
VBA
HOMEMADE
object-oriented
EXCEL VBA: HOMEMADE EXCEL SHORTCUTS TO IMPROVE WORK EFFICIENCY
Excel
VBA
homemade
EXCEL VBA: WITH POLYMORPHISM, BRANCHING A PROCESS WITHOUT USING IF STATEMENT
Excel
VBA
HOMEMADE
object-oriented
EXCEL VBA: I CREATED A TOOL THAT ALL SELECTED EXCEL BOOK HAVE THEIR CURSOR MOVED TO A1.
Excel
VBA
HOMEMADE
tool
POWERSHELL: THE WAY TO GET THE PATH LIST OF THE FILES WHICH HAVE BEEN UPDATED SINCE [SPECIFIED TIME].
Powershell
ACCESS VBA: I CREATED A TOOL EXPORTING TABLE DEFINITIONS DISPLAYED AT DESIGN VIEW IN A TABULAR FORMAT.
Access
VBA
HOMEMADE
tool
ACCESS VBA: I CREATED A FUNCTION EXPORTING TABLE DEFINITIONS DISPLAYED AT DESIGN VIEW IN A TABULAR FORMAT.
Access
VBA
HOMEMADE
ACCESS VBA: SOLUTIONS OF THE PROBLEM THAT AUTOMATIC COLUMN WIDTH ADJUSTMENT DOES NOT WORK WHEN USING USER-DEFINED FUNCTIONS IN THE CONTROL SOURCE.
Access
VBA
[EXCEL] I CREATED A MAIL CREATION TOOL WHICH IS NON-MACRO.
Excel
tool
automation
HOMEMADE
EXCEL VBA: I CREATED A QUOTATION CREATION TOOL.
Excel
VBA
tool
HOMEMADE
TOOL DEVELOPMENT ON EXCEL: COMPARING BETWEEN TOOLS USING FUNCTION (NON-MACRO) AND TOOLS USING VBA MACRO
Excel
VBA
Excel Function