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