VBA. Application, Workbook, Worksheet Range
VBA .
[1] VBA. , . Excel , , , . . . , . ; .
[2] VBA.
Sub ()
Dim As String
= Workbooks(" .xls").Author
MsgBox " : " &
End Sub
Sub End Sub, ( ).
, Visual Basic, .
Visual Basic
Visual Basic , .
Excel .xls , Author , :
Sub ()
Dim As String
Workbooks(" .xls").Author = " .."
End Sub
Sub ()
Dim As String
= Workbooks(" .xls").Author
MsgBox " : " &
End Sub
:
1. .xls.
2. // Visual Basic [Alt + F11] Visual Basic.
3. / (Insert/Module).
4. , .
5. Excel , .
, (. 2‑1). (Object) , . (Procedure) , . .
. 2‑1. Visual Basic
. , (Procedure View), . (Full Module View).
|
|
VBA . .
. , , (ThisWorkbook) ( , ). , ( ) ( ).
, Excel, .
UserForm (. 10.1) , ActiveX .
(. 2‑3) , .
/ :
(View/Project Explorer)
(View/Proreties Window)
(View/Object)
(View/Object Browser)
(. 2‑2).
, . (View) (. 1.2.5).
, UserForm Visual Basic, (Window).
: . , . , .
, Excel. , Visual Basic. , (, ), , :
Ø (Run) / / (Run Sub / UserForm)
Ø / (Run Sub/UserForm) (Standard) (. 2‑2)
Ø [F5].
(Standard), :
. 2‑2.
Microsoft Excel (View Microsoft Excel) Excel.
(Insert): , , .
(Save): . (Save) Excel , .
(Find) (Find) . .
(Toolbox): , .
(Object Browser) (. 2‑3). , , , . .
|
|
(Object Browser) :
Ø / (Project/Library) , . All Libraries .
Ø (Classes), ;
Ø (Members), .
. 2‑3. (Object Browser)