best vba book

Gitbook set up local book 1, do not login, click Do this later2, click New book–> Enter book name –>confirm3, the path of the book4. Book Display5, Release6, import others book error and introduction7, related documents ———————————————————————- 1, do not login, click Do thi

Json:javascript Object Notation (JAvaScript Object Notation) Similar to XML, in the form of text (saved in a text file or a string, for example), such as:JSSTR = {"Department": "History department", "Class": "Class", " student":[ {"name": "Zhang San", "Age": 25, "gender": "Male"}, {"name": " John Doe "," age ": 20," gender ":" Male "}, {" name ":" Xiaoming "," Age ": 20," gender ":" Female "} ] }

Http://www.cnblogs.com/Charltsing/p/SmartIndenter64.htmlChange your computer recently and use 64-bit Office for development. The VBA code beautification becomes a problem. Smart Indenter 3.5 is developed by VB and cannot be loaded as a component by 64-bit office.Search online beautification Code plugin no fruit, had to write a smart Indenter 64-bit VBE plugin.SmartIndenter64 V1.02,windows7 and the following operating systems require the installation o

Baidu Experience Reference: http://jingyan.baidu.com/article/4ae03de32663953efe9e6b47.htmlToday miraculously found VBA, all blame oneself usually use excle not enough, VBA will excel automation, reduce a lot of tedious, a lot of repetitive workload, is a worthy of research, with the basis of programming language, I believe I can quickly understand the basic usage of the language, will bring significant bene

1 Option Explicit2 OptionBase13 4 SubFillsheet ()5 DimI as Long6 DimJ as Long7 DimCol as Long8 DimRow as Long9 DimArr () as LongTenrow = Application.inputbox (prompt:="Input row:", type:=2) OneCol = Application.inputbox (prompt:="input column:", type:=2) A ReDimarr (Row, col) - fori =1 toRow - forj =1 toCol theArr (i, j) = (I * j)Mod - - Next - Next - + 'need to select -Worksheets ("Sheet3"). Activate + DimRng asVariant A SetR

