Author: Zerom

Creating a Dark Theme in VBE (VB Editor)

VBE (VB Editor), an editor that codes Excel VBA, does not have a function to set dark mode among the provided functions. The following screen was mentioned in Excel VBA Lecture (5): Excel File Extension, VBE, Font Setting #2.7.4._VBE_Screen_Composition. As you can see in the image above, the VBE default screen is displayed in black text on a white background....

Full Contents of Word Extraction Tool Description , Download

I wrote an explanation of the word extraction tool in six parts and posted them all on my blog. Write the entire table of contents of the word extraction tool description and post it as a separate article. 1. Word Extraction Tool Overview 1.1. Reasons for developing the word extraction tool 1.2. Word extraction tool concept 1.3....

Word Extraction Tool (6): Additional Description of Word Extraction Tool

Continuing from the previous article, we look at the additional explanation of the word extraction tool. Word Extraction Tool (5): Word Extraction Tool Source Code Description (2) 5. Word Extraction Tool Additional Description 5.1. Reasons for using OLE Automation OLE Automation is defined in Wikipedia as follows. In Microsoft Windows application programming, OLE Automation (later renamed simply Automation[1][2]) is an interprocess communication (IPC) mechanism developed by Microsoft. It is based on a subset of the Component Object Model (COM) and was intended to be used through a scripting language (originally Visual Basic), but is now available through several languages on Windows. Source: https://en.wikipedia.org/wiki/OLE_Automation In Python...

Word Extraction Tool(5): Word Extraction Tool Source Code Description(2)

Continuing from the previous article, we look at the source code of the word extraction tool implemented in Python. This is a continuation of the previous article. Word Extraction Tool (4): Description of Word Extraction Tool Source Code (1) 4. Word Extraction Tool Source Code 4.3. get_file_text function Lines 357-365: Execute the appropriate function according to the file extension and put the result in df_text...

Word Extraction Tool(4): Word Extraction Tool Source Code Description(1)

Examine the source code of a word extraction tool implemented in Python. This is a continuation of the previous article. Word Extraction Tool (3): How to Run Word Extraction Tool and Check Results 4. Source Code of Word Extraction Tool 4.1. Overview 4.1.1. Note the source code The source code of this word extraction tool is...

Word Extraction Tool (3): How to Run the Word Extraction Tool and Check the Results

Let's take a look at how to run the word extraction tool and check the results. This is a continuation of the previous article. Word Extraction Tool (2): Configuration of Execution Environment of Word Extraction Tool 3. Execution of Word Extraction Tool 3.1. Download word extraction tool The word extraction tool is uploaded to github. https://github.com/DAToolset/ToolsForDataStandard/tree/main/WordExtractor...

Word Extraction Tool (2): Configure the Word Extraction Tool Execution Environment

The word extraction tool is a tool developed in Python, and requires an environment configuration process such as installing Python and necessary packages prior to execution. Let's take a look at the configuration of the execution environment of the word extraction tool. This is a continuation of the previous article. Word Extraction Tool(1): Word Extraction Tool Overview 2. Word Extraction Tool...

Word Extraction Tool(1): Overview of Word Extraction Tool

An overview of word extraction tools that can be useful for data standardization work, especially for creating standard word candidates. 1. Word Extraction Tool Overview 1.1. Reasons for developing a word extraction tool The most difficult task among the initial tasks of data standardization is to register it as a standard word...

Scheduled to block execution of VBA macros received from the Internet (from 2022-07-27)

I have a new news related to VBA, so I write a brief article. From 2022-07-27, the execution of VBA macro files received from the Internet will be blocked. This is a security measure to prevent someone with malicious intent from distributing malicious code using macros. Only MS 365 Office apps running on Windows. Runs on Mac OS or installs...

VBA Coding Pattern: Range Loop - Write

Among the VBA coding patterns, look at the contents of Range Loop-Write. Summary Introducing coding patterns that improve performance when writing a lot of data in an Excel sheet using Variant Array. The article below has already covered how to improve performance when reading a lot of data from an Excel sheet. VBA coding patterns:...

en_USEnglish