vba if then statement

Procedures and parameters of VBA the procedure in VBA (Procedure) has two kinds, one called function and the other is subroutine (subroutine), using function and sub keyword respectively. They are an independent process that can get parameters, execute a series of statements, and change the values of their parameters. Unlike the Function procedure, a Sub procedure with a return value cannot be used in an ex

When we are programming with Excel, we often need to use a database. So how do you connect the database and then read the data from the database? VBA connects to an instance of SQL SERVER database: Dim strconn As String, strSQL as String Dim conn as ADODB. Connection Dim DS as ADODB. Recordset Dim col as Integer ' connect the database string strconn = ' Provider=SQLOLEDB.1; Persist Security info=true; User Id=[user]; Password=[password];initial

Technorati label: VBA, naming convention, constant, variable Generally, naming Rules use a lowercase prefix or suffix to specify the type and scope of a variable. The variable itself should use meaningful names to describe what it is or what it is to be done.A multi-character variable name is connected by several words. The first letter of each word is capitalized and no underline is used.. If you have used a variable name template, its format should

VBA is a non-mainstream language, and there may not be many people involved. Here I will talk about some superficial views on VBA. VBA is short for Visual Basic for Application. It has two major features: 1. It is a script language (interpretation and execution) that uses the BASIC syntax ), the other is that it is embedded into another application to control the

is Ctrl+f8), and you can run to that statement!The advantage of this approach is that you can bypass the block of statements that you do not want to execute (for example, you explicitly know a problematic statement).However, you can execute the tool----options----Editor----Automatic syntax detection, the Code window input code produces a syntax error, will immediately display an error message!Call stack: W

This article also published in Eng @ http://www.cnblogs.com/LarryAtCNBlog/p/4441201.htmlToday, in two places, you see a problem: Copy a table from Excel and save it as a standalone Excel file. One of them is cnblog, and the other can't remember. Thinking that he might encounter such problems in the future, he used PowerShell to make a script to prepare for a rainy day.PowershellOf course, the first thing to have an Excel file is to include a bunch of tables.Using scripting to automate Excel is t

Tags: VBA SQL Server Excel  VBA connects SQL Server database operations to Excel.Sub button 1_click ()Dim I As Integer, J As Integer, sht as Worksheet ' i,j As Integer variable, sht as an Excel sheet object variable, point to a worksheet' Dim cn as New ADODB. Connection ' Define the data link object, save the Connection database information; First, add the ADO reference' Dim rs as New ADODB. Recordset ' D

New Perspective of PPT -- basic information of VBA Application Technology Author: Zhu Jianguo Press: Electronic Industry Press ISBN: 9787121201196 Release Date: 388-1 published on: May 2013: 16: 1-1 category: computer> office software> Office> PowerPoint more about "" New PPT perspective-VBA Application Technology "Content Overview computer books new PPT perspective-VBA