VBA .
:
Object.Method
, , :
Object.Method Argumentl, Argument2, Argument3...
Object ;
Method , , ;
Argument1, Argument2 . VBA, , . ; .
4. Excel Activate, . ThisWorkbook , :
ThisWorkbook.Activate
Activate , , SaveAs Excel; :
ThisWorkbook.SaveAs Filename:="C\Temp\NEWFILE.xls"
3. Excel VBA
| Activate | Window, Workbook, Worksheet, Range . | |
| Calculate | , | Application, Range, Worksheet |
| Clear | , | Range |
| Close | Window, Workbook, Workbooks | |
| Justify | , | Range |
| Run | Application, Range | |
| Save | Application, Workbook | |
| SaveAs | Workbook, Worksheet | |
| Select | Range, Sheets, Worksheets | |
| SendKeys | host- | Application |
| Volatile | Application |
5. Clear
Sub TestMethodsOl()
' Clear
' Clear
MsgBox ActiveCell.Formula,, " Clear"
' Clear
ActiveCell.Clear
'
' Clear
MsgBox ActiveCell.Formula,, " Clear"
' :
Range("C6:D7").Clear
End Sub
| 
|
