Index_X

 < Day Day Up > 



X

x-axis on a PivotChart, 346

x-axis title in a chart, 322

.xla file extension, 283

XLA file type, 239, 242

xlA1 constant, 180

xlAbsrowRelColumn constant, 180

xlBackgroundAutomatic constant, 232

xlBackgroundTransparent constant, 232

xlBetween constant, 188

XlBordersIndex constants, 236

XlBorderWeight constants, 236

xlBuiltinDialog constant, 384

xlBuiltinDialog property, 384

.xlc file extension, 283

XlCalculate constants, 156

xlCalculationAutomatic constant, 157

xlCalculationManual constant, 157

xlCalculationSemiautomatic constant, 157

xlCellType constants, 176

xlChart constant, 151

XlCmdType enumeration, 352

xlColorIndexAutomatic constant, 230, 236

xlColorIndexNone constant, 236

xlColumnDataType constants, 133

xlColumnField constant, 363

xlContinuous constant, 236

xlDash constant, 236

xlDashDot constant, 236

xlDashDotDot constant, 236

xlDatabase argument, 357

xlDataField constant, 363

xlDelimited constant, 133

xlDiagonalDown constant, 236

xlDiagonalUp constant, 236

xlDialog constants, 384

xlDialog intrinsic constants, 390

xlDialogActiveCellFont constant, 391

xlDialogAddChartAutoformat constant, 391

xlDialogAlignment constant, 391

xlDialogApplyNames constant, 392

xlDialogAutoCorrect constant, 392

xlDialogAxes constant, 391

xlDialogBorder constant, 386, 391

xlDialogCellProtection constant, 386, 388, 391

xlDialogChartAddData constant, 391

xlDialogChartWizard constant, 391

xlDialogColorPalette constant, 392

xlDialogColumnWidth constant, 392

xlDialogCreateNames constant, 392

xlDialogDataLabel constant, 391

xlDialogDataSeries constant, 391

xlDialogDefineName constant, 392

xlDialogDefineStyle constant, 392

xlDialogEditSeries constant, 391

xlDialogFilterAdvanced constant, 392

xlDialogFont constant, 390, 391

xlDialogFontProperties constant, 386, 391

xlDialogFormatChart constant, 391

xlDialogFormatCharttype constant, 392

xlDialogFormatFont constant, 391

xlDialogFormatLegend constant, 392

xlDialogFormatNumber intrinsic constant, 386

xlDialogFormulaGoTo constant, 385, 389

xlDialogGallery3dBar constant, 392

xlDialogGallery3dColumn constant, 392

xlDialogGallery3dLine constant, 392

xlDialogGallery3dPie constant, 392

xlDialogGalleryDoughnut constant, 392

xlDialogGalleryLine constant, 392

xlDialogGalleryPie constant, 392

xlDialogGoalSeek constant, 392

xlDialogInsertObject constant, 392

xlDialogMainChartType constant, 392

xlDialogOpen constant, 392

xlDialogPageSetup constant, 393

xlDialogPatterns constant, 386, 391

xlDialogSaveAs constant, 393

xlDialogSelectSpecial intrinsic constant, 386

xlDialogSendMail constant, 393

xlDialogShowToolbar constant, 393

xlDialogZoom constant, 393

xlDisplayShapes constant, 140

xlDMYFormat constant, 133

xlDot constant, 236

xlDot intrinsic constant, 59

xlDouble constant, 236

xlDYMFormat constant, 133

xlEdgeBottom constant, 236

xlEdgeLeft constant, 236

xlEdgeRight constant, 236

xlEdgeTop constant, 236

xlEMDFormat constant, 133

xlEqual constant, 188

xlErrors constant, 176

xlExcel4IntMacroSheet constant, 151

xlExcel4MacroSheet constant, 151

xlExclusive constant, 136

xlFileFormat constants, 136

xlFixedWidth constant, 133

xlGeneralFormat constant, 133

xlGreater constant, 188

xlGreaterEqual constant, 188

xlHairline constant, 236

xlHidden constant, 363

xlHide constant, 140

xlInputOnly validation type, 189

xlLess constant, 188

xlLessEqual constant, 188

XlLineStyle constants, 236

xlLineStyleNone constant, 236

XlListConflict constants, 543

XlListObjectSourceType constants, 543

xlLocalSessionChanges constant, 136

xlLocationAsNewSheet option, 323

