Meta Thinking, Meta Working
Let's take a look at the Da# Macro Attribute Get/Set function. This is a continuation of the previous article. DA# Macro(2): DA# Macro function(1)-Common function, Entity Get/Set 2.3.DA# Macro Attribute Get/Set 2.3.1. Attribute Get Get Attribute: Open the models selected in the “Select Model” window in turn and bring the attribute information of the entire entity to Excel. In this case, line 3...
In this article, we look at the Da# Macro common function Entity Get/Set function. This is a continuation of the previous article. DA# Macro(1): DA#, DA# API, DA# Macro (Macro) Overview 2. DA# Macro Function DA# Macro function is largely divided into common functions, Entity Get/Set, Attribute Get/Set, and Reverse. 2.1. DA# Macro common function...
This article introduces DA#, a domestic data modeling tool, and examines API provided from DA# v5 and DA# Macro, a tool developed using it. 1. DA# Macro Overview 1.1. Data Modeling Tool DA# DA# can create and manage data models expressed in ERD (Entity Relationship Diagram)...
Learn about the Windows API PtrSafe declaration. When coding with Excel VBA, you can check the causes and solutions of PtrSafe-related errors that you occasionally encounter while importing and using Windows APIs. 1. Example code for Windows API PtrSafe error This is the code that imports and declares Windows API Sleep, OutputDebugString. (reference:...
In this article, we look at an effective logging method using the Windows API OutputDebugString and DebugView utilities in Excel VBA. 1. Basic Logging Pattern Excel VBA Course (9): Excel VBA How-To 4.3. How to use the Immediate Window tool Refer to “3. Checking the Output Message “was covered. You can check the contents output by Debug.Print in the Immediate Window...
Introduces how to create a 32bit Provider Connection String on a 64bit OS. Previous Post VBA Coding Pattern: Importing DB Query Results to Excel_ConnectionString Creation Method 1. I mentioned “How to display 32bit Provider in 64bit OS” in the contents of using UDL file. If you create a connection string with a UDL file on a 64-bit OS, you can basically only create it with the installed 64-bit Provider. Windows 10 in this article...
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...
This article examines the implementation of functions for creating and editing ADO DB Connection Strings in Excel VBA. 1. ADO concept and necessity 1.1. Concept of ADO (ActiveX Data Objects) ADO is a library that can access various data stores and CRUD (Create, Read, Update, Delete) data. Microsoft docs...
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”)...
English 
한국어 
简体中文 
日本語 
Deutsch 
Español