vba commands

IamlaosongThere is a pick report, want to first from the product information to separate the color information, and then based on the storage, name and color to create a pivot table, because the data is changed (structure is unchanged, the number of records will change), each re-creation is cumbersome, so want to make a tool, use VBA to separate colors and create a PivotTable report for others to The code that separates the colors is very good to writ

A procedure is a collection that executes one or more given tasks.into: subroutines and functions.1. Sub-Program[Private| Public | Friend] [StaticSub name [(arglist)][staements][Exit Sub][statements]End SubFriend indicates that the sub is visible throughout the project, but object instance controllers are not visible2. function, with return value[Private| Public | Friend] [StaticSub name [(arglist)] [ as type][statements][name= expression][Exit Function][statements][name = expression]End Funct

The difference between ByVal and ByRef To say that the difference between the two is what it is passing, perhaps this sentence is very vague, let us explain.1, byval-by value, that is to say, we pass to the function is a simple numerical past, the following code to help us understand: The code is as follows Copy Code Sub Run ()Dim I as Integeri = 1Add IMsgBox IEnd SubSub Add (ByVal i as Integer)i = i + 3End Sub The code above, the I value shown in the fina

In VBA programming, there are also debug features that are used, but are somewhat different from C # and C + +. Especially when you watch an object, you must select it, and then press shift +F9 to make quick watch. Please note the following points: Insert a breakpoint, put the mouse in front of a line of code, left mouse click can insert a breakpoint, cancel a breakpoint just click on the breakpoint on the left mouse button OK Single-Step ――――f8. Yo

Functional function DLookup (strfieldname, strTableName, strwhere, objconn) ' Refer to the DLookup function in Access VBA ' Because the environment is different, add the objconn parameter, direct adodb.connection direct redeployment to Dim strSQL Dim RS Set rs = server. CreateObject ("Adodb.recordset") ' Next to call a custom function outside the Checksql () strFieldName = Checksql (strfieldname) If strwhere strwhere = "where" Strwhere End If Strsql=

We'd better use the Sina Weibo open platform API to collect, of course, the API must have the app key Take the following procedure: 1. We know that VBA acquisition data often use an object is the Microsoft.XMLHTTP object, this time also use the object, so we first use VBA to create an object, as shown in the code is to create a Microsoft.XMLHTTP object 2. Then, we casually find an interface, such as we

In the new Office 2013 version, because of battery life and machine reliability, the removal of features such as macros, Third-party add-ons, and VBA will replace them with a new "cloud app model", a link between Microsoft and developers, and marketing/sales/ Deployment and other software aggregation. Developers have 80% of the gains from the platform, of which 20% are owned by Microsoft. The new version of Office is able to use the web as a workarou

1.VBA projects are commonly used in three types of inserts: Forms, modules, and a VBA-thisdrawing form, very simple, learn VB all understand The module is like a warehouse that provides rich functions and procedures for the form, thisdrawing code area Thisdrawing, through a small amount of practice, I regard him as the entry of VBA, the e

in the database through the background. The content and format of the report body are defined in the XML file. XML, as an effective tool for data transmission and storage, is no longer suitable for defining the subject content and content format of the stored report. As a configuration file, XML not only ensures the uniformity of the report format and content, but also makes the report changeable. The scope of change covers the report content and format. Javascript processes the obtained webpag

Excel and VBAProgramDesignThe current progress is around 75%. Chapter progress: 1. Preface (100%)2. Excel and macros (100%)3. VBA preliminary (100%)4. Apply VBA user-defined functions (100%)5. VBA language (100%)6. Excel Object Model (100%)7. Data Processing (100%)8.Drawing (10%)9.Interface Design (10%)10. Application Instance: batch data import system (100%)1

Technorati label: VBA, array (1) If you want to store values of different data types in the same array, you must declare the array as variant. Dim Exchange (5, 3) as Variant (2) If you 'd rather start counting your array's elements at 1, you can explain icitly specify a lower bound of the array by usingOption base 1Statement. This instruction must be placed in the Declaration section at the top of the VBA