vba debug

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

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

Fully understand the PageSetup object of page SetupWhen we write VBA code, especially when we do small program development, we often use VBA to setThe options in the page setup, you can also use VBA to achieve some special effects, which requires theUse the Pagesteup object. The PageSetup object contains properties for all page settings (left margin, bottom edgeP

Write the Excel VBA tool to connect and manipulate the MySQL database.System environment:Os:win7 64-bit English versionOffice 2010 32-bit English version1, VBA before the preparation of the connection to MySQLTools--->references. ----> ReferencesTick Microsoft ActiveX Data Objects 2.8 Librarys and Microsoft ActiveX Data Objects Recordset 2.8 Librarys2. Install MySQL ODBC connection serviceDownload Connectio

) Determines the mandatory return of the message box. When these numbers are added to generate the buttons parameter values, only one number can be taken from each set of values.(2) These constants are specified by VBA and can be used in the program code in place of the actual values.4. Return valueConstants for the return value of the MsgBox functionConstant Value DescriptionvbOK 1 OKVbcancel 2 CancelVbabort 3 TerminationVbretry 4 RetryVbignore 5 ign

Compile Error:The code in this project must is updated for use on64-bit systems.Review and update Declare statements and then mark them with the Ptrsafe attribute.1. Question:32-bit VBA program that is running on the 64-bit system, this compilation error occurs.Environment: Office2010 Excel 64-bit, 64-bit Win7 OS?2. CausesIn the original program, the function is declared as follows. This function compiles and runs in the 32-bit system without problems

Recently in the project, to achieve the automatic generation of contracts, and then want to use VBA for the contract (Word version) in the same place in the bulk of the replacement.The field in the Word document is replaced by a label. The code is as follows:Public Function Updatebookmarkloop (app as Object, bookmarkbase as String, nvalue as Variant, bot as long, top as long) Dim counter As Long Dim name as String counter=1For counter=bot to top name=

　　The account manager visits a lot of customers every month, the company requires a visit record summary table and to make a visit to the customer's sub-table, so that the supervisor spot checks, the structure of a table. At this time, if a customer fills in a customer, it is very annoying and time consuming. We can do a VBA button, each month as long as the summary part is filled out, just click on the button, automatically generate and customer info

use Excel VBA programming to draw a hexagon on a form. This tutorial is to share with friends the use of Excel VBA programming on the form to draw a hexagonal method, the tutorial is very good, suitable for beginners to learn, recommend you to see it. Step 1 Open the Excel table and enter the VBE window. Insert the module. Programming in Module 1, declaring 4 functions, a structu

= Strresult ' The data in cell D1 Range ("D1″"). Value = Left (Range (A1″), StartNum-1) ' The data in cell E1 Range ("E1″"). Value = Right (range (B1″), Len (range ("B1″)"-j) End Sub The code is simple, using just a few VBA functions. Discuss: In fact, the code can be further simplified because VBA also has an array function (the Split function). If you want to make it generic, you can convert the

We introduced the service tag using the MEX contract to invoke the WCF service in COM in such a way that it is convenient to obtain metadata dynamically through the MEX endpoint, but sometimes the metadata of the service may contain sensitive information about the application that a malicious user can exploit. This means that some services may not publish metadata information through Mex for security reasons. If oh, some services do not publish metadata information, with typing is more cumbersom

Download the workbook online, found that there is a password!xxoo, since put on the Internet why to add a password ah?! Later on the internet to find a way to use VBA to crack the worksheet password, to share. First, when you try to open the workbook, you are prompted with a password: Using the shortcut key ctrl+f11, open the VBA editing interface and tap the submenu "module" under the "Insert

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