Excelオブジェクト

構文
DIM Excel = CREATEOLEOBJ("Excel.Application")

オブジェクト

AboveAverage
Action
Actions
AddIn
AddIns
AddIns2
Adjustments
AllowEditRange
AllowEditRanges
Application
Excelアプリケーション全体を表します。
Areas
Author
AutoCorrect
AutoFilter
AutoRecover
Axes
Axis
AxisTitle
Border
Borders
CalculatedFields
CalculatedItems
CalculatedMember
CalculatedMembers
CalloutFormat
CategoryCollection
CellFormat
Characters
Chart
ChartArea
ChartCategory
ChartFormat
ChartGroup
ChartGroups
ChartObject
ChartObjects
Charts
ChartTitle
ChartView
ColorFormat
ColorScale
ColorScaleCriteria
ColorScaleCriterion
ColorStop
ColorStops
Comment
Comments
CommentsThreaded
CommentThreaded
ConditionValue
Connections
ConnectorFormat
ControlFormat
CubeField
CubeFields
CustomProperties
CustomProperty
CustomView
CustomViews
DataBar
DataBarBorder
DataFeedConnection
DataLabel
DataLabels
DataTable
DefaultWebOptions
Dialog
Dialogs
DialogSheetView
DisplayFormat
DisplayUnitLabel
DownBars
DropLines
Error
ErrorBars
ErrorCheckingOptions
Errors
FileExportConverter
FileExportConverters
FillFormat
Filter
Filters
Floor
Font
FormatColor
FormatCondition
FormatConditions
FreeformBuilder
FullSeriesCollection
Graphic
Gridlines
GroupShapes
HeaderFooter
HiLoLines
HPageBreak
HPageBreaks
Hyperlink
Hyperlinks
Icon
IconCriteria
IconCriterion
IconSet
IconSetCondition
IconSets
Interior
IRtdServer
IRTDUpdateEvent
LeaderLines
Legend
LegendEntries
LegendEntry
LegendKey
LinearGradient
LineFormat
LinkFormat
ListColumn
ListColumns
ListDataFormat
ListObject
ListObjects
ListRow
ListRows
Mailer
Model
Model3DFormatModuleView
ModelChanges
ModelColumnChange
ModelColumnChanges
ModelColumnName
ModelColumnNames
ModelConnection
ModelFormatBoolean
ModelFormatCurrency
ModelFormatDate
ModelFormatDecimalNumber
ModelFormatGeneral
ModelFormatPercentageNumber
ModelFormatScientificNumber
ModelFormatWholeNumber
ModelMeasure
ModelMeasureName
ModelMeasureNames
ModelMeasures
ModelRelationship
ModelRelationships
ModelTable
ModelTableColumn
ModelTableColumns
ModelTableNameChange
ModelTableNameChanges
ModelTableNames
ModelTables
MultiThreadedCalculation
Name
Names
NegativeBarFormat
ODBCConnection
ODBCError
ODBCErrors
OLEDBConnection
OLEDBError
OLEDBErrors
OLEFormat
OLEObject
OLEObjects
Outline
Page
Pages
PageSetup
Pane
Panes
Parameter
Parameters
Phonetic
Phonetics
PictureFormat
PivotAxis
PivotCache
PivotCaches
PivotCell
PivotField
PivotFields
PivotFilter
PivotFilters
PivotFormula
PivotFormulas
PivotItem
PivotItemList
PivotItems
PivotLayout
PivotLine
PivotLineCells
PivotLines
PivotTable
PivotTableChangeList
PivotTables
PivotValueCell
PlotArea
Point
Points
ProtectedViewWindow
ProtectedViewWindows
Protection
PublishObject
PublishObjects
Queries
QueryTable
QueryTables
QuickAnalysis
Range
Ranges
RecentFile
RecentFiles
RectangularGradient
Research
RoutingSlip
RTD
Scenario
Scenarios
Series
SeriesCollection
SeriesLines
ServerViewableItems
ShadowFormat
Shape
ShapeNode
ShapeNodes
ShapeRange
Shapes
Sheets
SheetViews
Slicer
SlicerCache
SlicerCacheLevel
SlicerCacheLevels
SlicerCaches
SlicerItem
SlicerItems
SlicerPivotTables
Slicers
Sort
SortField
SortFields
SparkAxes
SparkColor
SparkHorizontalAxis
Sparkline
SparklineGroup
SparklineGroups
SparkPoints
SparkVerticalAxis
Speech
SpellingOptions
Style
Styles
Tab
TableObject
TableStyle
TableStyleElement
TableStyleElements
TableStyles
TextConnection
TextEffectFormat
TextFrame
TextFrame2
ThreeDFormat
TickLabels
TimelineState
TimelineViewState
Top10
TreeviewControl
Trendline
Trendlines
UniqueValues
UpBars
UsedObjects
UserAccess
UserAccessList
Validation
ValueChange
VPageBreak
VPageBreaks
Walls
Watch
Watches
WebOptions
Window
Windows
Workbook
WorkbookConnection
WorkbookQuery
Workbooks
Microsoft Excelアプリケーションで現在開かれているすべてのWorkbookオブジェクトのコレクションです。
Worksheet
WorksheetDataConnection
WorksheetFunction
Worksheets
WorksheetView
XmlDataBinding
XmlMap
XmlMaps
XmlNamespace
XmlNamespaces
XmlSchema
XmlSchemas
XPath
参考文献
Excel Visual Basic for Applications (VBA) リファレンス | Microsoft Docs

この記事は役に立ちましたか?
役に立った 役に立たなかった