104
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
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
109
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
102
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
113
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
104
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
111
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