vba compiler

This section describes how to use VBA to select a file and use VBA to open a file.Clicking open file will pop up a Windows File opening dialog box. In Excel, how does VBA implement this function? Sub selectfile ()Dim filename as Variant'The file name returned by the open file dialog box is a full-path file name. Its value may also be false, so the type is varian

Once saw a "excel-home" produced "About Excel suicide function" video tutorial, after careful study, I wrote down their code, share in this. Implementation ideas:Use VBA to create a hidden name, record the number of times the current workbook has been opened, and automatically delete the workbook if the number of times exceeds the specified value. Application Range:1, for VBA development, send s

001 -- On Error in common VBA commands) Everyone wants their programs to be smooth, but errors have always been a pain point in our hearts. We always jump out from time to influence our mood. Although the hop-out error prompt will interrupt the running of our program Just like our painful sensory nerves, it is a protection. It can avoid incorrect results or even catastrophic consequences. We can further program design and improvement to avoid errors a

Sub Mail_Text_in_Body ()Dim msg As String, cell As RangeDim Recipient As String, Subj As String, HLink As StringDim Recipientcc As String, Recipientbcc As StringRecipient = "someone@21cn.com"Recipientcc = ""Recipientbcc = ""Subj = "Testbodymail"Msg = "Dear customer"HLink = "mailto:" Recipient "? "" Cc = " Recipientcc " bcc = " Recipientbcc ""HLink = HLink "subject =" Subj ""HLink = HLink "body =" msgActiveWorkbook. FollowHyperlink (HLink)Application. Wait (Now + TimeValue ("0:00:03 "))Appli

Second floor Wolf Robot brotherA better solution has been provided. This article only sets this picture to record the concept of Lou pig analysis. Please skip this step if you are looking for answers ~~ Origin In Excel VBA programming, a user form is designed for input. The form contains one text box and two buttons. The text box is used for scanning gun input. The scanner is required to be input continuously, that is, each time a bar code is scan

= 1 thenSelection. offset (1, 0) = 10Elseif selection. value = 2 thenSelection. offset (1, 0) = 20Elseif selection. value = 3 thenSelection. offset (1, 0) = 30Elseif selection. value = 4 thenSelection. offset (1, 0) = 40Elseif selection. value = 5 thenSelection. offset (1, 0) = 50End ifAbout select case When you have to test many conditions, you can use the select case statement to replace if then... elseif. Syntax As follows: Sub test ()Select case selection. Value

A metaphor for objects and collectionsThe basic unit of Excel is the workbook object; In fast food chains, the basic unit is a single restaurant. Using Excel, you can add workbooks and close workbooks, and all open workbooks make up the Workbooks collection (a collection of Workbook objects). The operators of fast food chains can add restaurants and close restaurants, and can treat all restaurants in the chain as a "restaurant" collection (a "Restaurant" object).An Excel workbook is an object, b

Solution to DLL loading errors in VBA When you open the Excel file, this error occurs. From the VBA tool> reference, there will be lost xxx. This is because the reference path is faulty.1. Prohibit the use of macros first. Otherwise, the macro cannot be deleted when the reference is deleted.2. In the reference, the DLL that does not find the target file is displayed. Delete the DLL file and remember t

,{})) In general, JS anti-aliasing is not complicated, the outermost eval replaced document.write, the real code can be seen. But how do you implement this in VBA?Take a look at the following code:Dim odoc as Object,htmlSet odoc = CreateObject ("Htmlfile")Html= above the JS' Construct an HTML, replace the eval inside JS with document.write, do the anti-confusionhtml = "document.write (" Right (HTML, Len (HTML)-5)Odoc.write ("html = ""Odoc.write (HTM

scrx.value, Scry.valueEnd SubThis chapter reviews:1. All spaces have properties, methods, and events2. The format of the properties and methods of the access space are: space name, a dot number, properties and methods, provide parameters when needed3. When the program runs, the interaction between the user and the interface triggers events4. Show user forms with Show method5. Use the Initialize event to set values and add controls before the window is displayedThe 11th Chapter MicroStation obje

