(Sub), , (Function), . VBA : . . , , , .
. () . . ( Option). ( "= "). ( ), .
( Variant). , : (ByRef) (ByVal). . , ( !).
VBA . , . , , , , : Documents.Open(doc12.doc,,,,1). , : Documents.Open(PasswordDocument:= 1,FileName:=doc12.doc). , .
VBA , . , Option Explicit. VBA , , :
Dim i1 as Integer, i2 as Single
i2=10.5
For i1=1 to 10
i1=(i2+i1)/3
Next
.
. , , . VBA . : Const pi=3.14
( -, ): _ As
_ : Dim, Public, Private, Static. Dim , , , , . Public . . Option Private Module, Public . Private , . Static , .
|
|
VBA, -, . , , , .
.
: Integer, Long, String, Byte ..
. , Type. () , ( , !). , . dim public private .
:
Type rabotnic
ID As Integer
Name As String * 20
Address As String * 30
Phone As Long
HireDate As Date
End Type
Sub CreateRecord()
Dim r As rabotnic
r.ID = 12003
End Sub
, . .