-
Best selling package -
Selected Package -
Popularity package -
Exclusive package -
High salary package
![](https://s2.51cto.com/images/202103/02/eb8e65f9be09f202ddda448cc3f85a2d.jpg?x-oss-process=image)
![](https://s2.51cto.com/images/201703/68082f0865b11468086295273bb42d3481d41f.jpg?x-oss-process=image)
![](https://s2.51cto.com/images/201703/43fd3b2386f750cac6b83317b2c0f5de13a1d9.jpg?x-oss-process=image)
![](https://s2.51cto.com/images/201703/85f076943ec847ab6d93837459a73c0e78202d.png?x-oss-process=image)
![](https://s2.51cto.com/images/201703/139d0bf9282c6cacb57729a28af07372f2dabd.png?x-oss-process=image)
![](https://s2.51cto.com/images/201703/c268f2f46a2da11d2969046b085c22d59c8612.png?x-oss-process=image)
![](https://s2.51cto.com/images/201812/29/0b3bcbfd279b0b3e79ea4b2b9be85eb2.png?x-oss-process=image)
![](https://s2.51cto.com/images/202004/06/cb8b781ef62a4220b25a3cf68875c704.png?x-oss-process=image)
![](https://s2.51cto.com/images/202002/23/8a61b0e060b250d3b2a637b7e1ee5b4f.png?x-oss-process=image)
![](https://s2.51cto.com/images/avater/202208/38d1dd1628b8cf4431e74806994376214f481c.jpg?x-oss-process=image)
![](https://s2.51cto.com/images/avater/202209/e5544c6547a77c937564946acc6fae60ee83c2.jpg?x-oss-process=image)
![](https://s2.51cto.com/images/avater/202209/0690d55167846ee7d98758f41e6e11ca2dabd2.jpg?x-oss-process=image)
![](https://s2.51cto.com/images/avater/202208/38d1dd1628b8cf4431e74806994376214f481c.jpg?x-oss-process=image)
![](https://s2.51cto.com/images/avater/202209/e5544c6547a77c937564946acc6fae60ee83c2.jpg?x-oss-process=image)
![](https://s2.51cto.com/images/avater/202209/0690d55167846ee7d98758f41e6e11ca2dabd2.jpg?x-oss-process=image)
-
Course Introduction -
Course outline
one Introduction to API Functions This article introduces what API functions are and why API functions are added to VBA. "Only for paying users" Click to download "API. zip" [10:40] Start learning two How API functions are declared How to query and declare API functions in VBA. API function declaration, constant and type can be queried through VBE2014. You can also query through APITools.exe/APIViewer. "Only for paying users" Click to download "VBA programming uses API to realize automation. pdf" [14:31] Start learning three Return value of API function Taking the FindWindow function as an example, this paper introduces the function and significance of the return value of the API function. [16:28] Start learning four Detailed Description of MoveWindow Function MoveWindow is used to change the size and position of a window. Through the learning of this function, you can understand how parameters are passed in API functions. [08:21] Start learning five Usage of API constants The ShowWindow function is used as an example to describe the query, declaration and use of API constants. [11:24] Start learning six Use API structure type Query and declaration of API structure types. PointAPI and Rect are taken as examples to illustrate the use of structure types. [15:32] Start learning seven Overview of API Packaging Library Using API encapsulation library can simplify the development process, and the same function can be used without declaring API in VBA. [16:29] Start learning eight Window relationship analysis The prerequisite for accurately obtaining window and control handles is to understand the relationship between windows. This lesson, combined with the SPY tool, explains the ownership of windows and controls. [29:40] Start learning nine Acquisition of control handle Use the FindWIndowEx function to obtain the handle of each control layer by layer. [47:55] Start learning ten Return handle with coordinates The position of the window or control on the desktop is called the coordinate. The handle of the coordinate point can be returned through coordinates. [16:30] Start learning eleven Window attribute read/write This lesson describes how to obtain the title, size, position and other properties of the window. Then we will talk about modifying the title and resetting the size and position of the window. [22:23] Start learning twelve Control property reading and writing This section describes the attribute reading and writing of common controls such as buttons, text boxes, check boxes, and list boxes. [30:37] Start learning thirteen Get and set cursor position This article describes the usage of GetCursorPOS and SetCursorPOS functions. [08:42] Start learning fourteen Operation keyboard This paper introduces the method of automatic key pressing in the front end. [18:13] Start learning fifteen Operate the mouse The front end automatically clicks the mouse, presses and pops up the mouse. [14:33] Start learning sixteen Get and set pixel color Describes the usage of GetPixel and SetPixel functions [08:33] Start learning seventeen Operation menu This section describes how to view the ID of a menu item through the SPY tool. Read and write the properties of the menu item. Click the menu item automatically. [11:31] Start learning eighteen send message Automatically send key and mouse messages to the window, which belongs to the background mode. It also introduces the use of combination keys. [21:10] Start learning nineteen Other functions In the API. Other class, there are other common functions, such as MD5 calculation, GUID generation, system type judgment, etc. [05:31] Start learning twenty Calling API encapsulation library in C # project This article describes how to add API references in C # projects. Usage of APITools Click "Only for paying users" to download "API-Setup. zip" [10:33] Start learning