VBScript

Get Started. It's Free
or sign up with your email address
Rocket clouds
VBScript by Mind Map: VBScript

1. Intrisic Function

1.1. String Function

1.1.1. MsgBox

1.1.2. InputBox

1.1.3. Len

1.1.4. Asc

1.1.5. Chr

1.1.6. InStr

1.1.7. LCase

1.1.8. UCase

1.1.9. StrComp

1.1.9.1. 0 - binary comparation

1.1.9.2. 1 - non case sensitive comparation

1.1.10. Left

1.1.11. LTrim

1.1.12. RTrim

1.1.13. Mid

1.1.14. Right

1.1.15. String

1.2. Conversion Function

1.2.1. CByte

1.2.2. CDbl

1.2.3. CInt

1.2.4. Clng

1.2.5. CStr

1.3. Math Function

1.3.1. Abs

1.3.2. Array

1.3.3. Atn

1.3.4. Exp

1.3.5. Hex

1.3.6. Sgn

1.3.7. Int

1.3.8. Fix

1.3.9. Log

1.3.10. Rnd

1.3.11. Tan

1.4. Date Function

1.4.1. Date

1.4.1.1. Current Date

1.4.2. DateValue

1.4.2.1. Current Date and Time

1.4.3. Day

1.4.4. Hour

1.4.5. Minute

1.4.6. Second

1.4.7. Year

1.4.8. WeekDay

1.4.9. Month

1.4.10. Now

1.4.11. Time

1.5. Boolean Function

1.5.1. IsArray

1.5.2. IsDate

1.5.3. IsEmpty

1.5.4. IsError

1.5.5. IsNull

1.5.6. IsNumeric

1.5.7. IsObject

2. Operator

2.1. + (addition)

2.2. and (logic and)

2.3. & (concatenation)

2.4. / (division)

2.5. ^ (exponential)

2.6. \ (integer divide)

2.7. is (logical is)

2.8. Mod (remainder)

2.9. * (multiplication)

2.10. - (negation or substraction)

2.11. not (logical not)

2.12. or (logical or)

2.13. xor (logical xor)

3. Variable Declaration

3.1. Dim

3.2. Public

3.3. Private

4. Variable Naming Convention

4.1. Begin with alphabetic character

4.2. No period in the name

4.3. unique with the same scope

4.4. no longer 255 character

5. Variable Type and Sub Type

5.1. Byte

5.1.1. 0 ~ 255

5.2. Boolean

5.2.1. True or False

5.3. Currency

5.3.1. Monetary Value

5.4. Date

5.4.1. Date and Time

5.5. Double

5.5.1. Large Number with decimal

5.6. Empty

5.6.1. The value a variable holds before use

5.7. Error

5.7.1. an error number

5.8. Integer

5.8.1. -32768 ~ 32767 (2 ^ 16)

5.9. Long

5.9.1. 2 ^ 32

5.10. Object

5.10.1. object

5.11. Null

5.11.1. No valid data

5.12. Single

5.12.1. Large Number with decimal

5.13. String

5.13.1. Character String

6. Array

6.1. Dim

6.2. ReDim

6.3. UBound

6.4. LBound

7. Control Structure

7.1. If ... End if

7.2. If .. Else .. End If

7.3. If ... ElseIf .. End If

7.4. Select ... Case ... End Select

8. Looping

8.1. For ... Next

8.2. For Each ... Next

8.3. Do While ... Loop

8.4. Do Until ... Loop

8.5. While ... Wend

9. File System

9.1. Driver

9.1.1. Return all the drivers collection of computer

9.2. BuildPath

9.2.1. Append name to existing path

9.3. CopyFile

9.4. CopyFolder

9.5. CreateFolder

9.6. Existing Check

9.6.1. DriverExists

9.6.2. FileExists

9.6.3. FolderExists

9.7. Get Object Functions

9.7.1. GetAbsolutePathName

9.7.2. GetBaseName

9.7.3. GetDrive

9.7.4. GetDriverName

9.7.5. GetExtensionName

9.7.6. GetFile

9.7.7. GetFileName

9.7.8. GetFolder

9.7.9. GetParentFolderName

9.7.10. GetSpecificFolder

9.7.11. GetTempName

9.7.12. MoveFile

9.7.13. MoveFolder

9.7.14. GetFolder

9.7.15. GetSpecialFolder

9.7.16. DeleteFile

9.7.17. OpenTextFile

9.7.17.1. mode

9.7.17.1.1. 0 - for reading

9.7.17.1.2. 2 - forwriting

9.7.17.1.3. 8 - for appending

9.7.17.2. create

9.7.17.2.1. true - create a new file

9.7.17.2.2. false - not create new file

9.7.17.3. format

9.7.17.3.1. 0 - tristatefalse (ascii)

9.7.17.3.2. -1 tristatetrue (unicode)

9.7.17.3.3. -2 tristatedefault (system default)

9.7.18. Read(numchar)

9.7.18.1. AtEndOfStream

9.7.19. ReadAll

9.7.20. ReadLine

9.7.21. Skip

9.7.22. Write

10. Access Database

10.1. Directly

10.1.1. ADODB.Connection

10.1.1.1. CommandTimeout

10.1.1.2. ConnectionString

10.1.1.3. ConnectionTimeout

10.1.1.4. Mode

10.1.1.5. Provider

10.1.1.6. State

10.1.1.7. BeginTrans

10.1.1.8. Cancel

10.1.1.9. Close

10.1.1.10. CommitTrans

10.1.1.11. Execute

10.1.1.12. Open

10.1.2. ADODB.RecordSet

10.1.2.1. AddNew

10.1.2.2. Close

10.1.2.3. Delete

10.1.2.4. GetRows

10.1.2.5. GetString

10.1.2.6. Move

10.1.2.7. MoveFirst

10.1.2.8. MoveLast

10.1.2.9. MoveNext

10.1.2.10. MovePrevious

10.1.2.11. Collections

10.1.2.11.1. Fields

10.1.2.11.2. Properties

10.1.2.11.3. Count

10.1.2.11.4. Item

10.2. ODBC

10.2.1. ADODB.Connection

10.2.2. ADODB.RecordSet

10.2.3. DSN