display pdf winform c# : How to rotate just one page in pdf SDK Library service wpf asp.net .net dnn 7053154973-Excel%202007%20VBA%20Programmers%20Reference%20-%20Wrox%202007113-part632

Excel 2007 object model (continued)
PivotCell object, 811–812
PivotField object, PivotFields collection, and
CalculatedFields collection,812–819
PivotFilter object and PivotFilters collection,
819–821
PivotFormula object and PivotFormulas collection,
821–822
PivotItem object, PivotItems collection, and
CalculatedItems collection,822–823
PivotItemList object, 824
PivotLayout object, 824–825
PivotLine object, PivotLines collection, and Pivot
LinesCells collection,825
PivotTable object and PivotTables collection,
825–837
PlotArea object, 838–839
Point object and Points collection, 839–842
Protection object, 842–844
PublishObject object and PublishObjects collection,
844–846
QueryTable object and QueryTables collection,
846–852
Range object and Ranges collection object,852–868
methods, 858–868
overview,852
properties,852–857
Real-Time Data (RTD) object, 870
RecentFile object and RecentFiles collection,
868–869
RectangularGradient object, 869
RoutingSlip object, 869–870
Scenario object and Scenarios collection, 871–872
Series object and SeriesCollection collection,
872–877
SeriesLines object, 877
ServerViewableItems collection,878
ShadowFormat object, 878–879
Shape object and Shapes collection, 880–885
ShapeNode object and ShapeNodes collection, 886–887
ShapeRange object collection,887–891
Sheets collection,891–893
overview,891
Sheets common properties,891
Sheets methods, 892–893
Sheets properties, 892
SheetViews object, 893
SmartTag object and SmartTags collection object,
893–894
SmartTagAction object and SmartTagActions
collection object,894–895
SmartTagOptions collection object,895
SmartTagReconizer object and SmartTag
Recognizers collection object,895–896
Sort object, 896–897
SortField object and SortFields collection, 897–898
SoundNote object, 898
Speech object, 898–899
SpellingOptions collection object,899–901
Style object and Styles collection, 901–903
Tab object, 903–904
TableStyle object and TableStyles collection object,
904–906
TableStyleElement object and TableStyleElements
collection object, 906
TextEffectFormat object, 907–908
TextFrame object, 908–909
TextFrame2 object, 909–911
ThreeDFormat object, 911–913
TickLabels object, 913–915
Top10 object, 915–917
TreeviewControl object, 917
Trendline object and Trendlines collection, 917–919
UniqueValues object, 919–920
UpBars object, 920–921
UsedObjects collection object,921–922
UserAccessList collection object,922
Validation object, 923–924
VPageBreak object and VPageBreaks collection,
924–925
Walls object, 925–926
Watch object and Watches collection object,926–928
WebOptions object, 928–929
Window object and Windows collection, 929–935
Workbook object and Workbooks collection, 935–953
events,951–953
methods, 935–937,944–951
overview,935
properties,935–943
WorkbookConnection object, 953
Worksheet object, 953–963
events,962–963
methods, 958–962
properties,955–958
WorksheetFunction object, 963–966
Worksheets collection,954–955
WorksheetView object, 966–967
XmlDataBinding object, 967
XmlMap object and XMLMaps collection, 967–969
XmlNameSpace object and XMLNameSpaces
collection,969
XmlSchema object and XmlSchemas collection, 969–970
XPath object, 970
Excel chart window (prior to Excel 2007) window,608
1098
Excel 2007 object model (continued)
How to rotate just one page in pdf - 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#
rotate all pages in pdf and save; pdf reverse page order preview
How to rotate just one page in pdf - 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 save a pdf after rotating pages; how to rotate just one page in pdf
Excel Object model,21–30
getting help, 27–29
Immediate window, 29–30
objects,22–27
collections,22–23
events,26–27
methods, 25
properties,23–25
EXCEL4 class, 608
Excel4IntlMacroSheets property
Application object, 649
Workbook object, 939
Excel4MacroSheets property
Application object, 649
Workbook object, 939
EXCEL7 class, 608
Excel8CompatiblityMode property,Workbookobject, 939
EXCELE class, 608
ExclusiveAccess method,Workbook object, 945
Execute method
Command object, 447
CommandBarButton object, 1005
CommandBarComboBox object, 1009
CommandBarControl object, 1012
CommandBarPopup object, 1015
Connection object, 439,439–440, 446
FileDialog object, 235,1033
Recordset object, 447
SmartTagAction object, 895
ExecuteExcel4Macro function, 546,555, 560,569, 658
ExecuteMso method,316, 317,1000
ExecuteOptionEnum value,440
Exit Do statement, 52
Exit statement, 59
Exit Sub statement, 35,91
ExpandHelp property,SmartTagAction object, 895
Expiration Date property,UserPermission
object,1075
Explosion property,Series object, 874
Export file,363
Export method
exporting to XML file,258
VBcomponent object, 987
XmlMap object, 968
ExportAsFixedFormat method
Chart object, 692
Range object, 861
Workbook object, 945
Worksheet object, 959
ExportString method,Chart object, 692
ExportXml method,XmlMap object, 969
Extend method,Series object Collection, 873
ExtendList property,Application object, 649
extensibility,295, 402,403, 409,571, 572,598, 600,
971,981, 990
eXtensible Markup Language (XML),239–272
attributes,242–243
comments,241
consuming XML data directly, 246–249
elements and root element, 241–242
namespaces,243–245
processing instructions,241
using VBA to program Open XML files,265–272
programmatically unzipping Excel containers,266–267
programmatically zipping Excel containers,267–272
using VBA to program XML processes,253–265
Document Object Model (DOM),258–265
programming XML maps,253–258
XPath,262–264
viewing and editing XML documents,245
XML Declaration, 240–241
XML maps,249–253
creating, 251–253
creating XML schema description,249–251
Extensions property,FileDialogFilter, 1034
Extent property,VPageBreak object, 925
External Content category,499–500
External Content section, 489
external data,managing, 469–490
External Data user interface, 469–472
Get External Data group, 470–471
Manage Connections group, 471–472
QueryTables, 472–487
associated with ListObject, 475–476
creating and using connection files, 484–489
and parameter queries, 476–479
from relational database, 472–475
from text file, 482–483
from web queries, 479–482
security settings,489–490
WorkbookConnection object and Connections
collection,487–489
external data sources,142, 165,178, 180,241, 270,
470,716
External Excel workbooks,499, 500
Extra Auditing tab,296
ExtraInfo property,761
ExtrusionColor property,ThreeDFormat object, 911
ExtrusionColor Type property,ThreeDFormat
object,911
F
FaceId property,322–324, 330,341, 1003
FarEastLineBreakLevel property,ParagraphFormat2
object,1048
1099
FarEastLineBreakLevel property, ParagraphFormat2 object
I
n
d
e
x
C# PDF: C# Code to Process PDF Document Page Using C#.NET PDF
PDF page processing functions by just following attached for developers on how to rotate PDF page in different two different PDF documents into one large PDF
how to rotate one page in pdf document; rotate pdf page few degrees
C# PDF Page Move Library: re-order PDF pages in C#.net, ASP.NET
library control, developers can swap or adjust the order of all or several PDF document pages, or just change the position of certain one PDF page in an
rotate individual pages in pdf; reverse pdf page order online
FeatureInstallInstall property,Application
object,649
FetchComplete event,445
FetchedRowOverflow property,QueryTable object, 847
field codes,426, 428
field names, 123,141, 145,157, 261,285, 420,422, 429,
432,433, 445,450, 466,467, 512,832, 847
field properties,816
FieldNames property,QueryTable object, 847
FieldOfView property,ThreeDFormat object, 912
Fields collection,Recordset object, 445
FileConverters property,Application object, 649
FileDialog object
dialog types, 235
Execute method,235
FileDialogFilters property, 235
FileDialogSelectedItems collection,235
MultiSelect property, 236–237
overview,233–237, 1031–1033
FileDialog property,Application object, 649
FileDialogFilter object,1033–1034
FileDialogFilters collection,234–236, 235,
1033–1034
FileDialogFilters property,235
FileDialogSelectedItems collection,235, 1034
FileFind property,Application object, 649
FileFormat property,Workbook object, 939,940
filename,getting from a path, 78–80
FileName property
PublishObject object, 845
VBproject object, 990
filenumber, 223
files,405, 406,648
files folder,504, 505
Files property,SharedWorkspace object, 1055
FileTypes object,1034–1035
Fill property
ChartFormat object, 700
Font2 object, 1036
Shape object, 882
ShapeRange object, 888
FillAcrossSheets method
Sheets collection,892
Worksheets collection,954
FillAdjacent Formulas property,QueryTable
object,847
FillDown method,Range object, 861
FillFormat object,700, 710,744–746
FillFormat property,Axis object Title, 674
FillLeft method,Range object, 861
FillRight method,Range object, 861
FillUp method,Range object, 861
Filter button,146, 827
Filter menu,347
Filter object,148, 668,746–747, 1034
Filter property,442–443
FilterDates procedure, 151
FilterGroupEnum constants,442
FilterIndex property,FileDialog object, 1032
FilterMode property
AutoFilter object, 668
Worksheet object, 956
Filters collection,746–747
Filters property
AutoFilter object, 668
FileDialog object, 1032
Final property,Workbook object, 939
Find Control method,CommandBar object, 1002
Find method
CellFormat object, 682
CodeModule object, 977
Range object, 862
TextRange2 object, 1071
FindControl method,CommandBars collection, 1000
FindControls method,CommandBars collection, 1000
FindFile method,Application object, 658
FindFormat property
Application object, 649
CellFormat object, 682
settings,682
FindNext method,Range object, 862
FindPrevious method,Range object, 862
FindWindow function, 608,611
FirstChild property,CustomXMLNode object, 1017
FirstLineIndent property,ParagraphFormat2
object,1048
FitToPages variant,799
FitToPagesTall property,799
FitToPagesWide property,799
FitToPagesWide variant,799
Fix method,DocumentInspector object, 506,1026
Fix method,IDocumentInspector object, 1042
Fixed method,964
FixedDecimal property,Application object, 649
FixedDecimalPlaces property,Application
object,649
FixedWidthFont property,WebPageFont object, 1076
FixedWidthFontSize property,WebPageFont
object,1076
Flip method
Shape object, 884
ShapeRange object, 890
Floor object,747–748, 964
Floor property,Chart object, 688
Folder options, 5
1100
FeatureInstallInstall property, Application object
Process Images in Web Image Viewer | Online Tutorials
Easy to rotate the current picture or file page through just a button You can also process a multi-page document by deleting one or more page(s) from it
pdf page order reverse; pdf rotate single page and save
VB.NET Create PDF Library SDK to convert PDF from other file
can be easily integrated into many MS Visual Studio .NET applications to create PDF with just a few VB.NET: Create a New PDF Document with One Blank Page.
how to rotate page in pdf and save; rotate pdf pages on ipad
FolderName property,SharedWorkspaceFolder
object,1057
Folders property,SharedWorkspace object, 1055
FolderSuffix property,WebOptions object, 928
FollowHyperlink event,Worksheet object, 963
FollowHyperlink method,Workbook object, 534,945
Font group,295
Font object,748–749
Font options,674, 734,751, 772,805
Font property
AboveAverage object, 637
AxisTitle object, 674
BulletFormat2 object, 996
CellFormat object, 683
Characters object, 685
Range object, 854
Style object, 901
TableStyleElement object, 906
TextRange2 object, 1070
TickLabels object, 914
Top10 object, 915
UniqueValues object, 919
Font2 object,1035–1037
FontBold property,TextEffectFormat object, 907
FontItalic property,TextEffectFormat object, 907
FontName property,TextEffectFormat object, 907
FontSize property,TextEffectFormat object, 907
Footer dialog box,754
footers,201–202, 207,505, 757,799,1025
For Each...Next loop,54–55
For statement, 53
For...Next loop, 53,79
Forecast method,964
ForeColor property
ChartFillFormat object, 698
ShadowFormat object, 879
Form button,158, 214
Form command,158, 556
Form controls, 209–210,214, 216,221, 535
Format function, 87,152, 228,542, 546–549,552, 560
Format parameter, 691,706, 708,794, 796
Format property
Axis object, 671
AxisTitle object, 674
ChartArea object, 697
Series object, 874
SeriesLines object, 877
TickLabels object, 914
Trendline object, 918
UpBars object, 921
Walls object, 926
FormatColor object,749–750
FormatCondition object,750–753
FormatConditions collection,750–753
FormatConditions property,Range object, 854
FormatCurrency function, 542
FormatDateTime function, 542
FormatNumber function, 542
FormatPercent function, 542
FormatRow property
AboveAverage object, 637
Top10 object, 915
UniqueValues object, 919
FormFun.xlsm file,624
FormResizer.xlsm workbook,628
Forms button,12
Forms controls, 12–13,214–216, 950
Forms toolbar, 12,75, 214,219, 220
Formula Hidden property,Range object, 854
Formula parameter, 657,821
Formula property,194, 197,548, 557,559, 568,678,
854,874
Formula strings,548
Formula1 property,Validation object, 923
Formula2 property,Validation object, 923
FormulaArray property,Range object, 559,854
FormulaBarHeight property,Application object, 649
FormulaHidden property
CellFormat object, 683
Style object, 901
FormulaLocal property
Range object, 854
Series object, 874
FormulaR1C1 property
Range object, 854
Series object, 874
FormulaR1C1Local property
Range object, 854
Series object, 874
Formulas tab, 17,125, 295
Formulas table, 649
For...Next loop, 53–54
Forward parameter, 917
Forward2 property,Trendline object, 918
ForwardMailer method,Workbook object, 945
Frame control, 275,496
FreeformBuilder object,753–754
FreezePanes property,Windows object, 931
Frequency method,964
FriendlyName,396, 1039,1041
From parameters,686
Front collection,705
FrontPage Server Extensions, 526,536
FTest method,964
1101
FTest method
I
n
d
e
x
VB.NET PDF Page Extract Library: copy, paste, cut PDF pages in vb.
functions, including extracting one or more page(s) from PDF document. To utilize the PDF page(s) extraction function in VB.NET application, you just need to
rotate one page in pdf; pdf rotate one page
VB Imaging - VB MSI Plessey Barcode Tutorial
barcode.Resolution = 96 'set rotation barcode.Rotate = Rotate.Rotate0 barcode It allows you to select one page from a Below is just an example of generating an
rotate single page in pdf; rotate all pages in pdf file
FullName property
Add-In, 639
SmartTagRecognizer object, 896
Workbook object, 940
FullNameURLEncoded property,Workbook object, 940
FullPath property,Reference object, 984
Function property,593, 976
function types,declaring,44
functions, calling,35–36
FunctionWizard method,Range object, 862
Fv method,964
FVSchedule method,964
G
<gallery .../> control type,300
GammaDist method,964
GammaInv method,964
GammaLn method,964
Gap property,CalloutFormat object, 680
GapDepth property,Chart object, 688
Gcd method,964
GDI32.DLL file,602
GenerateGetPivotData property,Application
object,649
GenerateSignatureLineImage method,
SignatureProvider object,1065
GenerateTableRefs property,Application object, 649
GeoMean method,964
GermanPostReform property,SpellingOptions
collection,900
GeStep method,964
Get External Data group,470–471
GetCategories method,IBlogExtensibility
object,1039
GetCertificateDetail method,SignatureInfo
object,1064
GetChartElemerLong method,Chart object, 692
getContent,304, 305,316
GetCustom Color method,ThemeColorsScheme, 1073
GetCustomListContents method,Application
object,658
GetCustomListNum method,Application object, 658
GetCustomUI function, 402,403
GetCustomUI method,IRibbonExtensibility
object,1043
GetEnabledMso method,316, 1000
GetFileName function, 79
GetImagedMso method,CommandBars collection, 1000
GetImageMso,316
GetInfo method,IDocumentInspector object, 1042
GetInput function, 36
GetItemByInternalName property,MetaProperties
collection,1044
getItemCount,304, 305,315
getItemID,304, 305,315
getItemImage,304, 305,315
getItemLabel,304, 305,315
getItemScreentip,304, 305,315
getItemSupertip,304, 305,315
getLabel callback, 298
GetLabelMso method,CommandBars collection, 1000
GetObject function, 416,417, 430,643, 656
GetOpen filename,539, 540,584, 664
GetOpenFileName function, 540,584, 658
GetPhonetic method,Application object, 658
GetPhonetic string, 658
GetPivotData method,811, 824
GETPIVOTDATA worksheet function, 824
GetPressedMso method,316, 1000
GetProviderDetail method
EncryptionProvider object, 1031
SignatureProvider object, 1065
GetRecentPosts method,IBlogExtensibility
object,1039
GetSaveAsFilename method,Application object, 658
GetScreenTipMso method,316, 1000
getSelectedItemID callback,304
getSelectedItemIndex callback,304
GetSelection method,591, 979
GetSignatureDetail method,SignatureInfo
object,1064
GetSupertipMso method,316, 1001
GetTempPath function, 603
getText,304
GetUpdate method,Sync object, 1068
GetUserBlogs method,IBlogExtensibility
object,1040
GetVisibleMso method,CommandBars collection, 1001
GetWindowLong function, 623
GetWindowRect function, 607,609
GetWorkflowTasks method,Workbook object, 945
GetWorkflowTemplates method,Workbook object, 945
Given Action object,638, 639
globals,63–64
<globals>,63, 74,95, 97,115, 376
Glow property
ChartFormat object, 700
Font2 object, 1036
Shape object, 882
ShapeRange object, 888
GlowFormat object,1037
Go button, 385
GoalSeek method,Range object, 862
1102
FullName property
VB.NET TIFF: Rotate TIFF Page by Using RaterEdge .NET TIFF
VB.NET methods for you to locate the target TIFF page(s) accurately and quickly; Rotate single or multiple TIFF page(s) at one time just as you wish;
rotate all pages in pdf; pdf rotate all pages
C# Imaging - C# MSI Plessey Barcode Tutorial
Resolution = 96;// set resolution barcode.Rotate = Rotate.Rotate0;// set It allows you to select one page from a PDF Below is just an example of generating an
pdf save rotated pages; rotate individual pdf pages reader
Goto method,Application object, 659
Gradient property,774, 869
GradientColorType property,ChartFillFormat
object,698
GradientDegree property,ChartFillFormat object,698
GradientStop object,1037–1038
GradientStops collection,1037–1038
GradientStyle property,ChartFillFormat object, 698
GradientVariant property,ChartFillFormat
object,699
Graphic object,754–756
GridlineColor property,Windows object, 931
GridlineColorIndex property,Windows object, 931
Gridlines methods,757
Gridlines object,756–757
Group method
Range object, 862
ShapeRange object, 890
Group mode,90, 91
grouping, Worksheet objects,87–88
Grouping dialog box,174
GroupItems property
Shape object, 882
ShapeRange object, 888
GroupName property,213, 281
groups, controlling using RibbonX, 313–314
GroupShapes collection,757
Guid property
Add-in object,973
COMAddin object, 998
Reference object, 984
H
HANDLE C data type, 604
handles,306, 406,407, 606–609,640, 986
HangingPunctuation property,ParagraphFormat2
object,1048
HarMean method,964
Has3DEffect property,Series object, 874
HasArray property,Range object, 854
HasAuto format, 836
HasAxis property,Chart object, 688
HasChart property
Shape object, 882
ShapeRange object, 888
HasChildNodes method,CustomXMLNode object, 1018
HasDataLabel property,204
HasDataLabels property,Series object, 874
HasDataTable property,Chart object, 688
HasDisplayUnitLabel property,Axis object, 672
HasErrorBars property,Series object, 874
HasFormat property,TableStyleElement, 906
HasFormula property,Range object, 854
HashStream method,SignatureProvider object, 1065
HasLeaderLines property,Series object, 874
HasLegend property,Chart object, 688
HasMajorGridlines property,Axis object, 672
HasMinorGridlines property,Axis object, 672
HasOpenDesigner property,VBcomponent, 987
HasPassword property,Workbook object, 940
HasRoutingSlip property,869, 940
HasShortcut key,659
HasText property,TextFrame object2, 910
HasTitle property
Axis object, 672,674
Chart object, 688
ChartTitle object, 708
HasUpDownBars property,701, 920
HasVBProject property,Workbook object, 940
HBITMAP C data type, 604
HBRUSH C data type, 604
HCURSOR C data type,604
HDC C data type, 604
Header property,Sort object, 896
Header Row, 155,347, 350,378, 777,779, 780
HeaderFooter object,757–758
headers,207–208, 505,757, 799,1025
HeadersFooters collection,757
HeartbeatInterval property,768
HebrewModes property,SpellingOptions
collection,900
Height parameters,705, 793,802
Height property
Application object, 650
Axis object, 672
ChartArea object, 697
CommandBar object, 1001
CommandBarButton object, 1003
CommandBarComboBox object, 1007
CommandBarControl object, 1011
CommandBarPopup object, 1014
CustomTaskPane object, 1016
Range object, 854
Shape object, 882
ShapeRange object, 888
values, 187
Window object, 931,993
HeightPercent property,Chart object, 688
help,27–29
Help button, 32,34
Help file,659
Help method,Application object, 659
HelpContextID parameter, 659
1103
HelpContextID parameter
I
n
d
e
x
VB.NET Word: How to Process MS Word in VB.NET Library in .NET
How to Rotate, Merge Word Documents Within VB.NET Imaging the length of the web page, here we just describe each single or multiple Word pages at one time with
rotate pages in pdf permanently; how to rotate a page in pdf and save it
C# Image Convert: How to Convert MS PowerPoint to Jpeg, Png, Bmp
The last one is for rendering PowerPoint file to raster image Gif. This demo code just converts PowerPoint first page to Gif image.
rotate one page in pdf reader; how to rotate a pdf page in reader
HelpContextId property
CommandBarButton object, 1003
CommandBarComboBox object, 1007
CommandBarControl object, 1011
CommandBarPopup object, 1014
HelpContextID property,VBproject object, 991
HelpFile property
CommandBarButton object, 1004
CommandBarComboBox object, 1007
CommandBarControl object, 1011
CommandBarPopup object, 1014
VBproject object, 991
Hex2Bin method,964
Hex2Dec method,964
Hex2Oct method,964
HFONT C data type, 604
HICON C data type, 604
Hidden fields object,828
Hidden items property,171
hidden member,214
Hidden property
Range object, 154,160, 854
Scenario object, 871
TreeviewControl object, 917
Hide button, 6
Hide method,274, 277
hiding names, 131–132
Hierarchize function, 516
Highlight property,Font2 object, 1036
HighlightChangesOnScreen property,Workbook
object,940
HighlightChangesOptions method,Workbook
object,945
high-resolution timer,616, 618,634
HiLoLines object,758
HINSTANCE C data type,604
Hinstance property,Application object, 650
HLOCAL C data type,604
HLookup method,964
HMENU C data type,604
HMETAFILE C data type,604
HMODULE C data type, 604
Home Directory tab, 532
Home tab, 4,8, 295
HorizontalAlignment property
AxisTitle object, 674
CellFormat object, 683
Range object, 854
Style object, 901
TextFrame object, 908
HorizontalAnchor property,TextFrame object2, 910
HorizontalFlip property
Shape object, 882
ShapeRange object, 888
HoursPerWeek property,357, 358
HPageBreak object,758–759
HPageBreaks collection,758–759
HPageBreaks property
Charts collection,686
Sheets collection,892
Worksheets collection,954, 956
HPALETTE C data type, 604
HPEN C data type, 604
HRGN C data type,604
HTASK C data type,604
HTML feature,533
HTML file,532
HTML format, 480,533
HTML page,404, 735
HtmlType property,PublishObject object, 845
HWND C data type, 605
Hwnd property
Application object, 650
GetWindowRect function,607
HWnd property,Window object, 993
Hyperlink object,759, 760,761
Hyperlink property,Shape object, 882
Hyperlinks collection,759–761
Hyperlinks property
Range object, 854
Worksheet object, 956
HyperlinkType property,CommandBarButton
object,1004
HypGeomDist,964
I
IAssistance object,1038–1039
IBlogExtensibility object,1039–1041
IBlogPictureExtensibility object,1039–1041
Icon object,761–762
IconCriteria collection,762, 763
IconCriterion collection,762
Icons button, 306
IconSet collection,762–763
IconSet object,762
IconSetCondition object,763–765
IconSets property,Workbook object, 940
ICTPFactory object,1041
ICustomTaskPaneConsumer interface,404
ICustomTaskPaneConsumer object,1041–1042
Id attribute, 302
1104
HelpContextId property
Id property
CommandBarButton object, 1004
CommandBarComboBox object, 1007
CommandBarControl object, 1011
CommandBarPopup object, 1014
CustomXMLPart object, 1021
IRibbonControl object, 1042
MetaProperty object, 1045
overview,322–324
PolicyItem object, 1051
Range object, 854
ServerPolicy object, 1050
Shape object, 882
ShapeRange object, 888
SignatureSetup object, 1066
WorkflowTask object, 1077
WorkflowTemplate object, 1078
idMso attribute,302
IDocumentInspector object,1042
idQ attribute,302
IDTExtensibility2 interface,388–394
IF function, 47,276, 546
If statements, 47–48
IfError method,964
IgnoreBlank property,Validation object, 923
IgnoreCaps property,SpellingOptions collection, 900
IgnoreFile Names property,SpellingOptions
collection,900
IgnoreMixedDigits property,SpellingOptions
collection,900
IgnoreRemoteRequests property,Application
object,650
IIf function, 47,48
ImAbs method,964
Image attribute,302
Image control, 233,235, 237
imageMso attribute,302
Imaginary method,964
ImArgument method,964
ImConjugate method,964
ImCos method,964
ImDiv method,964
IMEMode property,Validation object, 923
ImExp method,964
ImLn method,964
ImLog10 method,964
ImLog2 method,964
Immediate window, 29–30,71, 95,260, 375,441, 580,
981,989, 993
Immediate Window button,29
Implements keyword, 767
implicit conversion, 539,541, 561
Import file, 363
Import method
importing data into XML map, 257
SoundNote object, 898
VBcomponents collection,988
XmlMap object, 969
ImportXml method,XmlMap object, 969
ImPower method,964
ImProduct method,964
ImReal method,964
ImSin method,964
ImSqrt method,964
ImSub method,965
ImSum method,965
inactive worksheets, 96,99
InactiveListBorder property,Workbook object, 940
Inbox folder, 413
InCell Dropdown property,Validation object, 923
Inches parameter, 659
InchesToPoints method,Application object, 659
Include Protection property,Style object, 902
IncludeAlignment property,Style object, 901
IncludeBorder property,Style object, 902
IncludeFont property,Style object, 902
IncludeLayout property,Axis object Title, 674
IncludeNumber property,Style object, 902
IncludePatterns property,Style object, 902
IncrementLeft method
Shape object, 885
ShapeRange object, 890
IncrementOffsetX method,ShadowFormat object, 879
IncrementOffsetY method,ShadowFormat object, 879
IncrementRotation method
Shape object, 885
ShapeRange object, 890
IncrementRotationHorizontal method,
ThreeDFormat object,912
IncrementRotationVertical method,ThreeDFormat
object,912
IncrementRotationX method,ThreeDFormat
object,913
IncrementRotationY method,ThreeDFormat
object,913
IncrementRotationZ method,ThreeDFormat
object,913
IncrementTop method
Shape object, 885
ShapeRange object, 890
IndentLevel property
CellFormat object, 683
ParagraphFormat2 object, 1048
Range object, 854
Style object, 902
Index method,965
1105
Index method
I
n
d
e
x
Index parameter, 636,640, 664,666, 721,771, 801
Index property
Chart object, 688
Clear Contents control,341
CommandBar object, 1001
CommandBarButton object, 1004
CommandBarComboBox object, 1007
CommandBarControl object, 1011
CommandBarPopup object, 1014
DocumentLibraryVersion object, 1027
RecentFile object, 868
Scenario object, 871
Trendline object, 918
Window object, 931
Worksheet object, 84,85, 956
IndexedValue property,Property object, 982
InitialFileName property,FileDialog object, 1032
Initialization controls, 496
Initialize event,279, 284,369, 461,575, 576,577,
629,633
Initialize routine,617
InitializeChart events,367
InitialView property,FileDialog object, 1032
input and output,30–35
constants, 33
InputBox,34–35
parameters specified by name, 31–33
parameters specified by position,31
return values, 33–34
Input statement, 226,227
InputBox function, 36,62, 68–69,273
InputBox method,68, 69,659
InputMessage property,Validation object, 923
InputTitle property,Validation object, 923
Insert button,12, 13,209
Insert dialog box,182
Insert method
Characters object, 685
GradientStops collection,1038
Range object, 862
ShapeNodes Collection,886
INSERT statement, 434,453, 467
InsertAfter method,TextRange2 object, 1071
InsertBefore method,TextRange2 object, 1071
InsertIndent method,Range object, 862
InsertLines method,CodeModule object, 977
InsertNodesBefore method,CustomXMLNode
object,1018
InsertSubtreeBefore method,CustomXMLNode
object,1018
InsertSymbol method,TextRange2 object, 1071
Inspect button,501
Inspect method
IDocumentInspector object, 505,1026, 1042
Installed property,Add-In,639
installing Add-ins,379–381
InstallManifest,969
Instancing property,383, 384,389
InStr function, 195
Int C data type,605
int FAR * C data type, 605
IntegralHeight property,634
Interactive property,Application object, 650
Intercept method,965
Intercept parameter, 917
Intercept property,Trendline object, 918
InterceptIsAuto property,Trendline object, 918
Interior object,26, 765–767,774, 869
Interior property
AboveAverage object, 637
AxisTitle object, 674
CellFormat object, 683
Range object, 854
Style object, 902
TableStyleElement object, 906
Top10 object, 915
UniqueValues object, 919
InteriorPattern property,869
international issues, 537–569
exceptions to rules, 554–560
= TEXT( ) worksheet function,558–560
OpenText function,555–556
pasting text, 557
PivotTable calculated fields and items,557–558
SaveAs function,556
ShowDataForm sub procedure, 556
web queries,558
helpful functions, 565–568
bWinToDate function,566–567
bWinToNum function,565–566
ReplaceHolders function,568
sFormatDate function,567
interacting with Excel,545–548
reading data from Excel,548
rules for working with Excel,548
sending data to Excel,545–547
interacting with users,549–551
displaying data, 549
interpreting data, 550
paper sizes, 549
rules for working with users,551
xxxLocal properties,550–551
1106
Index parameter
international options, 552–554
Office 2007 language settings,560–565
creating multilingual application, 562–564
identifying Office UI language settings,561–562
rules for developing multilingual application, 565
where text comes from,560–561
working in multilingual environment,564–565
regional settings and Office 2007 UI language, 537–538
regional settings and Windows language,538–545
identifying user’s regional settings and Windows
language, 538–539
VBA conversion functions,539–545
International options, 558,566
International property,Application object, 650
Internet,525–536
overview,526
using as communication channel,533–536
using as data source,527–531
opening web pages as workbooks, 528
parsing web pages for specific information, 530–531
using web queries,528–530
using for storing workbooks,526–527
using to publish results,531–533
creating interactive web pages,533
saving worksheets as web pages,532–533
setting up web server, 532
Internet Transfer control, 525,534–536, 601
Intersect method,Application object, 115,659
IntRate method,965
Introduction property,MsoEnvelope object, 1046
invalidate ContentOnDrop attribute,302
Invalidate method,309, 1043
InvalidateControl method,309, 310,1043
InvertIfNegative property,Series object, 874
IPicture object,306, 317
Ipmt method,965
IQY (Web Query) files,486–487
IQY files,484, 486,487
IRibbon control, 303–305,310, 311,316, 403
IRibbon parameter, 309
IRibbonControl object,1042
IRibbonExtensibility object,1043
IRibbonUI object,1043
Irr method,965
IRtdServer object,767–768
IrtdServer object,870
IRTDUpdate event,768
IRTDUpdateEvent object,768
IsAddin property,375, 380–382
IsAddin property,Workbook object, 940
ISBLANK function, 67
IsBoolean function, 541
IsBroken property,Reference object, 984
IsCertificateExpired property,SignatureInfo
object,1063
IsCertificateRevoked property,SignatureInfo
object,1063
IsCertificateUntrusted property,SignatureInfo
object,1064
IsDate function, 541
IsDateUS function, 544
IsEmptyWorksheet function, 323,324
IsErr method,965
IsError method,544, 965
IsEven method,965
IsInplace property,Workbook object, 940
IsLogical method,965
IsMember property,Boolean Read-only,820
IsNA method,965
IsNameIn workbook,133, 134,135
IsNonText method,965
IsNumeric function, 541,965
IsOdd method,965
Ispmt method,965
IsPriorityDropped property
CommandBarButton object, 1004
CommandBarComboBox object, 1007
CommandBarControl object, 1011
CommandBarPopup object, 1014
IsReadOnly property,MetaProperty object, 1045
IsRequired property,MetaProperty object, 1045
IsSignatureLine property,Signature object, 1062
IsSigned property,Signature object, 1062
IsText method,965
IsValid property
CalculatedMember object, 678
SignatureInfo object, 1064
Italic buttons,4, 8
Italic property,Font2 object, 1036
<item .../> control type,300
Item method
Add-ins collection,974
COMAddins collection,997
FileDialogFilters collection,1034
FileDialogSelectedItems collection,1034
overview,636
RulerLevels2 collection,1052
TabStops2 collection,1069
TextRange2 object, 1071
ThemeFonts collection,1073
Item property,101
Adjustments object, 640
AllowEditRanges collection,641
Areas collection,664
1107
Item property
I
n
d
e
x
Documents you may be interested
Documents you may be interested