display pdf winform c# : Rotate pdf page few degrees Library control component .net web page winforms mvc 7053154973-Excel%202007%20VBA%20Programmers%20Reference%20-%20Wrox%202007112-part631

ColumnDifferencesmethod,Rangeobject,859
ColumnLevelsparameter,797
columns attribute,301
Columnsproperty
Applicationobject,646
overview,112–114
Rangeobject,853
Worksheetobject,955
ColumnWidthproperty,23,24,279,853
COM Add-in Designer,396–408
creating custom task panes,404–405
linking to Excel,397–401
adding CommandBarcontrols,398–401
overview,397–398
responding to Excel’sevents,398
linking to multiple Office applications,407–408
showing VBA UserForms as task panes,405–406
using COM Add-In from VBA,401–403
adding Ribboncontrols,402–403
overview,401–402
COM Add-inscollection,407,997–999
COM Add-ins dialog box,396,398,405
COMAddinObject,997–999
COMAddInsproperty,Applicationobject,646
ComandBars.ExecuteMsomethod,316
combo boxes,adding,149–153
date format problems,151–152
getting exact date,152–153
<comboBox ...> contents </comboBox>container
control,300
ComboBoxcontrol,214,315
ComboBoxobject,150,216,218
COMDLG32.DLLfile,602
command bars
built-in,322–325
controls at all levels,325–330
creating new menus,330–333
creating toolbars,335–338
deleting menus,334
passingparameter values,333–334
popup menus,338–341
showing popup command bars,342–353
toolbars,menu bars,and popups,320–322
command button,13–16,26,153,155,157,214,233,
274,282,283,321,619
Commandobject
ActiveConnectionproperty,457
CommandTextproperty,446,447,457
methods,446–447
parameterscollection,446,457,460
properties,446,459
Command type,446,458,473–478,485,786,788,808
Commandtypeproperty,474
CommandBarcontrols,398–401
CommandBar extensions,for RibbonX,316
CommandBarobject,576,999–1002
CommandBarproperty,CommandBarPopupobject,1013
CommandBarButtonevents,398,576
CommandBarButtonobject,1003–1006
CommandBarComboBoxobject,1006–1009
CommandBarControlobject,1010–1013
CommandBarControlscollection,1010–1013
CommandBarEventsobject,980–981
CommandBarEventsproperty,Eventsobject,982
CommandBarPopupobject,1013–1015
CommandBarscollection,319,321,326,330,333,337,
341,343,347,349,995,999–1002,1007,1014
CommandBarsobject,293,316,317,348,398
CommandBarsproperty
Applicationobject,646
MsoEnvelopeobject,1046
VBE,989
Workbookobject,938
CommandBars.Reset,349
CommandButton,275,276,596
CommandButtoncontrol,276
CommandLineSafe value,396
Commands list,556
CommandTextargument,439,440
CommandText operation,439
CommandTextproperty,446,447,454,457,474,477,
482,847
CommandText type,440
CommandTypeproperty
QueryTableobject,847
Recordsetobject,446
CommandTypeEnumvalue,440
CommandUnderlinesUnderlinesproperty,
Applicationobject,646
Commentobject,714–716
Commentproperty
Rangeobject,853
Scenarioobject,871
comments,XML,241
Comments box,381,588
Commentscollection,714–716
Commentsproperty
DocumentLibraryVersionobject,1027
Worksheetobject,955
CompareSideBySidemethod,Windowsobject,930
Complex add-in,390,394
Complexclass,401
Component tab,389
CONCATENATEfunction,74
Conditionobject,750,753
1088
ColumnDifferences method,Range object
Rotate pdf page few degrees - rotate PDF page permanently in C#.net, ASP.NET, MVC, Ajax, WinForms, WPF
Empower Users to Change the Rotation Angle of PDF File Page Using C#
pdf reverse page order online; how to rotate just one page in pdf
Rotate pdf page few degrees - VB.NET PDF Page Rotate Library: rotate PDF page permanently in vb.net, ASP.NET, MVC, Ajax, WinForms, WPF
PDF Document Page Rotation in Visual Basic .NET Class Application
how to reverse page order in pdf; pdf save rotated pages
Conditionscollection,711,750,753,763
Conditionvalueobject,716,728
ConflictResolutionproperty,Workbookobject,938
Connectclass,402
Connect optionEnumvalue,439
Connectproperty,973,998
Connectedproperty,SharedWorkspaceobject,1054
Connectionevents,441
Connectionfile,470,484,490,785,788
Connectionobject
collections,441
events,440–441
Executemethod,443,446,447
methods,439–440
properties,437–438
Recordsetobject,462
Connectionparameter,836
Connectionproperty,482,790,809,847
Connectionstring argument,439
Connectionstring property,439
Connections button,470,471,486
Connectionscollection,487–489,490
Connections dialog box,470,484,485
Connectionsobject,716–717
Connectionsproperty,Workbookobject,938
ConnectionsDisabledproperty,Workbookobject,938
ConnectionSiteparameter,718
ConnectionSiteCountproperty
Shapeobject,882
ShapeRangeobject,888
ConnectionStringproperty,Connectionobject,438
ConnectionTimeoutproperty,Connectionobject,438
Connectorformatobject,717–719
Connectorproperty
Shapeobject,882
ShapeRangeobject,888
ConnectorFormatobject,717–719
ConnectorFormatproperty
Shapeobject,882
ShapeRangeobject,888
Consolidatemethod,Rangeobject,860
ConsolidationFunctionproperty,Worksheet
object,955
ConsolidationOptionsproperty,Worksheet
object,955
ConsolidationSourcesproperty,Worksheet
object,955
Const keyword,44
constants,33,44,606–609
ConstrainNumericproperty,Applicationobject,646
containercontrols,298,300
Containerproperty,Workbookobject,938
Content button,489
Contentproperty,Actionobject,638
ContentControlproperty,CustomTaskPane
object,1016
ContentTypePropertiesproperty,Workbook
object,938
ContentVerificationResultsproperty,
SignatureInfoobject,1063
Contextproperty
CommandBarobject,1001
IRibbonControlobject,1042
ContourColorproperty,ThreeDFormatobject,911
ContourWidthproperty,ThreeDFormatobject,911
<control .../>control type,299
controlattributes,301
control ID,302,304,310,344,346,347
control images,305,316,324,354
control menu,282
control reference,304
control Toolbox,12,496,579,580
control types,298,299,301,305,307,308,313,318,327
ControlCharactersproperty,Applicationobject,646
ControlFormatobject,719–721
ControlFormatproperty,Shapeobject,882
ControlFormatTypeproperty,Shapeobject,882
controls,209–221
ActiveXcontrols,210–214
CheckBoxcontrol,212
dynamic,216–219
Option Buttoncontrols,212–214
Scrollbarcontrol,211
Spin Buttoncontrol,211–212
adding,209–221,347,594,986
on charts,220–221
Formscontrols,214–216
controlscollection,321,322,330,332,337,341,369
controls dialog box,12,13
controls group,12,209,495,496
Controlsproperty
CommandBarobject,1001
CommandBarPopupobject,1014
controlSourceproperty,276
conversionfunctions,542
Application.Evaluatefunction,544–545
DateValueUSfunction,544–545
IsDateUSfunction,544
overview,544
CBoolfunction,542
CBytefunction,541
CCurfunction,541
CDatefunction,541
CDblfunction,541
CDecfunction,541
CIntfunction,541
1089
conversion functions
I
n
d
e
x
VB.NET Image: Using VB.NET Web Image Viewer to Process Web Images
types, including JPEG, PNG, GIF, BMP, TIFF, PDF, Word. btnRotate270 API can be used to rotate currently displayed image or document page 90 degrees
pdf rotate just one page; how to permanently rotate pdf pages
Process Images in Web Image Viewer | Online Tutorials
Commonly used document types are supported, including PDF, multi-page TIFF This JavaScript API is used to rotate the current image / page 90 degrees
pdf page order reverse; pdf rotate page and save
conversionfunctions (continued)
CLngfunction,541
CSngfunction,541
CStrfunction,541
DateValuefunction,541
Formatfunction,542
FormatCurrencyfunction,542
FormatDateTimefunction,542
FormatNumberfunction,542
FormatPercentfunction,542
IsDatefunction,541
IsNumericfunction,541
sNumToUSfunction,542–543
Strfunction,542
Valfunction,543–544
ConvertFormulafunction,Applicationobject,560,657
ConvertFormulaLocalefunction,557,558,559
Coordinateproperty,Actionobject,638
Copy button,297
Copy command,321
Copy menu,298
Copymethod
ChartAreaobject,697
Chartscollection,686
CommandBarButtonobject,1005
CommandBarComboBoxobject,1009
CommandBarControlobject,1012
CommandBarPopupobject,1015
Rangeobject,25,860
Seriesobject,876
Shapeobject,884
Sheetscollection,892
TextRange2object,1071
Worksheetobject,85–87,355,959
Worksheetscollection,954
Copystatement,266
CopyVariantmethod,705,794
CopyFacemethod,CommandBarButtonobject,1005
CopyFromRecordsetmethod,420,445,450,517,860
CopyObjectsWithCellsproperty,Application
object,646
CopyPicturemethod
Chartobject,691
Rangeobject,860
Shapeobject,884
CorrectCapsLockproperty,AutoCorrectobject,666
CorrectSentenceCapproperty,AutoCorrectobject,666
Countmethod,ShapeNodescollection,886
Countparameter,686
Countproperty
Addinscollection,635
Adjustmentsobject,640
AllowEditRangescollection,641
Areascollection,664
CalculatedMemberscollection,678
Charactersobject,684
Employeescollection,360
overview,995
Pagescollection,797
Rangeobject,100,853
Rowsobject,112
SeriesCollectionobject,221
Worksheetscollection,53,375
COUNTAfunction,130
CountLargeproperty,100,853
CountOfDeclarationLinesproperty,CodeModule
object,975
CountOfVisibleLinesproperty,CodePaneobject,978
CountOfLinesproperty,CodeModuleobject,975
CREATE GLOBAL CUBEstatement,522
Create itemmethod,413,423
Createmethod,165,807
CreateBackupproperty,Workbookobject,938
CreateCTPmethod,ICTPFactoryobject,1041
CreateCubeFilemethod,521–522
CreatedByproperty
SharedWorkspaceFileobject,1056
SharedWorkspaceLinkobject,1058
SharedWorkspaceTaskobject,1061
WorkflowTaskobject,1077
CreatedDateproperty
SharedWorkspaceFileobject,1056
SharedWorkspaceLinkobject,1058
SharedWorkspaceTaskobject,1061
WorkflowTaskobject,1077
CreateEventProcmethod,CodeModuleobject,976
CreateNamesmethod,Rangeobject,860
CreateNewmethod,SharedWorkspaceobject,1055
CreateParametermethod,Recordsetobject,446–447
CreatePictureAccount method,IBlogPicture
Extensibilityobject,1041
CreatePivotTablemethod,164–166,170
CreateSummarymethod,Scenarioobjects,871
CreateToolbar,336
CreateToolWindowmethod,Windowcollection,993
Creatorproperty,635,636,995,996
Criteria range,156,559
cross tabulation tables,161
Crossesproperty,Axisobject,671
CrossesAtproperty,Axisobject,671
CSngfunction,541
CStrfunction,541,542
C-style declarations,interpreting,603–606
CSysInfoclass,619
CTempfile,611
CTPfunctionality,405
1090
conversion functions (continued)
C# Image: C# Image Web Viewer Processing Tutorial; Process Web Doc
In order to rotate a current web image or by editing your C# project web page Default.aspx provide powerful & profession imaging controls, PDF document, tiff
reverse page order pdf online; rotate pdf pages
VB.NET Image: Generate GS1-128/EAN-128 Barcode on Image & Document
resolution barcode.Rotate = Rotate.Rotate0 'set rotate barcode.DrawBarcode Its supported document types are PDF, Word and EAN-128 barcode on multi-page TIFF/PDF
pdf rotate pages separately; how to rotate pdf pages and save permanently
CTP-creation features,409
CTPFactoryAvailablemethod,ICustom
TaskPaneConsumerobject,1042
Ctrlobject,577
Cubefieldmethods,724
Cubefilemethod,521
CubeFieldobject,721–724,917
CubeFieldscollection,721–724
cubes,508,512,514,516,518–521,523
Currency (sealed integer) data type,43
Currencyobject,901
CurrentArrayproperty,Rangeobject,853
CurrentRegionproperty,108–110,123,422,853
Cursortypeproperty,463
CursorLocationproperty,Recordsetobject,442
CursorMovementproperty,Applicationobject,646
CursorPointerproperty,Applicationobject,646
Custom Filter,148,755
Custom menu,334,343–345,351,352,575,577
Custom option,542
Customparameter,657
Customproperties collection,724
custom task panes,383,403–405,409,1016
CustomDocumentPropertiesproperty,Workbook
object,938
CustomDropmethod,CalloutFormatobject,681
Customers table,432–435,456,473,474,484,485
CustomersTable.odcfile,485
customization,158,294,295,297,303,309,313,314,
382,383,405,409,999,1002,1043
Customization button,158
customizedobjects,355
CustomLengthmethod,CalloutFormatobject,681
CustomListCountproperty,Applicationobject,646
CustomOrderproperty,SortFieldsobject,897
CustomPropertiescollection,724–726
CustomPropertiesproperty,Worksheetobject,956
CustomPropertyobject,724–726
CustomTaskPaneobject,1016
customUI,294–296,306–313,316,403
CustomUImethod,317
CustomViewobject,726–727
CustomViewscollection,726–727
CustomViewsproperty,Workbookobject,938
CustomXMLNodeobject,1017–1020
CustomXMLNodescollection,1017–1020
CustomXMLPartobject,1020–1022
CustomXMLPartscollection,317,1020–1022
CustomXMLPartsproperty,Workbookobject,938
CustomXMLPrefixMappingobject,1022–1023
CustomXMLPrefixMappingscollection,1022–1023
CustomXMLSchemaobject,1023–1024
CustomXMLSchemaCollectionobject,1023–1024
CustomXMLValidationErrorobject,1024–1025
CustomXMLValidationErrorsCollectionObject,
1024–1025
Cut button,321
Cutmethod
Rangeobject,860
Shapeobject,884
TextRange2object,1071
CutCopyModeproperty,Applicationobject,646
D
Data Connection Wizard,509
Data Connections section,490
Data field,169,170
Datafieldobject,144
DataFormfeature,158–159,160
Data group,182,469,470
Data Labels button,195
data lists,141–160
Advanced Filter,156–158
AutoFilterfeature,146–156
adding combo boxes,149–153
AutoFilterobject,147–148
copying visible rows,153–154
Date Custom Filter,148–149
Filterobject,148
finding visible rows,154–156
creating tables,144–145
Data Form,158–159
sorting ranges,142–144
sorting tables,145–146
structuring data,141–142
Dataobject,557
data strings,reading,229
Data tab,128,142,146,157,469,484,508,716
Databarmethods,729
Databarobject,716,727–729
DataBindingBindingproperty,XmlMapobject,968
DataEntryModeproperty,Applicationobject,646
DataLabelobject,729–734
DataLabelproperty,174,918
DataLabelscollection,729–734
DataLabelsmethod,Seriesobject,876
DataLists,344,345,349,352
DataRangeproperty,174,175
DataSeriesmethod,Rangeobject,860
DataTableobject,734–735
DataTableproperty,Chartobject,687
date
format problems,151
getting exact,152
date custom filter,148–149
1091
date custom filter
I
n
d
e
x
VB Imaging - Linear ITF-14 Barcode Generator
Spend a few seconds creating ITF-14 barcode in Resolution = 96 'set rotation barcode.Rotate = Rotate.Rotate0 barcode to Create ITF-14 in Certain PDF Page Area.
rotate all pages in pdf file; rotate pages in pdf
C# TIFF: Create Linear and 2D Barcodes on TIFF Document Using C#
C# TIFF PDF - 417 Creating, C# TIFF ISBN Creating. Creator Add-on for TIFF allows C# users to generate GS1-128/EAN-128 barcode on TIFF file page with high print
rotate all pages in pdf; rotate pdf page permanently
Datedata type,43
Date Filters,148,818
DATEfunction,73,74,87,542,543,544,547
date literals,540,541
date order,538,542,551,552,555,556
Date Order setting,538
Date Picker button,403
Dateproperty,PolicyItem,1051
date separator,538,551,552
Date1904property,Workbookobject,939
DateSerialfunction,73,87,152,153,413
DateValuefunction,87,541,544
DateValueUSfunction,544,545
DDEAppReturnCodeproperty,Applicationobject,646
DDEExecutemethod,Applicationobject,657
DDEInitiatemethod,Applicationobject,657
DDEPokemethod,Applicationobject,657
DDERequestmethod,Applicationobject,657
DDETerminatemethod,Applicationobject,658
Deactivateevent,91
Chartobject,695
Workbookobject,952
Worksheetobject,963
Debug toolbar,29,579
Decimaldata type,43
DecimalSeparator,530,538,552,553,555,556,558,
646,867
(Declarations) section,39–42,44,55–57,109,118,
131,216,283,358,365,593,977
Declarefunction,584
Declarestatement,602
DecryptStreammethod,EncryptionProvider
object,1031
Defaultproperty,OK button,281
DefaultFilePathproperty,Applicationobject,647
DefaultPivotTableStyleproperty,Workbook
object,939
DefaultSaveFormatproperty,Applicationobject,647
DefaultSheetDirectionproperty,Application
object,647
DefaultSpacingproperty,TabStops2collection,1068
DefaultTableStyleproperty,Workbookobject,939
DefaultWebOptionsobject,735–737
DefaultWebOptionsproperty,Applicationobject,647
Definition tab,486
Delete button,283
Deletemethod
AboveAverageobject,638
AllowEditRangeobject,642
Axisobject,673
AxisTitleobject,675
CalculatedMemberobject,679
Charactersobject,685
Chartobject,691
Chartscollection,686
CommandBarobject,1002
CommandBarButtonobject,1005
CommandBarComboBoxobject,1009
CommandBarControlobject,1012
CommandBarPopupobject,1015
CustomTaskPaneobject,1016
CustomXMLNodeobject,1018
CustomXMLPartobject,1021
CustomXMLSchemaobject,1024
CustomXMLValidationError,1025
deleting menus,334
deleting XML map,255
DocumentLibraryVersionobject,1027
DocumentPropertyobject,1030
FileDialogFilterscollection,1034
GradientStopscollection,1038
HPageBreakobject,759
Hyperlinkobject,760
PublishObjectobject,845
PublishObjectscollection,844
QueryTableobject,851
Rangeobject,861
RecentFileobject,868
Seriesobject,197,876
SeriesLinesobject,877
ServerViewableItemscollection,878
Shapeobject,884
ShapeNodesCollection,886
ShapeRangeobject,890
SharedWorkspaceobject,1055
SharedWorkspaceFileobject,1056
SharedWorkspaceFolder,1057
SharedWorkspaceLinkobject,1059
SharedWorkspaceMember,1060
SharedWorkspaceTaskobject,1061
Sheetscollection,892
Signatureobject,1063
SmartTagobject,894
SortFieldscollection,898
SoundNoteobject,898
TableStyleobject,905
TextRange2object,1071
TickLabelsobject,914
Top10object,916
Trendlineobject,918
UniqueValuesobject,920
UpBarsobject,921
UserAccessCollection,922
Validationobject,924
VPageBreakobject,925
Watchobject,927
1092
Date data type
WatchesCollection,927
Worksheetobject,959
Worksheetscollection,954
XmlMapobject,968
DELETEstatement,435,445,452,454
DeleteAllmethod
ServerViewableItemscollection,878
UserAccessListobject,922
DeleteCustomListmethod,Applicationobject,658
DeleteLinesmethod,CodeModuleobject,977
DeleteNumberFormatmethod,Workbookobject,944
DeleteReplacementmethod,AutoCorrectobject,666
DeleteTextmethod,ThreeDFormatobject,911
deleting
menus,334
records with plain text SQL in Access,452–454
rows,121–123
delimiters,230,233,483,849,850,867,937
Deliveryproperty,RoutingSlipobject,870
Dependentsproperty,Rangeobject,853
Depthproperty
ThreeDFormatobject,911
TickLabelsobject,914
DepthPerceptproperty,Chartobject,687
DESC specifier,434
descriptionattribute,302
Descriptionproperty
Add-inobject,973
COMAddinobject,998
Errobject,59
FileDialogFilter,1034
IDocumentInspectorobject,1026
PolicyItemobject,1051
Referenceobject,984
ServerPolicyobject,1050
SharedWorkspaceLinkobject,1058
SharedWorkspaceTaskobject,1061
VBprojectobject,990
WorkflowTaskobject,1077
WorkflowTemplateobject,1078
Description value,396
DescriptionTextproperty
CommandBarButtonobject,1003
CommandBarComboBoxobject,1006
CommandBarControlobject,1011
CommandBarPopupobject,1014
Deselectmethod,Chartobject,692
Design Mode button,13,14
Design tab,144,182,186,313
Designerclass,397,407
Designer Connectclass,402
Designerobject,574–575,596
Designerproperty,VBcomponent,987
DesignerIDproperty,VBcomponent,987
DesignerWindowproperty,VBcomponent,987
Destinationparameter,25
Destinationproperty,QueryTableobject,847
Detailsproperty,Signatureobject,1062
Developer tab,3,5–9,12,13,71,209,233,247,250,
251,305,495,496,596,653
Diagramproperty,Shapeobject,882
DiagramNodeproperty,Shapeobject,882
Dialogobject,223,233,235,737–738
dialog sheets,12,74,209,549,608,686
Dialog types,235
DialogBoxmethod,Rangeobject,861
<dialogBoxLauncher .../> control type,300
DialogFilterscollection,235
Dialogscollection,737–738
Dialogsproperty,Applicationobject,647
DialogSelecteditemscollection,235,237
DialogSelected itemsobject,235
DialogTypeproperty,FileDialogobject,1032
dictator applications,312,313
dictator applications,RibbonX in,312
DictLangproperty,SpellingOptionscollection,900
digital certificate,492,1062–1064
digital signatures,492,942,1061,1062
Dimstatement,38,39,42,43
Dim Zipfile,267
Dirfunction,58,81,82
direct reference to ranges,20–21
DirectDependentsproperty,Rangeobject,853
Directionparameter,759
Directionproperty,Speechobject,898
DirectPrecedentsproperty,Rangeobject,853
Dirtymethod,Rangeobject,861
DisableAskAQuestionDropdownproperty,
CommandBarscollection,999
DisableCustomizeproperty,CommandBars
collection,999
Disconnectmethod,SharedWorkspaceobject,1055
disconnected recordsets,461–463
display alerts,65
DisplayAlertsproperty,60,65,254,256,647
DisplayAutoCorrectOptionsproperty,AutoCorrect
object,666
DisplayBlanksAsproperty,Chartobject,688
DisplayClipboardWindowproperty,Application
object,647
DisplayCommentIndicatorDisplayModeproperty,
Applicationobject,647
DisplayDocumentActionTaskPaneproperty,
Applicationobject,647
1093
DisplayDocumentActionTaskPane property,Application object
I
n
d
e
x
DisplayDocumentInformationPanelproperty,
Applicationobject,647
DisplayDrawingObjectsproperty,Workbook
object,939
DisplayEquationproperty,Trendlineobject,918
DisplayExcel4Menusproperty,Application
object,647
DisplayFontsproperty,CommandBarscollection,999
DisplayFormulaAutoCompleteproperty,Application
object,647
DisplayFormulaBarproperty,Applicationobject,647
DisplayFormulasproperty
Windowobject,930
WorksheetViewobject,967
DisplayFullScreenproperty,Applicationobject,647
DisplayFunctionToolTipsproperty,Application
object,647
DisplayGridlinesproperty
Windowobject,930
WorksheetViewobject,967
DisplayHeadingsproperty
Windowobject,931
WorksheetViewobject,967
DisplayHorizontalScrollBarproperty,Windows
object,931
DisplayInkCommentsproperty,Workbookobject,939
DisplayInsertOptionsproperty,Application
object,648
DisplayKeysInTooltipsproperty,CommandBars
collection,999
DisplayNoteIndicatorproperty,Application
object,648
DisplayOutlineproperty,Worksheetobject View,967
DisplayPageBreaksproperty,Worksheetobject,956
DisplayPasteOptionsproperty,Application
object,648
DisplayRecentFilesproperty,Application
object,648
DisplayRightToLeftproperty
Windowobject,931
Worksheetobject,956
DisplayRSquaredproperty,Trendlineobject,918
DisplayRulerproperty,Windowsobject,931
DisplayScrollBarsproperty,Applicationobject,648
DisplaySmartTagsproperty,SmartTagOptions
collection,895
DisplayStatusBarproperty,Applicationobject,648
DisplayTooltipsproperty,CommandBars
collection,1000
DisplayUnitorDisplayUnitCustomproperty,672
DisplayUnitproperty,671
DisplayUnitCustomproperty,Axisobject,671
DisplayUnitLabelobject,738–739
DisplayUnitLabelproperty,Axisobject,671
DisplayVerticaScrollBarproperty,Windows
object,931
DisplayWhitespaceproperty,Windowsobject,931
DisplayWorkbookTabsproperty,Windowsobject,931
DisplayXMLSourcePanemethod,Application
object,658
DisplayZerosproperty
Windowobject,931
WorksheetViewobject,967
DISTINCT keyword,433
Distributemethod,ShapeRangeobject,890
DivIDproperty,PublishObjectobject,845
Doevents,289,531,536,593,619
Dostatement,51,52
Do...Loop,50,57
Docked Window,580
DockPositionproperty,CustomTaskPaneobject,1016
DockPositionRestrictproperty,CustomTaskPane
object,1016
DockPositionStateChangeevent,Custom
TaskPaneobject,1016
document inspection automation,503–506
DocumentInspectorscollection,505–506
RemoveDocumentInformationmethod,503–505
Document Inspector,501,503,505,939,1025,1042
Document LibraryNameproperty,Workflow
Templateobject,1078
DocumentLibraryURLproperty,WorkflowTemplate
object,1078
DocumentObject Model (DOM),258–262
loading XML into DOM document,259–260
traversing and modifying XML files with,262–265
using with ADO to convert Excel data to XML,260–262
document security,491
document variables,426–429
DocumentAuthorproperty,Permissionobject,1049
documentControls,307,313
DocumentElementproperty,CustomXMLPart
object,1021
DocumentInspectorobject,505,506,1025–1026
DocumentInspectorscollection,501,503,505–506,
1025–1026
DocumentInspectorsproperty,Workbookobject,939
DocumentLibraryVersionobject,1027
DocumentLibraryVersionscollection,1027
DocumentLibraryVersionsproperty,Workbook
object,939
DocumentPropertiescollection,1028–1030
DocumentPropertiesobject,485,724
DocumentPropertyobject,1028–1030
Documents.Openfilename,416,429
DoEventsstatement,289,593
1094
DisplayDocumentInformationPanel property,Application object
Do...loop,50–53
DOM(DocumentObject Model),258–262
loading XML into DOM document,259–260
traversing and modifying XML files with,262–265
using with ADO to convert Excel data to XML,260–262
DomainNameproperty,SharedWorkspaceMember
object,1060
DOMDocumentobject,259,260,262,269–271
DoNotPromptForConvertproperty,Workbook
object,939
DoubleClickmethod,Applicationobject,658
DoubleStrikeThroughproperty,Font2object,1035
Down menus,309
DownBarsobject,740
DownloadComponentsproperty,WebOptionsobject,928
DownloadURLproperty,SmartTagobject,894
DragOffmethod,VPageBreakobject,925
DragOverevent,Chartobject,695
DragPlotevent,Chartobject,695
Drawingobject,693,844
DrilldownLevelfunction,516
Drilledproperty,TreeviewControlobject,917
Dropparameter,681
Dropproperty,CalloutFormatobject,680
DropDowncontrol,215
DropDown menu buttons,146
DropDownobject,214,216
DropDownLinesproperty,CommandBarComboBox
object,1007
DropDownscollection,214,216
DropDownWidthproperty,CommandBarComboBox
object,1007
DropLinesmethods,741
DropLinesobject,740–741
DropTypeproperty,CalloutFormatobject,680
DueDateproperty
SharedWorkspaceTaskobject,1061
WorkflowTaskobject,1077
DupeUniqueproperty,UniqueValuesobject,919
Duplicatemethod
Shapeobject,884
ShapeRangeobject,890
TableStyleobject,905
Duration,964
DWORD Cdata type,604
dynamicActiveXcontrols,216–219
dynamic arrays,58,120,279
dynamiccontrols,RibbonX
comboBoxcontrol,315
gallery,315
dynamicMenu,300–302,304,315,316
<dynamicMenu .../>control type,300
E
early binding,411,412,414–420,430,598,984
edit box,209,1006–1009
Edit button,9
Edit menu,320,321
Edit Query button,486
editBox,300,302–304,316
<editBox .../>control type,300
EditDirectlyInCellproperty,Applicationobject,648
Editing options,552
EditingTypeproperty,ShapeNodeobject,886
EditionOptionsmethod,Rangeobject,861
EditNowproperty,760
Editor tab,40,64
EditWebPageproperty,QueryTableobject,847
ElementIDparameter,204,692
elements,XML,241–242
Elevationproperty,Chartobject,688
Elsestatement,20
Emailproperty,SharedWorkspaceMemberobject,1060
Embeddableproperty,Font2object,1035
embedded chart events,355,365
embedded charts,185–187
adding using VBA code,186–187
using macro recorder,186
EmbeddedOLEobject,792
Embeddedproperty,Font2object,1036
EmbedSmartTagsproperty,SmartTagOptions
collection,896
Employeeobject,355,356,357,359,360,371
Employeescollection,355,360,362
EmployeeSales.xmlfile,247,248,257,264
empty cells,110,115,324,743,866
Enable button,522
EnableAnimationsproperty,Applicationobject,648
EnableAutoCompleteproperty,Application
object,648
EnableAutoFilterproperty,Worksheetobject,956
EnableAutoRecoverproperty,Workbookobject,939
EnableCalculationproperty,Worksheetobject,956
EnableChangesparameter,687,693
EnableConnectionsmethod,Workbookobject,945
Enabledattribute,302
Enabledproperty
AutoRecoverobject,669
CommandBarobject,1001
CommandBarButtonobject,1003
CommandBarComboBoxobject,1007
CommandBarControlobject,1011
CommandBarPopupobject,1014
Permissionobject,1049
SmartTagRecognizerobject,896
1095
Enabled property
I
n
d
e
x
EnableEditingproperty,QueryTableobject,847
EnableEventsproperty,Applicationobject,648
EnableFormatConditionsCalculationproperty,
Worksheetobject,956
EnableKeyCancelKeyproperty,Application
object,648
EnableLargeOperationAlertsproperty,Application
object,648
EnableLivePreviewproperty,Applicationobject,648
EnableOutliningproperty,Worksheetobject,956
EnablePivotTableproperty,Worksheetobject,956
EnableRefreshproperty,QueryTableobject,847
EnableResizeproperty,Windowsobject,931
EnableSelectionproperty,Worksheetobject,956
EnableSoundproperty,Applicationobject,648
EnableTrustedBrowserproperty,Permission
object,1049
encapsulation,363,371
Encapsulationclass modules,363
Encodingproperty,WebOptionsobject,928
Encoding text files,265
EncryptionProviderobject,1030–1031
EncryptionProviderproperty,Workbookobject,939
EncryptStreammethod,EncryptionProvider
object,1031
Endfunction,79
End FunctionReferencesEventsobject,986
EndIfstatement,48
Endparameter,174
Endproperty,110–111,115,123,358,361,401,408,
613,614,617,620–622,629,630,853,974
Endstatement,365
EndSubstatement,14
EndWithstatement,281
EndReviewmethod,Workbookobject,945
EndSessionmethod,EncryptionProvider
object,1031
English language formulas,546
EntireColumnproperty,Rangeobject,853
EntireRowproperty,52,107,854
EnvelopeHideevent,MsoEnvelopeobject,1046
EnvelopeShowevent,MsoEnvelopeobject,1046
EnvelopeVisibleproperty,Workbookobject,939
EOFfunction,226
EOFproperty,Recordsetobject,442
Equalizeproperty,Font2object,1036
Errobject,59,60,62,134
Errorobject,441,741–742
Errorstringproperty,827
ErrorBarmethod,Seriesobject,876
ErrorBarsobject,742–743
ErrorBarsproperty,Seriesobject,874
ErrorCheckingOptionscollection,743–744
ErrorCheckingOptionsobject,743
ErrorCheckingOptionsproperty,Application
object,649
ErrorCodeproperty,CustomXMLValidationError
object,1024
error-handling,run-time,59–62
ErrorMessageproperty,Validationobject,923
Errorscollection,441,741–742
Errorsobject,741
Errorsproperty
CustomXMLPartobject,1021
Rangeobject,854
ErrorTitleproperty,Validationobject,923
ErrorTypeproperty,Syncobject,1068
Esc,5,201,281,646,692
Evaluatemethod
Applicationobject,96,544–545,560,658
Chartobject,692
overview,66–68
Worksheetobject,959
event list,363
event procedures,199–208
chartevents,202–204
headers and footers,207–208
and running macros,16–17
Workbookobject events,205–207
worksheetevents,199–202
enableevents,200–201
Worksheet_Calculateevent,201–202
events,26–27
Eventsobject,981–982
Eventsproperty,VBE,989
Excel 2007 object model
AboveAverageobject,636–638
Actionobject,638–639
Actionscollection,638–639
Add-Inobject,639
Addinscollection,639
Adjustmentsobject,640–641
AllowEditRangeobject,642
AllowEditRangescollection,641
Applicationobject,642–664
events,661–663
example,664
methods,656–661
properties,643–656
Areascollection,664–665
AutoCorrectobject,665–667
AutoFilterobject,667–669
AutoRecoverobject,669–670
Axisobject and Axescollection,670–674
AxisTitleobject,674–675
Borderobject and Borderscollection,676–677
1096
EnableEditing property,QueryTable object
CalculatedFieldscollection,677
CalculatedItemscollection,678
CalculatedMemberobject,678–679
CalculatedMemberscollection,679–680
CalloutFormatobject,680–682
CellFormatobject,682–684
Charactersobject,684–685
Chartobject
events,694–695
example,696
methods,690–694
properties,687–690
ChartAreaobject,696–697
ChartColorFormatobject,698
ChartFillFormatobject,698–700
ChartFormatobject,700–701
ChartGroupobject,701–704
ChartObjectobject,706–708
ChartObjectscollection,704–706
Chartscollection,686–687
ChartTitleobject,708–710
ChartViewobject,710
collectionmethods,636
collectionproperties,635
ColorFormatobject,710–711
ColorScaleobject,711–713
ColorScaleCriteriacollection,713
Commentobject and Commentscollection,714–716
ConditionValueobject,716
Connectionsobject,716–717
ConnectorFormatobject,717–719
ControlFormatobject,719–721
CubeFieldobject and CubeFieldscollection,721–724
CustomPropertyobject and CustomProperties
collection,724–726
CustomViewobject and CustomViewscollection,
726–727
Databarobject,727–729
DataLabelobject and DataLabelscollection,729–734
DataTableobject,734–735
DefaultWebOptionsobject,735–737
Dialogobject and Dialogscollection,737–738
DisplayUnitLabelobject,738–739
DownBarsobject,740
DropLinesobject,740–741
Errorobject and Errorscollection,741–742
ErrorBarsobject,742–743
ErrorCheckingOptionscollection object,743–744
FillFormatobject,744–746
Filterobject and Filterscollection,746–747
Floorobject,747–748
Fontobject,748–749
FormatColorobject,749–750
FormatConditionobject and FormatConditions
collection,750–753
FreeformBuilderobject,753–754
Graphicobject,754–756
Gridlinesobject,756–757
GroupShapescollection,757
HeaderFooterobject,757–758
HiLoLinesobject,758
HPageBreakobject and HPageBreakscollection,
758–759
Hyperlinkobject and Hyperlinkscollection,759–761
Iconobject,761–762
IconCriterionand IconCriteriacollection,762
IconSetand IconSetscollection,762–763
IconSetConditionobject,763–765
Interiorobject,765–767
IRtdServerobject,767–768
IRTDUpdateEventobject,768
LeaderLinesobject,769
Legendobject,770–771
LegendEntryobject and LegendEntriescollection,
771–773
LegendKeyobject,773–774
LinearGradientobject,774
LineFormatobject,775–776
LinkFormatobject,776–777
ListColumnand ListColumnscollection,777
ListColumnsCommon Properties,777–778
ListDataFormatobject,778–779
ListObjectobject and ListObjectscollection,
779–781
Mailerobject,782
MultiThreadedCalculationobject,783
Nameobject and Namescollection,783–785
object properties,636
ODBCConnectionobject,785–787
ODBCErrorobject and ODBCErrorscollection,787–788
OLEDBConnectionobject,788–790
OLEDBErrorobject and OLEDBErrorscollection,
790–791
OLEFormatobject,791–792
OLEObjectobject and OLEObjectscollection,792–796
Outlineobject,796–797
Pageobject and Pagescollection,797–798
PageSetupobject,798–801
Paneobject and Panescollection,802–803
Parameterobject and Parameterscollection,803–804
Phoneticobject and Phoneticscollection,804–805
PictureFormatobject,806–807
PivotAxisobject,807
PivotCacheobject and PivotCachescollection,
807–811
1097
Excel 2007 object model
I
n
d
e
x
Documents you may be interested
Documents you may be interested