,
2006
004.42(075.8)
32.973-01873
51
, , ..
..
51 . : . /.., ... : , 2006. 160 c.
( )
240401000 32.973-01873
.., 2006
..
, 2006
. 5
1 VBA.. 7
1.1 . 7
1.2 VBA.. 8
1.3 Visual Basic. 9
1.3.1 Project-VBAProject 9
1.3.2 . 11
1.3.3 . 14
1.3.4 Properties. 16
1.3.5 (Toolbox) 17
2 . 17
2.1 VBA.. 17
2.2 -. 18
2.3 -.. 20
2.4 . 20
2.4.1 . 20
2.4.2 .. 21
2.4.3 . 22
2.4.4 . 23
2.4.5 . 24
2.4.6 . 24
2.4.7 . 25
2.5 VBA.. 27
2.5.1 . 27
2.5.2 , VBA.. 28
2.5.3 . 28
2.5.4 . 30
2.6 , . 30
2.6.1 . 32
2.6.2 . 32
2.6.3 . 33
2.6.4 . 34
2.6.5 . 35
2.7 . 35
2.7.1 . 37
2.7.2 ( ) 38
2.7.3 . 39
2.7.4 .. 41
2.7.5 . 42
2.8 . 49
2.9 () 61
2.10 . 64
2.10.1 For Next 64
2.10.2 () 65
2.11 . 73
2.11.1 . 73
2.11.2 ( ) 74
|
|
2.12 .. 79
2.12.1 . 80
2.12.2 .. 81
2.12.3 . 82
2.12.4 . 83
2.12.5 . 83
2.12.6 .. 85
2.12.7 . . 87
3 - VBA.. 94
3.1 . 94
3.2 VBA.. 107
3.2.1 (MsgBox) 107
3.2.2 . 110
3.3 VBA: -, ,
. 117
3.4 VBA: . 126
3.5 VBA: . 133
3.5.1 . 135
3.5.2 . 136
3.5.3 . 139
3.5.4 . 142
3.6 VBA: . 144
3.6.1 . 145
3.6.2 . 146
3.7 : MS Excel MS Word. 149
3.7.1 MS Word CreateObject 149
3.7.2 MS Word GetObject 150
4 , . 160
, - , .
. - , .
, , . , , , . , , , , , , .
- MS Office, , , . Excel 2000/XP , c-.
, , . . , MS Office Visual Basic for Application (VBA), .
|
|
VBA , , : , , , - . .
. - , VBA , Windows. - , .
VBA Excel. , - , , , . , .
, VBA, , .
, , , .
1 VBA
1.1
: VBA.
- MS Visual Basic for Applications (VBA) . VBA - , MS Windows 95/98-XP. VBA Visual Basic (VB), , , .
VBA VB :
- MS Office. , .
- VBA MS Office;
- VBA , ;
- VBA , ;
- VBA , , ;
- VBA , ;
- VBA , . .
- VBA VB , VB, , VB- Automation .
|
|
, () Windows. -, . - , VBA , Windows.
: , , , , .. .
. : , , , ..
(, , ) . .
. , VBA Windows. <>.
() . VBA . , , .
, VBA - , . , , .
1.2 VBA
IDE (Integrated Development Environment ) VBA Windows- MS Excel :
1) →→ Visual Basic;
2) <Alt> + <F11>;
3) Visual Basic Visual Basic MS Excel.
VBA, 1.
Visual Basic :
1) View ()→MS Excel;
2) View MS Excel Standard.
, Windows-: , , , Project-VBAProject Properties.
Microsoft Visual Basic1.
, . , Windows-.
(Standard), , , VBA.
1 VBA
|
|
1.3 Visual Basic
Visual Basic :
- Project-VBAProject;
- ;
- ;
- ;
- .
1.3.1 Project-VBAProject
Project-VBAProject Visual Basic View→Project Explorer (→ ) Project Explorer Standard.
Project-VBAProject, 2, .
, :
- <View code> ( );
- <View object> ( ).
*.xls . , Explorer Windows.
2 Project-VBAProject
. ( ), . , , .
:
. Insert→Module (→).
, , .
Project-VBAProject . Project-VBAProject .
Insert→UserForm (→ ), - Insert→Class Module (→ ). , .
File→Remove _ (→), _ .
. , ( <Ctrl>).
1.3.2
.
.
(, ) View→Code (→), 3. , .
3
, . <Object> ( ), <Procedure> , , 4.
4
: . :
1) ( <Procedure View> , <Full Module View> );
2) Default to Full Module View ( ) Editor () Options (), Tools→Options (→).
, , , , , 5:
Auto List Members ( ), Auto Quick Info ( ), Auto Syntax Check ( ) Options ()→ Editor ().
|
|
, ( , ) . Procedure Separator ( ) Options ().
5 Options ()
, . , .
,
Range ("A1").
6, . <Tab> .
6
Auto List Members Editor Options, Tools→Options.
. , , , .
, , , 7.
7
, , Auto Data Tips Editor Options, Tools→Options.
VBA . , <Enter>, VBA , , (, ). , VBA , , . <Enter> VBA , , , - .
<Enter>. <Enter> , . . , Auto Syntax Check Editor Options, , , , .
1.3.3
. VBA , . , , .
( ) , (, , , .). , , Windows.
VBA UserForm, ( ). . , Tools→Options (→) ( General ()).
, , .
:
1) Visual Basic;
2) Insert→UserForm.
, 8.
8
1.3.4 Properties
( ) . . , 9, () . , , .
, :
- View→Properties Window (→ );
- Properties Window Standard.
: .
, .
: Alphabetic ( ) Categorized ( ), .
, .
9
1.3.5 (Toolbox)
, . : , , (), .. Controls ( ). , 10.
10
, , .
, . Tools→Additional Controls (→ ) .
, Format ().