Excel VBA application development can be ordered from the second bookstore from the basics to practices

In the morning, the press called to inform you that the book has been officially published. After reading the second bookstore, you can order it now, but the status is out of stock. If you need it, you can order it. It is estimated that each bookstore can see it in a month.

Order: http://www.dearbook.com.cn/book/110873

Http://www.dangdang.com/product/9201/9201169.shtml
 

<Excel VBA application development from basic to practice> Contents

Chapter 2 Introduction to excel and VBA 1
1.1 about Excel and vba1
1.2 excel as a data processing platform 3
1.3 excel as a development platform 4
1.4 macros, loaded macros, and vba5
Part 1 entrance
Chapter 2 Excel and macros 8
2.1 macro 8
2.2 recording macro 9
2.2.1 macro recording Step 9
2.2.2 a small example of macro recording 11
2.3 run macro 11
2.3.1 run the recording macro 11
2.3.2 Add a macro to the menu or toolbar 11
2.4 view and edit macros 14
2.5 load macro 16
Chapter 19 VBA preliminary 19
3.1 VBA Introduction 19
3.2 VBA Quick Start 20
3.2.1 VBA Development Environment 20
3.2.2 VBA project and its composition 21
3.2.3 write Code 23
3.2.4 module, process, and function 25
3.2.5 creation process and function 27
3.2.6 process call 28
3.2.7 variable 29
3.2.8 Program Process 33
3.2.9 Condition Statement 33
3.2.10 loop statement 37
3.2.11 array 41
3.2.12 utility and other 42
3.3 apply VBA to excel45
3.3.1 Excel Object Model 45
3.3.2 common objects in Excel Object Model 46
3.4 application instance 48
3.4.1 use VBA to merge columns 48
3.4.2 automatically hide or display rows without data in the table 48
3.4.3 use VBA to operate the worksheet cell 49
3.4.4 search for the first blank row of the worksheet 50
3.4.5 change the title of the Excel page 51
3.4.6 format a worksheet 52 on the delimiter
3.4.7 modify data in batches 52
Chapter 4 applying VBA udfs 54
4.1 formulas and functions 54
4.1.1 formula and composition 54
4.1.2 reference 54
4.1.3 name and constant 58
4.1.4 operator and Operation Order 58
4.2 Excel worksheet function 59
4.2.1 common functions 60
4.2.2 statistical function 60
4.2.3 array formula 61
4.3 user-defined functions 62
4.3.1 create a UDF 62
4.3.2 create an array formula 65
4.4 application instance 65
4.4.1 auxiliary function for score statistics 65
4.4.2 ID card number processing function 68
Part 1 Introduction
Chapter 2 VBA language 72
5.1 composition of VBA programs 72
5.1.1 module 72
5.1.2 process 73
5.1.3 function 76
5.1.4 process and function call 77
5.1.5 note 78
5.2 Data Type 79
5.2.1 constants and variables 79
5.2.2 data type 80
5.2.3 operator 82
5.2.4 array 83
5.2.5 Custom Data Type 84
5.2.6 Enumeration type 85
5.2.7 variable scope (lifecycle) 86
5.2.8 string 87
5.2.9 Date and Time 89
5.3 control procedure process 90
5.3.1 Condition Statement 90
5.3.2 loop statement 93
5.3.3 with statement 96
5.3.4 exit statement 97
5.4 simple user interaction 97
5.5 user form 99
5.5.1 design user form 99
5.5.2 event-driven 101
5.5.3 use controls 102
5.6 debug VBA code 103
5.6.1 Error Type 103
5.6.2 use DEBUG object 104
5.6.3 debugging tool of VBA 105
5.7 error handling 106
5.7.1 set error capture 106
5.7.2 compile error handling utility 107
5.7.3 provide exit 107 from the error handling program
5.7.4 simple example of error handling 107
5.8 class modules and object-oriented 108
5.8.1 object-oriented development 108
5.8.2 object variables and objects 109
5.8.3 create a class module 110
5.9 use of COM objects 113
5.10 collection object 115
Chapter 2 Excel Object Model 6th
6.1 EXCEL object model introduction 116
6.2 Application Object 118
6.2.1 control Excel status and display 118
6.2.2 returned object 120
6.2.3 perform Operation 122
6.2.4 Windows Object and Windows collection 126
6.2.5 Application Event 126
6.3 workbook object 130
6.3.1 workbooks set 130
6.3.2 attributes of a workbook: 130
6.3.3 sheets set 132
6.3.4 method of workbook 133
6.3.5 workbook event 135
6.4 worksheet object 136
6.5 range object 138
6.5.1 return or get range object 138
6.5.2 common attributes and methods of a range object 141
Part 1 special questions
Chapter 2 Data Processing 7th
7.1 overview 148
7.2 Excel Data Processing Methods and Procedures 149
7.2.1 method and process 149
7.2.2 "table-driven" Data Processing 151
7.2.3 "process"-based data processing 152
7.2.4 Data Processing Based on the "Object-Oriented" method 154
7.3 operate data files 156
7.3.1 use Excel objects to operate data files 156
7.3.2 use VBA statements Composition Pieces 163
7.3.3 FileSystemObject object model 174
7.3.4 Excel Data Import function 183
7.4 Database Operations 183
7.4.1 use Excel tool to import database data 183
7.4.2 use VBA to query table 184
7.4.3 use ADO to operate the database 185
7.5 Web Data Operations 188
7.6 operation data 190
7.6.1 worksheet data reference 190
7.6.2 operation text 194
7.6.3 operation value 198
7.6.4 Date and Time 201
7.6.5 Excel worksheet function 205
7.6.6 data type judgment and conversion 211
7.7 application instance 217
7.7.1 Format 217
7.7.2 use VBA in Excel to filter data 220
7.7.3 batch rename file 224
7.7.4 text information processing instance 226
Chapter 2 Excel chart 8th
8.1 Excel Charts and objects 230
8.2 create an Excel chart 232
8.2.1 create a chart worksheet 232
8.2.2 create an embedded chart 233
8.2.3 create a chart by recording a macro: 236
8.3 Operate Excel Charts 237
8.3.1 activate chart 238
8.3.2 modify the chart data series 239
8.3.3 chart format 244
8.3.4 chart output 246
8.4 Excel chart event 247
8.5 Excel chart object model 250
8.6 application example: drawing a triangle chart in Excel 251
8.6.1 question 251
8.6.2 solution 251
8.6.3 use macro code to draw a triangle chart 253
8.6.4 conclusion 257
Chapter 4 Interface Design 9th
9.1 interface type and select 258
9.1.1 interface type of the Excel VBA program 258
9.1.2 select 259 for the interface type
9.2 apply workbooks as interfaces 260
9.3 custom menu and toolbar 263
9.3.1 command bar object model 263
9.3.2 commandbars set object 264
9.3.3 commandbar object 266
9.3.4 command bar control 269
9.3.5 automatically create and delete Excel command bar 281
9.4 user form 282
9.4.1 design user form 282
9.4.2 user forms control 286
9.4.3 control user form 294
9.4.4 use other ActiveX controls 298
9.5 Excel built-in dialog box 299
Part 1 Example
Chapter 4 Application Example: batch data import tool 10th
10.1 Problem description 304
10.2 starting from recording macro 305
10.3 modify macro code 306
10.3.1 designing form 306
10.3.2 specify the file to be imported 307
10.3.3 modify the macro code of recording 308
10.3.4 form call 308
10.3.5 modify bug309
10.4 further improving the system 309
10.4.1 specify the location to import 309
10.4.2 add other file types 309
10.5 save as loading macro 310
10.5.1 add toolbar button 310
10.5.2 worksheet operation 312
10.5.3 save as macro loading operation 313
10.6 conclusion 314
Chapter 4 Application Example: Excel-based Query Tool 11th
11.1 Problem description 315
11.2 solution 315
11.3 Key Technologies 316
11.3.1 call external program 316
11.3.2 file operation 317
11.3.3 query 318
11.3.4 interface 318
11.4 main code 319
11.4.1 decompress and convert the file 319
11.4.2 Content Search 320
11.4.3 integration of the interface and the above Code 321
11.5 conclusion 321
Chapter 4 Application Example: gcdplot322
12.1 gcdplot introduction 322
12.1.1 what is gcdplot322
12.1.2 use of gcdplot 324
12.1.3 why use Excel VBA to develop gcdplot325
12.2 design and structure of gcdplot 326
12.2.1 design ideas 326
12.2.2 program structure 327
12.3 graphic definition file and parsing module 328
12.3.1 windows INI file 328
12.3.2 graphic type definition file of gcdplot 329
12.3.3 graphic definition file of gcdplot 329
12.3.4 graphic parsing module 332
12.4 graphic drawing module 334
12.4.1 graphic drawing process 334
12.4.2 drawing of Cartesian coordinate diagrams 335
12.4.3 plot of triangular coordinate 336
12.5 Interface Design 337
12.5.1 Add the gcdplot toolbar 337
12.5.2 gcdplot user form 338
12.6 integrate other worksheet programs 342
12.7 conclusion 343
Part 1 High Level
Chapter 2 advanced topics 13th
13.1 call windows api346
13.1.1 use api346 in VBA
13.1.2 Simple API call 346
13.1.3 encapsulate API calls as function 350
13.1.4 encapsulate the API call as the class module 352
13.2 automation other office components 354
13.2.1 start other office components 355
13.2.2 interaction with other office components 358

