Archives: 2020

  • 2020.12.19 (Sat)

    VBA & POWERSHELL: THE TECHNIQUE TO EXTRACT A SPECIFIC STRING FROM MODULES, CLASSES OR SQL OF QUERIES IN ACCESS DATABASE

  • 2020.12.11 (Fri)

    EXCEL VBA: A MACRO TO SEARCH AND REPLACE A TEXT OF SHAPES IN EXCEL BOOK

  • 2020.12.05 (Sat)

    EXCEL VBA: TYPICAL PATTERNS FOR EXCEPTION HANDLING & SAMPLE OF HOW TO USE

  • 2020.11.22 (Sun)

    VBA: THE BENEFIT OF USING CLASS AND THE WAY TO USE, WITH A SIMPLE SAMPLE PART 2

  • 2020.11.20 (Fri)

    VBA: THE BENEFIT OF USING CLASS AND THE WAY TO USE, WITH A SIMPLE SAMPLE PART 1

  • 2020.11.15 (Sun)

    WINDOWS10'S VIDEO RECORDING APP CAN'T RECORD FORMS OF EXCEL AND ACCESS. ABOUT IT WE SHOULD ...

  • 2020.11.15 (Sun)

    Access VBA: A SIMPLE SAMPLE OF INSERTING AND DELETING A RECORD ON A SUBFORM

  • 2020.11.08 (Sun)

    Access VBA: THE THING YOU NEED TO BE AWARE OF WHEN CREATING EVENT LISTENER BY USING WITHEVENTS FOR FORM CONTROLS

  • 2020.11.05 (Thu)

    EXCEL VBA: HOMEMADE EXCEL SHORTCUTS TO IMPROVE WORK EFFICIENCY

  • 2020.11.01 (Sun)

    EXCEL VBA: WITH POLYMORPHISM, BRANCHING A PROCESS WITHOUT USING IF STATEMENT

  • 2020.11.01 (Sun)

    EXCEL VBA: I CREATED A TOOL THAT ALL SELECTED EXCEL BOOK HAVE THEIR CURSOR MOVED TO A1.

  • 2020.10.30 (Fri)

    POWERSHELL: THE WAY TO GET THE PATH LIST OF THE FILES WHICH HAVE BEEN UPDATED SINCE [SPECIFIED TIME].

  • 2020.10.27 (Tue)

    ACCESS VBA: I CREATED A TOOL EXPORTING TABLE DEFINITIONS DISPLAYED AT DESIGN VIEW IN A TABULAR FORMAT.

  • 2020.10.25 (Sun)

    ACCESS VBA: I CREATED A FUNCTION EXPORTING TABLE DEFINITIONS DISPLAYED AT DESIGN VIEW IN A TABULAR FORMAT.

  • 2020.10.13 (Tue)

    ACCESS VBA: SOLUTIONS OF THE PROBLEM THAT AUTOMATIC COLUMN WIDTH ADJUSTMENT DOES NOT WORK WHEN USING USER-DEFINED FUNCTIONS IN THE CONTROL SOURCE.

  • 2020.07.18 (Sat)

    [EXCEL] I CREATED A MAIL CREATION TOOL WHICH IS NON-MACRO.

  • 2020.07.16 (Thu)

    EXCEL VBA: I CREATED A QUOTATION CREATION TOOL.

  • 2020.07.16 (Thu)

    TOOL DEVELOPMENT ON EXCEL: COMPARING BETWEEN TOOLS USING FUNCTION (NON-MACRO) AND TOOLS USING VBA MACRO