Meta Thinking, Meta Working
1. Python in Excel Overview Yesterday (2023-08-22), Python in Excel was announced at Microsoft Tech Community. In the meantime, we have been using a separate library to link Excel and Python, but finally we provide linkage in a basic environment without the need for separate installation. Announcing Python in Excel: Combining the power of Python and...
Microsoft 365 Copilot was announced last Friday (2023-03-17). By integrating ChatGPT into Microsoft 365, it seems that it can significantly improve user productivity. I've been watching ChatGPT since the end of last year. ChatGPT is spreading faster than any software or service ever introduced to the world. ChatGPT 3.5...
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”)...
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....
English 
한국어 
简体中文 
日本語 
Deutsch 
Español