Meta Thinking, Meta Working
Introducing the VBA coding pattern that implements importing DB Query results to Excel. Related Article: VBA Coding Pattern: Creating ADO DB Connection String 1. Excel Screen and Operation Method 1.1. Enter the connection string to connect to the DB in cell “B1” of the Excel screen, and in cell “B2” to extract data...
In this article, we will look at how to improve VBA performance. In the previous article, we compared the VBA Range Loop method and confirmed that the method using Variant Array is the fastest. VBA Coding Pattern: Range Loop - Read 1. Performance-Related VBA Global Variables Here is a summary of all variables....
Even if the reference address of Range is changed during VBA coding, if you use Named Range (named range), you can prevent the source code from changing regardless of the reference address change. Let's look at the following. 1. Range reference using absolute address The most frequently used method among many methods to refer to a Range in Excel VBA is as follows. In Range(“B2”)...
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:...
Among the VBA coding patterns, look at the contents of Range Loop-Read. Summary Range Loop is a coding pattern often used when reading and processing data entered in an Excel sheet with VBA code. The basic pattern of reading sequentially from the start cell to the last cell, and reading at once without reading sequentially...
Distribute “Naver Korean Dictionary/English Dictionary Search Tool_v1.01_20220708” with one error corrected. The outline of Naver Korean and English dictionary search tools and how to use them are summarized in the article below. Overview of Naver Korean Dictionary/English Dictionary Search Tool Today (2022-07-08) the following comments were posted. https://prodtool.tistory.com/28#comment9159871 #ToDo: After reviewing whether to change the comment link, the following error message occurs. I checked with Fiddler...
I'm uploading a separate table of contents for the entire Excel VBA lecture I've been writing. I put a link in the entire table of contents so that you can find this article as an index. Welcome to the Excel VBA course. (Lecture notice, feat. Reason for recommending Excel VBA) (prodskill.com) 1. Excel VBA Overview 1.1. VBA, Macro concept...
In this article, I look at examples of tools that I have developed and used with Excel VBA. This is a continuation of the previous article. Excel VBA Lecture (9): Excel VBA How-To 5. Tools developed and used with Excel VBA 5.1. Naver Korean Dictionary, English Dictionary Search Tool This is an automated tool that searches Naver Korean and English dictionaries and imports the search results into Excel.
This article examines the Excel VBA How-To. Please refer to it when coding Excel VBA. This is a continuation of the previous article. Excel VBA Lecture (8): Basic Excel VBA Language - Data type, Data structure 4. Excel VBA How-To 4.1. How to configure UI (User Interface) Receive input values from the user in Excel VBA or...
In this article, we look at the data type and the provided data structure among the basics of the Excel VBA language. This is a continuation of the previous article. Excel VBA Lecture (7): Basic Excel VBA Language - Syntax 3.3. Data types 3.3.1. Basic Data Types Data types supported by VB (or VBA) are summarized in the following table. Collection,...
English 
한국어 
简体中文 
日本語 
Deutsch 
Español