xlLocationAsObject option, 323

xlLocationAutomatic option, 323

xlLogical constant, 176

.xlm file extension, 283

xlMDYFormat constant, 133

xlMedium constant, 236

xlNoChange constant, 136

xlNone constant, 155

xlNoRestrictions constant, 159

xlNoSelection constant, 159

xlNotBetween constant, 188

xlNotEqual constant, 188

xlNumbers constant, 176

xlOtherSessionChanges constant, 136

xlPageBreakManual constant, 155

xlPageBreakNone constant, 155

xlPageField constant, 363

XlPattern constants, 234

xlPatternAutomatic constant, 234

xlPatternChecker constant, 234

xlPatternCrissCross constant, 234

xlPatternDown constant, 234

xlPatternGray constants, 234

xlPatternGrid constant, 234

xlPatternHorizontal constant, 234

xlPatternLightDown constant, 234

xlPatternLightHorizontal constant, 234

xlPatternLightUp constant, 234

xlPatternLightVertical constant, 234

xlPatternNone constant, 234

xlPatternSemiGray75 constant, 234

xlPatternSolid constant, 234

xlPatternUp constant, 234

xlPatternVertical constant, 234

XlPivotFieldDataType enumeration, 354

XlPivotFieldOrientation constants, 362

XlPivotFieldOrientation types, 355

XlPivotFormatType formats, 350

xlPlaceHolders constant, 140

XlQueryType enumeration, 353

xlR1C1 constant, 180

xlReferenceStyle constants, 180

xlReferenceType constants, 180

xlRelative constant, 180

xlRelRowAbsColumn constant, 180

xlRowField constant, 363

.xls file extension, 135, 283

XLSaveConflictResolution constants, 136

xlShared constant, 136

xlSheetHidden constant, 150

xlSheetVeryHidden constant, 150

xlSheetVisible constant, 150

xlSkipColumn, 133

xlSlantDashDot constant, 236

xlSpecialCellsValues constants, 176

*.xlt file, opening for editing, 131

.xlt file extension, 283

xlTextFormat constant, 133

XlTextParsingType constants, 133

XlTextQualifer constant, 133

xlTextQualifierDoubleQuote constant, 133

xlTextQualifierSingleQuote constant, 133

xlTextValues constant, 176

xlThick constant, 236

xlThin constant, 236

xlUnderlineStyleDouble constant, 232

xlUnderlineStyleDoubleAccounting constant, 232

xlUnderlineStyleNone constant, 232

xlUnderlineStyleSingle constant, 232

xlUnderlineStyleSingleAccounting constant, 232

xlUnlockedCells constant, 159

xlUserResolution constant, 136

xlValidAlertInformation constant, 188

xlValidAlertStop constant, 188

xlValidAlertWarning constant, 188

xlValidateCustom validation type, 188, 189

xlValidateDate validation type, 188, 189

xlValidateDecimal validation type, 188, 189

xlValidateInputOnly validation type, 188

xlValidateList validation type, 188, 189

xlValidateTextLength validation type, 188, 189, 198

xlValidateTime validation type, 188, 189

xlValidateWholeNumber validation type, 188, 189

xlWorksheet constant, 151

xlXmlExportSuccess constant, 554

xlXmlExportValidationFailed constant, 554

xlXmlImportElementsTruncated constant, 555

xlXmlImportSuccess constant, 555

xlXmlImportValidationFailed constant, 555

xlYDMFormat constant, 133

xlYMDFormat constant, 133

XML, 3

adding to a workbook manually, 550-53

adding to a worksheet programmatically, 553-62

capabilities extended, 8, 9

elements, 548

files, 13, 550

map, 553

schema files, 548

support for, 539

XML data. See data files

XML Map Properties dialog box, 552

XML Maps dialog box, 551

XML Path language. See XPath

XML schemas. See schemas

XML Source task pane, 20

displaying, 547, 551

Options button, 552

XML Spreadsheet Schema, 9

XmlMap object, 553-56

XmlMap property, 542

XmlMaps collection, 555

XmlSchemas collection, 554

XPath, 557-62

xpos argument for an input box, 71

.xsd file, 10



 < Day Day Up > 



Microsoft Excel 2003 Programming Inside Out
Microsoft Office Excel 2003 Programming Inside Out (Inside Out (Microsoft))
ISBN: 0735619859
EAN: 2147483647
Year: 2006
Pages: 161

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net