basic vba commands

Rearrange strings InStr left LTrim mid right RTrim trim like Working with strings Split Jion Splitting and connecting strings InstanceSub StrComp operation ()MsgBox StrComp ("ABCD", "ABCD", 1) ' parameter 1 in text comparison, case-insensitive, return 0, representing equalityMsgBox StrComp ("ABCD", "ABCD", 0) ' parameter 0, in binary comparison, returns-1, indicating that the former is less than the latterEnd SubSub StrConv operation ()Msg

--Will EXCEL VBA code porting to vb.net. NET is a new programming framework that Microsoft introduced in 2002 to support multiple language application development. Programming on the Microsoft. NET framework using Visual Basic, which is the Visual Basic.NET, referred to as vb.net.Vb. NET is Microsoft Visual Studio. NET component, which is a later version of VB6.0, vb.net still uses the

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 pro

property is the feature of the VBA object ' The method that represents the property of an object is ' object. Property = property value Sub ttt () Range ("A1"). Value = The End Sub Sub Ttt1 () Sheets (1). Name = "Worksheet renamed" End sub Sub Ttt2 () Sheets ("Sheet2"). Range ("A1"). Value = "ABCD" End sub Sub Ttt3 () Range ("A2"). Interior.ColorIndex = 3

Basic array knowledge, basic learning of vba Array /* ===================================================== ============================================================ Name: testArray. c Author: lf Version: Copyright: Your copyright notice Description: basic use of arrays ==============================================

Using VBA (Visual Basic for application) macros in office Office software Tang Tiexin Talk about macros, many people think of macro virus, in fact, if there is genuine anti-virus software, open real-time protection, set a good macro security, you can use macros to complete many office automation functions. Open the Word software, from the file main Menu "Tools"-> "Macros"-> "Security", set security to, s

VBA is the editing language, and macros are programs that are saved with VBA code. VBA code starts with a "sub macro name" and a pair of empty parentheses, ending with "End Sub". The module is where the save process is, and a module can hold several different types of processes. objects, workbooks, worksheets, cells, pictures, charts, pivot tables, et

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