When you use Excel to write a VBA program, you use a ListBox, and then you examine all of its properties. In fact, this control function is very bad, too old, the most important thing is not support mouse wheel, very bad operation, but considering compatibility, or use it.In fact, reading, writing data with Listbox.list is enough, and BoundColumn and TextColumn is mainly used to read data, what kind of bird? I'm not sure, but I can use it like this. T

This article link: http://www.cnblogs.com/Charltsing/p/TripleDES.htmlAs we all know, the tripledes algorithm that Java uses by default is the Ecb+pkcs#5 fill method. The VB6 algorithm that can be found online is incompatible with this.Is there a simple way to achieve the common use between the two?As you know, C # is capable of implementing the TripleDES algorithm, so you can invoke the static class of. NET in VBA, VBS, and vb6.0 to implement an encry

BackgroundThe business needs to write all the corresponding pages according to the detailed design documentProblemHeavy workload, 11 large tables (dozens of hundreds of fields) time tight 3 days to completeCoreThere is a complete table design that can be edited manually through Excel.New issuesNormal field is not a problem, can increase the workload of the dictionary after a sudden increase, this particularity makes the work difficult and volume of the manual operation of Excel poses a challenge

The analysis of subway subsidence observation data using VBA programming processWhen you're tired of watching the day, you're back looking at hundreds of measurements and reporting. If it's a 35-page report, it's okay to say that if it's a 2000-point report, it will have about 70 pages of reports on a page of paper 30. As the force of the surveyors, but also more bitter force is no settlement data analysis software surveyors, but also more difficult t

The most by a friend set up a part-time operation of the company, but the need for some part-time staff pay, but due to a part-time wage between the 40~60, so the company adopted the principle is more than 200 to carry out, this rule is equivalent to drop the driver, the withdrawal needs more than 200, Then the problem came, in order to better let a large number of part-time staff can, clearly understand the time period in which they earn a lot of money, this time extended a problem, we need to

When you copy Sheet1 to Sheet3, you implement the following method:Worksheets ("Sheet1"). Copy after:=worksheets ("Sheet3") The syntax for using Worksheet.copy is as follows:An expression. Copy ( before, after)Before: inserting before a sheetAfter: inserting after a sheetNote: The above two parameters cannot be specified at the same time, and when none of the two parameters are specified, the sheet will be copied to a new workbook.Resources:Https://msdn.microsoft.com/zh-cn/

Range (Rows (3), rows (5)). Insert Shift:=xldown1) Insert a row at the current cell ; You can add a loop statement to insert multiple rowsRange ("A10"). SelectSelection.EntireRow.Insert, Copyorigin:=xlformatfromleftorabove2) Insert the same number of rows at the current selection row as the number of rows to select, and change the line number to insert in different places. Rows ("10:11"). Select Selection.insert Shift:=xldown, Copyorigin:=xlformatfromleftorabove3) Change range to Sheet1.c

Debugging VBA Programs: Setting breakpoints, stepping through, setting up a watch WindowThe Acces VBE programming environment provides a complete set of debugging tools and debugging methods. Master the use of these debugging tools and debugging methods, can quickly and accurately find the problem, and constantly modify, to improve.　　First, the "breakpoint" conceptA "breakpoint" is a point in a particular statement on a procedure that breaks the execu

Https://github.com/inshua/vba-interpreterHas covered almost all of the features of VB, but the library is not full.VB language itself is relatively backward, grammar also has a lot of improper design. The most serious is that both the function and the array are accessed through (), and the later extended item class members also use (), resulting in a clustered syntax ambiguity. But the form of return results taken by VB language 函数名=结果 is well suited

How to use VBA code to implement automatic daily backup of Excel documents To achieve this "tall yet" features existing Excel features cannot be completed, but also the method of VBA programming. Of course, as you do not understand the VBA code, just follow the steps below to copy and paste. Step 1th: Open the Excel file you want to back up, right-click on the