(Properties), (Methods). , , . , Worksheet Calculate.
. , - . , , , , , , .
, :
.
, :
ActiveWorkbook.Save
, , .
.(1, 2,...)
. 1, 2,...
, Range Offset, , . :
.Offset(rowOffset,columnOffset)
rowOffset columnOffset . , , :
ActiveCell.Offset(0,1).Value
Offset Range, Value .
, VBA , , . , :
ActiveCell.Offset(columnOffset:=1).Value
, :=, .
Workbook Workbooks.
Activate
, .
Workbook. Activate
Add
Workbooks.
Add (Template)
Template , . : xlWBATChart, xlWBATExce14IntlMacroSheet, xlWBATExce14MacroSheet xlWBATWorksheet.
Template , , SheetsInNew Workbook
Protect
.
|
|
Protect (Password, Structure, Windows)
Password ,
Structure True ( , . . ) False ( )
windows True ( ) False ( )
:
ActiveWorkbook. Protect Password:=
Unprotect
.
Unprotect (Password)
Password ,
:
ActiveWorkbook. Unprotect Password: =
Close
Open
OpenText ,
Save
SaveAs .
SaveAs (Filename)
Filename , ,
:
ActiveBook. SaveAs Filename: =
SaveAsCopy , .
SaveAs (Filename, FileFormat)
Filename , ,
:
ActiveBook. SaveAsCopy Filename: =
PrintPreview
Printout