Index_S


S

sales by employee example, 634-35
SalesRankNPrice web service, 750-52
Save As form, 145
Save Data with Table Layout option, 708
Save macro, 22
Save method, 216, 667
save options, 328
Save Password option, 639
Save Query Definition option, 638
SaveAccountData procedure, 615, 616
SaveAs method, 216, 295
SaveAsUI procedure, 145
SaveCopyAs method, 216
Saved property, 217
SaveRangeAsMmaFile, 298
SaveRangeAsMmaFile procedure, 296
SaveTemplate procedure, 517
saving
automatically, 80
data in balance sheet example, 615-16
files, 145
queries, 639
savings account, computing interest in. See interest in savings account example
"Scale to fit page" option, 534
Scenario object, 847
Scenarios object, 847
Scientific function, 300-301
scientific.txt file, 287, 288, 290
ScreenUpdating property, 211, 356-57, 369
Scripting Library, 801
Scripting Runtime library, 267-69
scroll bars, in forms, 429-30
ScrollArea property, 319, 326
ScrollBar object, 847
ScrollColumn property, 218
ScrollRow property, 218
Scrrun.dll object library, 131, 132
searchDirection parameter, 589
SearchFormat := True parameter, 200, 201
searching, 589-90
cells , 200-201
for Office documents, 59
searchOrder parameter, 589
Second function, 250, 266
SECOND worksheet function, 253, 266
Section object, 59, 847
Sections object, 847
security, 61, 573
Seek command, 278, 279, 305
SELECT * FROM table, 655, 675
Select Activate method, 188
Select Case keyword, 114, 115
SELECT COUNT(id) command, 679
Select event, 158
SELECT field1, SQL command, 668
SELECT field2, SQL command, 668
SELECT INTO command, 666, 668
Select method, 187, 189, 216, 220, 540
SELECT query, 663, 665
SELECT*FROM view, 655
SelectedItems, 286
SelectedSheets method, 219
SelectedSheets property, 128
SelectFilename function, 296-97
selection, defined, 186
Selection method, 63
Selection property, 128, 188, 540, 541
Selection.Address method, 192
SelectionChange event, 147, 157
Selection.Copy instruction, 229
SelectRow procedure, 203
SelectXxx property, 128
Semicolon parameter, 291
SendKeys command, 23
SendKeys method, 389-90, 788, 789
SendMail method, 737-38
serial numbers , in smart forms, 503
Series object, 536, 539, 848
SeriesChange event, 158
SeriesCollection object, 536, 848
SeriesLines object, 848
Server keyword, 653
Set keyword, 135
SetAttr command, 304
SetFocus method, 407
SetSourceData method, 714, 727
Sgn function, 234, 244
Shadow object, 560
ShadowFormat object, 849
Shape objects, 57, 147, 442, 560, 566, 797-98, 849
ShapeNode object, 850
ShapeNodes object, 560, 850
ShapeRange object, 560, 561, 849
shapes , drawing, 560-64
Shapes object, 560-64, 850
shared workbooks, 324
ShareName property, 269, 302
Share.xlt file. See balance sheet example
sharing files, 56
shCount variable, 299
Sheet n object, 76
Sheet[De]Activate, 145
SheetActivate event, 144, 156, 157
SheetActivate event procedure, 481
SheetBeforeDoubleClick event, 146, 156, 157
SheetBeforeRightClick event, 146, 156, 157
SheetCalculate event, 147, 156, 157
SheetChange event, 156, 157
SheetCombo_OnAction event procedure, 482
SheetDeactivate event, 156, 157
sheets, 219-21
changing, 145-46
deleting, 224
important properties of, 221
jumping from first to last sheet of list, 224-25
methods for working with, 220
Sheets method, 126, 219
Sheets object, 126, 851
SheetSelectionChange event, 156, 157
Shell command, 786-88, 789
Shift+Ctrl+Page Down key combination, 148
Shift+Ctrl+Page Up key combination, 148
Shift+Ctrl+Return key combination, 103
Shift+F2 key combination, 78, 84
Shift+F8 key combination, 84
Shift+Tab key combination, 78, 84
shList variable, 299
ShortName property, 302
ShortPath property, 302
Show Data list, 700
Show Hidden Members command, 73
Show method, 388, 389, 434
ShowDataForm command, 23
ShowDataForm method, 391, 591
ShowDetail property, 691
ShowInfo method, 169
ShowLevels method, 690-91
ShowMe method, 447, 452
ShowNewWord procedure, 36, 38
ShowPopup method, 477, 483
Simple Object Access Protocol (SOAP), 749
Sin function, 244
single step mode, 376
Single variables , 88, 89, 95, 282
Size property, 273, 302
Skip method, 276, 303
SkipLine method, 276, 303
smart forms
charts in, 504
defined, 495-96
design elements
cell protection, 498
color , 504
compound conditionals, 500-501
conditional formatting, 502
current date, 503
data validation, 498-99
headers and footers, 503
IF formulas, 499-500
label formatting, 501-2
layout, 503
previews, 499
serial numbers, 503
templates, 497-98
embedded formulas in, 496
examples
car-sharing club balance sheet, 518-25
Speedy invoice form, 509-18
included with Excel, 509
integrating controls into, 504
sample uses, 497
separating template from code, 525
shortcomings
input error protection, 525
not fully functional as database, 526
storage space, 525-26
templates for creating, 496
smart tags
activating, 744-45
additional lists of, 745
developing with VBA, 746
in Excel 2002, 50
overview, 744
turning on and off, 747
VBA access to, 746-47
SmartTag object, 851
SmartTagAction object, 851
SmartTagActions object, 852
SmartTagOptions object, 852
SmartTagRecognizer(s) object, 852
SmartTags object, 852-853
SmartTagXxx objects, 50
smoothing data, 532-33
SOAP (Simple Object Access Protocol), 749
Solver Add-In, 211-12
SolverOK, 211
SolverOptions, 211
Solver\Solver.xla file, 132
Sort macros, 21
Sort method, 590
Sort recordset property, 667
sort symbol, 636
sorting
data, 581-82, 590
tables, 19
SoundNote object, 853
Sources parameter, 602
Space function, 236
Space parameter, 291
special functions, 235
SpecialCells method, 191, 203
SpecialCells property, 260
SpecialCells(xlVisible) method, 229, 592
Speech object
in Excel 2002, 50
methods and properties, 853
speed optimization, for procedures, 356-57
Speedy invoice form example
controls, 511
design elements, 512-13
essential fields, 509-10
predefined formulas for discount calculation, 510-11
program code, 513-14
shortcomings, 517-18
spin buttons
applications, 453-56
overview, 429-30
SpinButton object, 853
Split function, 237
Split property, 218
SplitColumn property, 218
SplitRow property, 218
spreadsheet calculational programs, difference from genuine database systems, 572-73
SQL property, 640
SQL server, 652
SQL (Standard Query Language), 572
abbreviations, 655
code, 636-37
commands, 625, 662-66
and MS Query, 636-37
and String variables, 715
sql2string.exe file, 715
Sqr function, 244
stability of Excel, 59
stacked charts, 848
Staff.doc file, 593
Staff.xls file, 577-78, 584, 586
startevents, 151
StartRow parameter, 290
StartupPath property, 52, 284
StartupPosition property, 451
State method, 668
State recordset property, 667
Static Sub/Function keyword, 112
static variables, 109
Static var keyword, 112
status bar, properties of, 357-59
StatusBar property, 358-59, 368
STDEV(age) command, 679
StdFont object, 853
StdOle2.tlb object library, 131
StdPicture object, 854
Step keyword, 116
stock management example, 597
Stop command, 386
Stop Recording option, 17
StopApplicationEvents, 152
stored procedures, 814-15
Str function, 246, 300
StrComp function, 238
String function, 236
String keyword, 90
-String variables, 88
String variables, 95
StrReverse function, 237
Style object, 195-96, 854
Style property, 195, 196, 469
styles, linking with tools, 9-15
advanced concepts, 15
defining new tools, 12-13
deleting new toolbars , 14
modifying tools, 14
overview, 9-10
recording macros, 11-12
"Result" custom style, 10
Styles object, 854
Sub Auto_Add( ) End Sub procedure, 156
Sub Auto_Close( ) End Sub procedure, 156
Sub Auto_Open( ) End Sub procedure, 156
Sub Auto_Remove( ) End Sub procedure, 156
Sub instruction, 140, 155
Sub macro1( ) instruction, 86
Sub Name ( ) command, 5
Sub Name instruction, 77
SubFolders property, 273, 302
Sub/Function keyword, 112
submenus, 471
subprograms, 104
SUBTOTAL function, 596
SubTotal method, 689-90
subtotals, 688-91
Subtotals property, 717, 718, 729
sum function, 104
Summarize listbox, 700
SummaryColumn property, 691
SummaryRow property, 691
Supports method, 657, 667
survey data, analysis of, 43-44
survey database, 679-83
survey directory, 670
survey worksheet, 674, 684
survey_template.xls file, 684
surveydata table, 674, 675, 677-78
surveyresults worksheet, 679
survey.xls file, 670, 672-73
syntax control, 372-73
system errors, 59



Definitive Guide to Excel VBA
Linux Application Development For The Enterprise (Charles River Media Programming)
ISBN: 1584502533
EAN: 2147483647
Year: 2002
Pages: 134

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