Microsoft Corp., 2004. — 1506 p.
(Автор не указан).
This download contains documentation (such as programming references and technical articles), and may contain tools and sample code designed to help you customize Microsoft Office Excel 2003 and to extend Word and integrate with other applications.
Источник: сайт www.microsoft.com
Разработано для версии MS Excel 2003, но, в целом, применимо для более ранних и более поздних версий.
Файл перекомпилирован в формат PDF специально для сайта www.twirpx.com .
Contents:
Foreword.Microsoft Excel Visual Basic Reference.
Welcome to the Microsoft Excel 2003 VBA Language Reference.
Microsoft Excel Object Model.
What's New.New Objects.
New Properties (Alphabetic List).
New Properties (by Object).
New Methods (Alphabetic List).
New Methods (by Object).
New Events.
Concepts.Workbooks and Worksheets.
Creating a New Workbook.
Opening a Workbook.
Referring to Sheetsby Index Number.
Referring to Sheetsby Name.
Saving Documents as Web Pages.
Cells and Ranges.
How to Reference Cells and Ranges.
Looping Through a Range of Cells.
Selecting and Activating Cells.
Working with 3-D Ranges.
Working with the Active Cell.
Controls, Dialog Boxes, and Forms.
Using ActiveX Controls on Sheets.
Using ActiveX Controls on a Document.
Creating a Custom Dialog Box.
Using Microsoft Office Web Components on Forms.
Built-In Dialog Box Argument Lists.
Events, Worksheet Functions, and Shapes.
Using Events with Microsoft Excel Objects.
Using Microsoft Excel Worksheet Functions in Visual Basic.
Working with Shapes (Drawing Objects).
List of Worksheet Functions Available to Visual Basic.
Working with Other Applications.
Controlling One Microsoft Office Application from Another.
OLE Programmatic Identfiers.
Reference.
Collections.AddIns. AllowEditRanges. Areas. Axes. Borders. CalculatedFields. CalculatedItems. CalculatedMembers. ChartGroups. ChartObjects. Charts. Comments. CubeFields. CustomProperties. CustomViews. DataLabels. DiagramNodes. Dialogs. Errors. Filters. FormatConditions. HPageBreaks. Hyperlinks. LegendEntries. ListColumns. ListObjects. ListRows. Names. ODBCErrors. OLEDBErrors. OLEObjects. Panes. Parameters. Phonetics. PivotCaches. PivotFields. PivotFormulas. PivotItemList. PivotItems. PivotTables. Points. PublishObjects. QueryTables. Range. RecentFiles. Scenarios. Series. ShapeNodes. ShapeRange. Shapes. Sheets. SmartTagActions. SmartTagRecognizers. SmartTags. Styles. Trendlines. UsedObjects. UserAccessList. VPageBreaks. Watches. Windows. Workbooks. Worksheets. XmlMaps. XmlNamespaces. XmlSchemas.
Objects.AddIn. Adjustments. Allow EditRange. Application. AutoCorrect. AutoFilter. AutoRecover. Axis. AxisTitle. Border. CalculatedMtember. CalloutFormat. CellFormat. Characters. Chart. ChartArea. ChartColorFormat. ChartFillFormat. ChartGroup. ChartObject. ChartTitle. ColorFormat. Comment. ConnectorFormat. ControlFormat. Corners. CubeField. CustomProperty. CustomView. DataLabel. DataTable. DefaultWebOptions. Diagram. DiagramNode. DiagramNodeChildren. Dialog. DisplayUnitLabel. DownBars. DropLines. ErrorObject. ErrorBars. ErrorCheckingOptions. FillFormat. Filter. Floor. Font. FormatCondition. FreeformBuilder. Graphic. Gridlines. GroupShapes. HiLoLines. HPageBreak. Hyperlink. Interior. IRtdServer. IRTDUpdateEvent. LeaderLines. Legend. LegendEntry. LegendKey. LineFormat. LinkFormat. ListColumn. ListDataFormat. ListObject. ListRow. Mailer. Name. ODBCError. OLEDBError. OLEFormat. OLEObject. Outline. PageSetup. Pane. Parameter. Phonetic. PictureFormat. PivotCache. PivotCell. PivotField. PivotFormula. PivotItem. PivotLayout. PivotTable. PlotArea. Point. Protection. PublishObject. QueryTable. RecentFile. RoutingSlip. RTD. Scenario. Series. SeriesLines. ShadowFormat. Shape. ShapeNode. SmartTag. SmartTagAction. SmartTagOptions. SmartTagRecognizer. SoundNote. Speech. SpellingOptions. Style. Tab. TextEffectFormat. TextFrame. ThreeDFormat. TickLabels. TreeviewControl. Trendline. UpBars. UserAccess. Validation. VPageBreak. Walls. Watch. WebOptions. Window. Workbook. Worksheet. WorksheetFunction. XmlDataBinding. XmlMap. XmlNamespace Obiect. XmlSchema. XPath.
Methods.AcceptAllChanges. Activate. ActivateMicrosoftApp. ActivateNext. ActivatePrevious. Add. AddCallout. AddChartAutoFormat. AddComment. AddConnector. AddCurve. AddCustomList. AddDataField. AddDiagram. AddFields. AddFormControl. AddItem. AddLabel. AddLine. AddMtemberPropertyField. AddNode. AddNodes. AddOLEObject. AddPageItem. AddPicture. AddPolyline. AddReplacement. AddSet. AddShape. AddTextbox. AddTextEffect. AddToFavorites. AdvancedFilter. Align. Apply. ApplyCustomType. ApplyDataLabels. ApplyNames. ApplyOutlineStyles. AreaGroups. Arrange. AutoComplete. AutoFill. AutoFilter. AutoFit. AutoFormat. AutomaticLength. AutoOutline. AutoShow. AutoSort. Axes. BarGroups. BeginConnect. BeginDisconnecl. BorderAround. BreakLink. BreakSideBySide. BringToFront. BuildFreeform. Calculate. CalculatedFields. CalculatedItems. CalculateFull. CalculateFullRebuild. CancelRefresh. CanCheckIn. CanCheckOut. CentimetersToPolnts. ChangeFileAccess. ChangeLink. ChangePassword. ChangeScenario. Characters. ChartGroups. ChartObjects. ChartWizard. CheckAbort. CheckIn. CheckOut. CheckSpelling. CircleInvalid. Clear. ClearArrows. ClearCircles. ClearComments. ClearContents. ClearFormats. ClearNotes. ClearOutline. ClearSettings. CloneNode Methiod. Close. ColumnDifferences. ColumnGroups. CompareSideBySideWith. ConnectData. Consolidate. Convert. ConvertFormula. ConvertToShape. Copy. CopyFromRecordset. CopyPicture. CreateCubeFile. CreateNames. CreateNewDocument. CreatePivotTable. CreatePublisher. CreateSummary. CustomDrop. CustomLength. Cut. DataLabels. DataSeries. DDEExecute. DDEInitiate. DDEPoke. DDERequest. DDETerminate. Delete. DeleteAll. DeleteChartAutoFormat. DeleteCustomList. DeleteNumberFormat. DeleteReplacement. Deselect. DialogBox. Dirty. Disconnect. DisconnectData. DisplayXMLSourcePane. Distribute. DoubleClick. DoughnutGroups. DragOff. Duplicate. EditionOptions. EndConnect. EndDisconnect. EndReview. ErrorBar. Evaluate. ExclusiveAccess. Execute. ExecuteExcel4Macro. Export. ExportXml. Extend. FillAcrossSheets. FillDown. FillLeft. FillRight. FillUp. Find. FindFile. FindNext. FindPrevious. Flip. Follow. FollowHyperlink. Format. ForwardMailer. FunctionWizard. GetChartElement. GetCustomListContents. GetCustomListNum. GetData. GetOpenFilename. GetPhonetic. GetPivotData. GetSaveAsFilename. GoalSeek. Goto. Group. Heartbeat. Help. HighlightChangesOptions. Import. ImportXml. InchesToPoints. IncrementBrightness. IncrementContrast. IncrementLeft. IncrementOffsetX. IncrementOffsetY. IncrementRotation. IncrementRotationX. IncrementRotationY. IncrementTop. InputBox. Insert. InsertIndent. InstallManifest. Intersect. Item. Justify. LargeScroll. LegendEntries. LineGroups. LinkInfo. LinkSources. List. ListFormulas. ListNames. LoadSettings. Location. MacroOptions. MailLogoff. MailLogon. MakeConnection. Merge. MergeWorkbook. Modify. Move. MoveNode. NavigateArrow. NewSeries. NewWindow. Next. NextLetter. NextNode. NoteText. OLEObjects. OneColorGradient. OnKey. OnRepeat. OnTime. OnUndo. Open. OpenDatabase. OpenLinks. OpenText. OpenXML. Parse. Paste. PasteSpecial. Patterned. PickUp. PieGroups. PivotCache. PivotCaches. PivotFields. PivotItems. PivotSelect. PivotTables. PivotTableWizard. Play. Points. PointsToScreenPixelsX. PointsToScreenPixelsY. Post. PresetDrop. PresetGradient. PresetTextured. Previous. PrevNode. PrintOut. PrintPreview. Protect. ProtectSharing. Publish. PurgeChangeHistoryNow. Quit. RadarGroups. RangeFromPoint. RecheckSmartTags. Record. RecordMacro. Refresh. RefreshAll. RefreshData. RefreshTable. RegisterXLL. Regroup. RejectAllChanges. ReloadAs. RemoveAllItems. RemoveItem. RemoveSubtotal. RemoveUser. Repeat. Replace. ReplaceNode. Reply. ReplyAll. ReplyWithChanges. RerouteConnections. Reset. ResetAllPageBreaks. ResetColors. ResetPositionsSideBySide. ResetRotation. ResetTimer. Resize. RestartServers. Route. Row Differences. RTD. Run. RunAutoMacros. Save. SaveAs. SaveAsODC. SaveAsXMLData. SaveCopyAs. SaveWorkspace. ScaleHeight. ScaleWidth. Scenarios. ScrollIntoView. ScrollWorkbookTabs. Select. SelectAll. SendFaxOverInternet. SendForReview. SendKeys. SendMail. SendMailer. SendToBack. SeriesCollection. ServerStart. ServerTerminate. SetBackgroundPicture. SetDefaultChart. SetEditingType. SetExtrusionDirection. SetLinkOnData. SetParam. SetPasswordEncryptionOptions. SetPhonetic. SetPosition. SetSegmentType. SetShapesDefaultProperties. SetSourceData. SetThreeDFormat. SetValue. ShowMethod. ShowAllData. ShowDataForm. ShowDependents. ShowErrors. ShowLevels. ShowPages. Table. Text. TextToColumns. ToggleVerticalText. TransferChildren. Trendlines. TwoColorGradient. Undo. Ungroup. Union. Unlink. Unlist. UnMerge. Unprotect. UnprotectSharing. Update. UpdateChanges. UpdateFromFile. UpdateLink. UpdateNotify. UseDefaultFolderSuffix. UserPicture. UserTextured. Verb. Volatile. Wait. WebPagePreview. XmlDataQuery. XmlImport. XmlImportXml. XmlMapQuery. XYGroups. ZOrder.
Properties.Accent. AcceptLabelsInFormuias. Active. ActiveCell. ActiveChart. ActivePane. ActivePrinter. ActiveSheet. ActiveWindow. ActiveWorkbook. ActiveXControl. AddIndent. AddIns. Address. AddressLocal. AdjustColumnWidth. Adjustments. ADOConnection. AlertBeforeOverwriting. AlertStyle. Alignment. AllowDeletingColumns. AllowDeletingRows. AllowEdit. AllowEditRanges. AllowFillIn. AllowFiltering. AllowFormattingCells. AllowFormattingColumns. AllowFormattingRows. AllowInsertingColumns. AllowInsertingHyperlinks. AllowInsertingRows. AllowPNG. AllowSorting. AllowUsingPivolTables. AlternativeText. AltStartupPath. AlwaysSaveInDefaultEncoding. Angle. AnswerWizard. AppendOnImport. Application. ApplyPictToEnd. ApplyPictToFront. ApplyPictToSides. ArabicModes. ArbitraryXMLSupportAvailable. Area3DGroup. Areas. AskToUpdateLinks. Assistant. Author. AutoAttach. AutoCorrect. AutoExpandListRange. AutoFilter. AutoFilterMode. AutoFormat. AutoFormatAsYouTypeReplaceHyperlinks. AutoLayout. AutoLength. AutoLoad. AutoMargins. AutomaticStyles. AutomationSecurity. AutoPercentEntry. AutoRecover. AutoRepublish. AutoScaleFont. AutoScaling. AutoShapeType. AutoShow Count. AutoShow Field. AutoShowRange. AutoShowType. AutoSize. AutoSortField. AutoSortOrder. AutoText. AutoUpdate. AutoUpdateFrequency. AutoUpdateSaveChanges. AxisBetweenCategories. AxisGroup. AxisTitle. BackColor. Background. BackgroundChecking. BackgroundQuery. Backward. Bar3DGroup. BarShape. BaseField. BaseItem. BaseUnit. BaseUnitIsAuto. BCCRecipients. BeginArrowheadLength. BeginArrowheadStyle. BeginArrowheadWidth. BeginConnected. BeginConnected Shape. BeginConnectionSite. BlackAndWhite. BlackWhiteMode. BoldProperty. Border. Borders. BottomMargin. BottomRightCell. Brightness. BubbleScale. BubbleSizes. Build. BuiltIn. BuiltinDocumentProperties. CacheIndex. CalculateBeforeSave. CalculatedMembers. Calculation. CalculationInterruptKey. CalculationState. CalculationVersion. Caller. Callout. CanPlaySounds. CanRecordSounds. CapitalizeNamesOfDays. Caption. Category. CategoryLocal. CategoryNames. CategoryType. CCRecipients. CellDragAndDrop. Cells. CenterFooter. CenterFooterPicture. CenterHeader. CenterHeaderPicture. CenterHorizontally. CenterVertically. ChangeHistoryDuration. ChangingCells. Characters. CharacterType. Chart. ChartArea. Charts. ChartSize. ChartTitle. ChartType. CheckboxState. CheckIfOfficeIsHTMLEditor. Child. ChildField. ChildItems. Children. Choices. CircularReference. ClipboardFormats. CLSID. CodeName. Color. ColorIndex. Colors. ColorType. Column. Column3DGroup. ColumnFields. ColumnGrand. ColumnItems. ColumnRange. Columns. ColumnWidth. COMAddIns. CommandBars. CommandText. CommandType. CommandUnderlines. Comment. Comments. ConflictResolution. Connection. ConnectionSiteCount. Connector. ConnectorFormat. ConsolidationFunction. CbnsolidationOptions. CbnsolidationSources. ConstrainNumeric. Container. Contrast. ControlCharacters. ControlFormat. CopyObjectsWithCells. Corners. CorrectCapsLock. CorrectSentenceCap. Count. CreateBackup. Creator. Criteria1 . Criteria2 . CropBottom. CropLeft. CropRight. CropTop. Crosses. CrossesAt. CubeField. CubeFields. CubeFieldType. CurrentArray. CurrentPage. CurrentPageList. Contents. CurrentPageName. CurrentRegion. Cursor. CursorMovement. CustomDocumentProperties. CustomListCount. CustomProperties. CustomSubtotalFunction. CustomViews. CutCopyMode. DashStyle. DatabaseSort. DataBinding. DataBodyRange. DataEntryMode. DataField. DataFields. DataLabel. DataLabelRange. DataPivotField. DataRange. DataTable. DataType. Date1904 . DDEAppReturnCode. DecimalPlaces. DecimalSeparator. DefaultFilePath. DefaultSaveFormat. DefaultSheetDirection. DefaultValue. DefaultWebOptions. Delivery. Dependents. Depth. DepthPercent. Destination. Diagram. DiagramNode. Dialogs. DictLang. DirectDependents. Direction. DirectPrecedents. DisplayAlerts. DisplayAutoCorrectOptions. DisplayBlanksAs. DisplayClipboardWindow. DisplayCommentIndicator. DisplayDocumentActionTaskPane. DisplayDrawingObjects. DisplayEmptyColumn. DisplayEmptyRow. DisplayEquation. DisplayErrorString. DisplayExcel4Menus. DisplayFormulaBar. DisplayFormulas. DisplayFullScreen. DisplayFunctionToolTips. DisplayGridlines. DisplayHeadings. DisplayHorizontalScrollBar. DisplayImmediateItems. DisplayInkComments. DisplayInsertOptions. DisplayNoteIndicator. DisplayNullString. DisplayOutline. DisplayPageBreaks. DisplayPasteOptions. DisplayRecentFiles. DisplayRightToLeft. DisplayRSquared. DisplayScrollBars. DisplaySmartTags. DisplayStatusBar. DisplayUnit. DisplayUnitCustom. DisplayUnitLabel. DisplayVerticalScrollBar. DisplayWorkbookTabs. DisplayZeros. DivID. DocumentLibraryVersions. DoughnutHoleSize. DownBars. DownloadComponents. DownloadURL. Draft. DragToColumn. DragToData. DragToHide. DragToPage. DragToRow. Drilled. DrilledDown. Drop. DropDownLines. DropLines. DropType. EditDirectlyInCell. EditingType. EditWebPage. Elevation. EmailSubject. EmbedSmartTags. EmptyCellReferences. EnableAnimations. EnableAutoComplete. EnableAutoFilter. EnableAutoRecover. EnableCalculation. EnableCancelKey. Enabled. EnableDataValueEditing. EnableDrilldown. EnableEditing. EnableEvents. EnableFieldDialog. EnableFieldList. EnableItemSelection. EnableMultiplePageItems. EnableOutlining. EnablePivotTable. EnableRefresh. EnableResize. EnableSelection. EnableSound. EnableWizard. Enclosures. Encoding. End. EndArrowheadLength. EndArrowheadStyle. EndArrowheadWldth. EndConnected. EndConnectedShape. EndConnectionSite. EndStyle. EntireColumn. EntireRow. EnvelopeVisible. ErrorBars. ErrorCheckingOptions. ErrorMessage. Errors. ErrorString. ErrorTitle. EvaluateToError. Excel4IntlMacroSheets. Excel4MacroSheets. ExpandHelp. Explosion. ExtendList. Extent. ExtrusionColor. ExtrusionColorType. FeatureInstall. FetchedRowOverflow. FieldNames. FileConverters. FileDialog. FileFind. FileFormat. Filename. FileSearch. Fill. FillAdjacentFormulas. FilterMode. Filters. FindFormat. FirstChild. FirstPageNumber. FirstSliceAngle. FitToPagesTall. FitToPagesWide. FixedDecimal. FixedDecimalPlaces. Floor. FolderSuffix. Font. FontBold. FontItalic. FontName. Fonts. FontSize. FontStyle. FooterMargin. ForeColor. FormatConditions. FormControlType. Formula. Formula1 . Formula2 . FormulaArray. FormulaHidden. FormulaLabel. FormulaLocal. FormulaR1C
1. FormulaR1C1Local. Forward. FreezePanes. FullName. FullNameURLEncoded. Function. GapProperty. GapDepth. GapWidth. GenerateGetPivotData. GermanPostReform. GradientColorType. GradientDegree. GradientStyle. GradientVariant. GrandTotalName. GridlineColor. GridlineColorIndex. GroupItems. GroupLevel. Has3DEffect. Has3DShading. HasArray. HasAutoFormat. HasAxis. HasBorderHorizontal. HasBorderOutline. HasBorderVertical. HasDataLabel. HasDataLabels. HasDataTable. HasDiagram. HasDiagramNode. HasDisplayUnitLabel. HasDropLines. HasErrorBars. HasFormula. HasHiLoLines. HasLeaderLines. HasLegend. HasMajorGridlines. HasMemberProperties. HasMinorGridlines. HasPassword. HasPivotFields. HasRadarAxisLabels. HasRoutingSlip. HasSeriesLines. HasTitle. HasUpDownBars. HeaderMargin. HeaderRowRange. HeartbeatInterval. Hebrew Modes. Height. HeightPercent. Hidden. HiddenFields. HiddenItems. HiddenItemsList. HighlightChangesOnScreen. HiLoLines. Hinstance. HorizontalAlignment. HorizontalFlip. HPageBreaks. HTMLProject. HtmlType. Hwnd. Hyperlink. Hyperlinks. ID. Ignore. IgnoreBlank. IgnoreCaps. IgnoreFileNames. IgnoreMixedDigits. IgnoreRemoteRequests. IMEMode. InactiveListBorderVisible. InCellDropdown. IncludeAlignment. IncludeBorder. IncludeFont. IncludeNumber. IncludePatterns. IncludeProtection. InconsistentFormula. IndentLevel. Index. IndicatorColorIndex. InnerDetail. InputMtessage. InputTitle. InsertRowRange. InsideHeight. InsideLeft. InsideTop. InsideWidth. Installed. Interactive. Intercept. InterceptIsAuto. Interior. International. InvalidData. InvertIfNegative. IsAddin. IsCalculated. IsConnected. IsExportable. IsInplace. IsMtemberProperty. IsPercent. IsValid. Italic. Item. Iteration. KeepChangeHistory. KernedPairs. KoreanCombineAux. KoreanProcessCompound. KoreanUseAutoChangeList. LabelRange. LanguageSettings. LargeChange. LastChild. Layout. LayoutBlankLine. LayoutForm. LayoutPageBreak. LayoutSubtotalLocation. Lcid. LeaderLines. Left. LeftFooter. LeftFooterPicture. LeftHeader. LeftHeaderPicture. LeftMargin. Legend. LegendKey. Length. LibraryPath. Line. Line3DGroup. LineStyle. LinkedCell. LinkFormat. ListChangesOnNewSheet. ListColumns. ListCountProperty. ListDataFormat. ListDataValidation. ListFillRange. ListHeaderRows. ListIndex. ListObject. ListObjects. ListRows. ListSelection. LoadPictures. LocalConnection. Location. LocationInTable. LocationOfComponents. LockAspectRatio. Locked. LockedText. MacroType. MailEnvelope. Mailer. MailSession. MailSystem. MaintainConnection. MajorGridlines. MajorTickMark. MajorUnit. MajorUnitIsAuto. MajorUnitScale. ManualUpdate. Map. MapPaperSize. MarginBottom. MarginLeft. MarginRight. MarginTop. MarkerBackgroundColor. MarkerBackgroundColorIndex. MarkerForegroundColor. MarkerForegroundColorIndex. MarkerSize. MarkerStyle. MathCoprocessorAvailable. Max. MaxChange. MaxCharacters. Maximum. MaximumScale. MaximumScaleIsAuto. MaxIterations. MaxNumber. MDX. MemoryFree. MemoryUsed. MergeArea. MergeCells. MergeLabels. Message. Min. MinimumScale. MinimumScaleIsAuto. MinNumber. MinorGridlines. MinorTickMark. MinorUnit. MinorUnitIsAuto. MinorUnitScale. MissingItemsLimit. MouseAvailable. MoveAfterReturn. MoveAfterReturnDirection. MultiSelect. MultiUserEditing. Name. NameIsAuto. NameLocal. Names. Namespace. Native. NetworkTemplatesPath. New Workbook. Next. Nodes. NormalizedHeight. NullString. Number. NumberAsText. NumberFormat. NumberFormatLinked. NumberFormatLocal. Object. Obscured. ODBCErrors. ODBCTimeout. Offset. OffsetX. OffsetY. OLAP. OLEDBErrors. OLEFormat. OLEType. OmittedCells. On. OnAction. OnWindow. OperatingSystem. Operator. OptimizeCache. Order. OrganizationName. OrganizeInFolder. Orientation. Outline. OutlineFont. OutlineLevel. Overlap. PageBreakProperty. PageFieldOrder. PageFields. PageFieldStyle. PageFieldWrapCount. PageRange. PageRangeCells. PageSetup. Panes. PaperSize. Parameters. Parent. ParentField. ParentGroup. ParentItem. ParentItems. ParentShow Detaii. Password. PasswordEncryptionAlgorithm. PasswordEncryptionFileProperties. PasswordEncryptionKeyLength. PasswordEncryptionProvider. Path. PathSeparator. Pattern. PatternColor. PatternColorIndex. Period. Permission. PersonalViewListSettings. PersonalViewPrintSettings. Perspective. Phonetic. PhoneticCharacters. Phonetics. PictureFormat. PictureType. PictureUnit. Pie3DGroup. Pivo