13.4 Excel VBA program type and deployment 364
13.4.1 type 364 of Excel VBA program
13.4.2 Advantages and Disadvantages of loading macro and general spreadsheet programs 364
13.4.3 deployment 365
13.5 VBA program Security and Protection 366
13.6 use other programs to automate excel366
13.6.1 create an Excel Object 366
13.6.2 Excel Automation event 367
13.6.3 use Excel to complete business logic 369
13.7 Excel Data Import and Export Methods 369
13.7.1 use automation to transmit data 369
13.7.2 use ADO to Operate Excel 372
13.7.3 use a third-party class library 374
13.8 references to the Excel project 375
13.9 suggestions for improving efficiency 375
13.9.1 use the Excel worksheet function 376 whenever possible
13.9.2 minimize the use of Object Reference 376
13.9.3 efficient use of range object 377
13.9.4 reduce the activation and selection of objects by 378
13.9.5 disable screen update 379
13.9.6 improve the efficiency of key code by 379
13.9.7 Calculation of code execution time: 379
Part 1 appendix
Appendix a vba naming rules 382
A.1 variables, constants, custom types, and enumeration 382
A.2 process and function 383
A.3 module, class module, and user form 384
A.4 VBA project 384
Appendix B VBA code specification 385
B .1 code layout 385
B .2 comment 386
B .3 program version 387
B .4 Basic Principles 387
Appendix C List of worksheet functions that can be used for VBA code 389
C.1 list of worksheet functions available for Visual Basic (in alphabetical order) 389
C.2 list of worksheet functions (sorted by category) for Visual Basic 392
Appendix d vba Language Reference 396
D.1 VBA syntax reference 396
D.1.1 variable 396
D.1.2 397 Data Type
D.1.3 operation 399
D.1.4 array 401
D.1.5 Process Control 402
D.1.6 Date and Time 405
D.1.7 directory and file 406
D.1.8 file read/write 407
D.1.9 class modules and ActiveX and COM objects 410
D.1.10 registry operation 411
D.1.11 error handling 411
D.1.12 other functions and keywords: 412
D.2 object 413
D.2.1 collection (SET) object 413
D.2.2 dictionary object 413
D.2.3 ERR Object 414
D.2.4 debug object 414
D.2.5 FileSystemObject object 415
D.3 common functions 415
D.3.1 mathematical functions 415
D.3.2 string function 416
D.3.3 financial function 417
D.3.4 data type conversion function 417
D.3.5 data type check function 418
D.3.6 interactive function 419
D.3.7 registry 419
D.4 common constant 419
D.4.1 color 419
D.4.2 file input/output 420
D.4.3 user form 420
D.4.4 keycode (key code) 420
D.4.5 msgbox parameter and return value 421
D.4.6 date 422
D.4.7 422 others