- (). , VBA, . , , , , , .
- . , "". , . - -. , , . . .
VBA- , . , VBA MS Office 2007 - .
- , , . .
. . , .
: - . ? , , . ? ? , , . , : " " "". , , VBA. ? , , .
. , . , .
VBA :
.
. , - , :
. ()
, . VBA - , .
. , : Application.Quit, . , Application - "", Quit - "".
:
.=
.
|
|
: =. . . "" , .
- , , . , , txt_User_Name.Text="", ( txt_User_Name) "". , Text, .
, - . - , , .
- , . , , ..
. , - , . , - - .
, - Office.
Office
Office , . , . , Microsoft Word Word. , - Application, Microsoft Word. Application, , , , . , Microsoft Word:
Word.Application.Quit
MS Word Word, :
Application.Quit
Application , . , Application.Quit
, VBA - Object Browser. , F2
Object Browser
( Classes) , Word ( , Object Browser), Members of , .
, - , - .
, , .. ? - , , , , . , , .
, VBA, - Microsoft (www.microsoft.com).
, , ( - ), .
|
|
. , , , - . , , - - .
Office, . , Word, Excel - , . VBA Tools -> References ( o )
Microsoft Excel ( ) Microsoft Word, Excel Word. Project Explorer.
Microsoft Excel
Microsoft Excel Microsoft Word, MS Excel , MS Word ( ). - ADO ..
Office:
, MS Office (, Office XP, 2003) (Office 2007). , . , MS Word .doc ,.dot - , -.docx .docm ( , - ), . dotm - .
Office , , . , , , , *.doc - , , Office 2007 - Office 2007.
. , , Microsoft, . , Office 2007 (, OMath MS Word).
, Office, , .
5.3. :
MS Word -, cdo.krasgmu.ru.
5.4 :
- ;
- ;
- .
:
1. VBA?
2. ?
3. VBA.
:
1. MS OFFICE MS VISUAL BASIC ۅ
1)
2)
3)
4)
2. (USERFORM) VISUAL BASIC :
) "Insert UserForm" UserForm
) "Insert UserForm" Module
) Project(_) Insert - UserForm
|
|
) Project(_) Insert Module
1) ,
2) ,
3) ,
4) ,
3. ( LABEL) ȅ
) ,
) ,
) ,
)
1) ,
2) ,
3) ,
4) ,
4. ,
1) Ctrl + Al t + Break
2) Ctrl + Alt
3) Alt + Break
4) Ctrl + Break
5. " " ʅ
1) CheckBox
2) ComboBox
3) ListBox
4) TextBox
:
1
: , , , .
1. ?
2. normal.dotm? .
2:
Microsoft Word, :
: Times New Roman, 14-,
: .
3. , ?
4. , ?
6. : - 7 VBA.
7. , , .
12
: . . . .
2. : .
3. : , , .
4. :
- :
, , , , (-11);
, , , , (-12);
- :
, ;
, ;
.
5. :
5.1 :
- cdo.krasgmu.ru;
- 6 .
|
|
:
1. ( )
2.
3.
4. .
5. .
6.
, . , . .
:
, , , (, ).
. , . , , , , .
, ( ) . , , .
. , .. . .
, . (, , , ) . , . .
, , (). , ( , , ).
, . . . , , , , .
, , . , , . , , (, , , , ..).
.
.
(.. ). , , .
MS Access ( ) 255. 200 .
- , (, , , Ի - .