Referencing a dynamic-link library in ArcMapI built a dynamic link library file VBAPrj.dll under VB6, which has a class of module VBACLS, which has a method test (Doc as Object).There are three common methods ( author : Zhang):1. Open the VBA editor, click the References command under the Tools menu, and reference the dynamic link library in the References dialog box.The calling code is as follows:Dim Vbacls as New vbaprj.vbaclsVbacls.test (ThisDocume

In the work, often encounter from a bunch of rotten source in a list to filter out now also use the source file.This can save a lot of time if it is implemented in VBA, and it will not go wrong.Prerequisite Description:Place the list of file names you want to copy in the first column of the first sheet, and then execute the programFirst select the source directory and the destination directory, and then locate the files from the source directory, auto

1. Several different declarations: Public variables: Common variable name as data typePrivate variable: Private variable name as data typeStatic variable: Static variable name as data typeThe Dim declaration is the most common declaration, including the above three types, which are different scopes for the variables to choose how to declare, as we learn the programming language, global variables and local variables.2. Next scope: For example, our C language, global variables can be used througho

Python uses the Xlswriter module to easily create pictures in Excel, but you want to achieve the goal of importing images into your email by exporting the resulting chart chart as a picture. The online query did not find a way to export a picture that has been generated in Excel from a Python code to a picture, but by using the workaround, you can easily export the picture with a VBA macro in Excel. One, export a single picture Python Create chart P

VBA in this projectProgramI wrote a lot, but I also learned some experiences, which will be helpful for any language development in the future. The following are some of my development experiences. 1. overflow error One of the most common errors when I write a program to run a report is that the row end mark is a result or a total result. Then, I can determine whether a row has been found, when the position of the query insertion changes, or the ove

Serializing a Word document into XML from VBA using Visual Basic. NET Michael Corning Microsoft Corporation October 2002 Apply to: Microsoft®word 2002 Microsoft Visual studio®.net Summary: Learn how to use. NET code to quickly serialize large Word documents into XML in Microsoft Office Visual Basic for Applications (VBA) programs. Download or browse Setup.msi from the MSDN Downloads (English). (Note that in

As StringDim objVBAProject As VBE. VBProjectDim objVBComponent As VBE. VBComponentDim objVBFormComponent As VBE. VBComponentDim objObjectFormButton As ObjectObjShape = objWorksheet. Shapes. AddOLEObject ("Forms. CommandButton.1 ")ObjShape. Name = "btn1"ObjOLEObject = objWorksheet. OLEObjects ("btn1 ")TryObjCommandButton = TryCast (objOLEObject. Object, Forms. CommandButton)ObjCommandButton. Caption = "Click Me"StrModuleSnippet = "private sub btn1_Click ()" Chr (13 )_"UserForm1.Show" Chr (13)

In Excel The most commonly used function in a workbook should be Sum It is built in; of course, in Excel There are many built-in functions. However, we often use the functions Excel Is not provided directly, or we do not know, this can be used by ourselves VBA Define a function that you need to use to participate in the calculation of cells in the workbook, which may be a common problem in daily work. The following describes how to implement a UD

DLL export Function Definition --------------------------------------------------- _ Declspec (dllexport) int _ stdcall MyExportFunction (const char * p1, const char * p2, char * const out ); VBA processing (similar to VB.net processing) Note that the [char *] type in C is equivalent to [ByRef aa As Byte] in VBA (or VB. NET ]. --------------------------------------------------- Private Declare Function fnc

Distance education is nothing new, but the term is abused by the market too much.This gives us a question mark on how the course is going and how it works. I am very happy to introduce you to the learning blog of our Excel VBA students.In the future, the blog list of all oiio students will be sorted in this post.They have their understanding, inspiration, and feelings about the course. I believe that after three weeks of study, everyone will have diff

Powerdesigner vba creates tables and columns, powerdesignervba Creating powerdesigner tables and columns manually is very troublesome. Therefore, we need to use vba for implementation. We can refer to http://www.pudn.com/downloads447/sourcecode/database/detail1884121.html for reference: Create a table: Set mdl = ActiveModel Set table = mdl. Tables. CreateNew Table. Name = "tablename" Table. Code = "table" C

In work, Excel + VBA is often used for some data operations. When reading thousands of rows of data, a progress display is required. Although VBA has a progress bar with an active control, it cannot be used properly. So I made a self-made one and displayed it in the status bar. Code: 'Custom progress bar. Function getprogress (curvalue, maxvalue) dim I as single, J as integer is displayed in the status

Sub Rollup multiple workbooks ()application.screenupdating = FalseDim WB as Workbook, F as String, l as String, n as String, m as String, J as IntegerF = thisworkbook.path "\"L = f "*.xls"m = Dir (L)Do and M If m n = f MWorkbooks.Open (N)With Thisworkbook.activesheet. Range ("B4:at34"). ClearContentsFor i = 4 to. Range ("A1"). CurrentRegion.Rows.CountFor j = 2 to. Range ("A1"). Currentregion.columns.count-2 Step 3For each WB in WorkbooksIf WB. Name AA = Left (wb. Name, InStrRev (WB. Name, "."

IamlaosongUse the VBA program to work with Excel data files. The user's data files are sometimes in their own active filtering mode, often resulting in incorrect data processing. To do this, it is necessary to check whether the worksheet is in this mode, assuming that you remove your own active screening. Statements such as the following:If Activesheet.autofiltermode = True then Selection.autofilterThis statement is generally used only to remove its o

The effectivity is set in the cell, how to copy it through VBA? The code is as follows: Public SubCopy cell annotations ()DimRange1 as RangeDimRange2 as Range ' clears the G-Column Columns ("g:g").Clear SetRange1 = Range ("A1:A2") ' specifies the range of cells to copySetRange2 = Range ("D1") ' Specifies the location to copy (upper-left cell Range1. Copy Range2. PasteSpecial paste:=xlpastevalidation ' copy validity ' reclaims memorySetRange1 = Nothin