Meta Thinking, Meta Working
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....
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....
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...
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...
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...
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...
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...
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...
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...
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:...
English 
한국어 
简体中文 
日本語 
Deutsch 
Español