Index_S

---

S

Save As built-in dialog, 383

Save As dialog box, 242, 291

Save as Web Page dialog box, 521

Save button, 424, 427

Save method, 135

SaveAs method

of ThisWorkbook property, 135-36

for workbooks, 116

of Worksheet method, 159

of Worksheet object, 156, 159

SaveAsUI argument, 271

SaveAsWebPage procedure, 525

SaveCopyAs method, 137

Saved property, 273

SaveData method, 316

SaveData routine, 506

SaveDataSourceDefinition property, 554

SaveLinkValues property, 141

SaveSetting routine, 504

Scenario Manager dialog box, 15

scenarios, 15

Scenarios parameter, 158

schema standards document, 547

schemas, 10, 546

adding to active workbooks, 556

creating custom, 546-49

importing data into, 552

mapping elements to cells, 557-62

mapping Excel data to, 10

mapping to single lists, 560

mapping to worksheets programmatically, 553-57

saving as XML schema files, 548

Schemas property of XmlMap object, 554

schema-validation errors, 554

scope of variables, 62

ScopeFolder object, 288

ScopeFolders collection, 289

ScopeFolders file, 281

screen flashing, minimizing, 118

screen updates, disabling, 118

ScreenUpdating property, 118

scroll bars

adding to applications, 411

including the TextBox control, 405

Scroll event of ScrollBar control, 411

Scroll Lock key, 127

scrollable window, 51

ScrollBar control, 411

ScrollBars property

of TextBox control, 405

of UserForm object, 398

ScrollColumn property, 114

ScrollRow property, 114

search expressions with a Select statement, 473

Search For box in the Research task pane, 7

SEARCH function, 203-5

Search Results task pane, 20

searches, limiting, 286

SearchFolders collection, 289

SearchFolders file, 281

SearchIn constants, 288

SearchScope object, 287

SearchScopes collection, 287

SearchScopes file, 281

Search_SearchFolders collection, 291

Search_SearchFolders routine, 290

SearchSubFolders property, 282

Second function, 214

secondary keys, 469

seconds, number since midnight, 214

sections of cells, 233

security for macros, 36-40

Security Warning box, 40

Select All button, 19

Select Case statements, 75-77

creating effective, 90

definitive rules in, 89

generating an incorrect result, 88

in ListScopeFolderObjects procedure, 289

setting to the number of days in each month, 76

syntax of, 75

Select Certificate dialog box, 39

Select method

of Range object, 162

of Worksheet object, 156, 159

Select statement, 471-77

examples using, 472

Where clause, 473

Select XML Source dialog box, 551

selected cell, compared to active, 161

Selected property, 413

SelectedItem property (TabStrip control), 415

SelectedItems property (FileDialog object), 293

Selection Change event, 274

Selection object, 161

selection process, SHIFT and CTRL keys aiding in, 413

Selection property

of Application object, 117

compared to ActiveCell, 110

selection statements, 74-77

SelectionChange event, 265

SelectionChange event procedure, 276

SelectPrint routine, 183

Semicolon parameter, 133

SendKeys method, 127

sequence statement in an XML schema, 11

sequence tag for subelements, 548

series, 340

series area in a PivotChart, 346

SERIES formula

in a chart, 331, 332

editing, 332

modifying, 332

syntax of, 333

Series objects, 332, 340

server, 470. See also automation servers; Web server

Set command, 72

Set New statement, 301

Set Next Statement item on the Debug menu, 47

Set Page Title dialog box, 522

Set property routine, 306

Set routine, 304

Set statement, 122, 301, 456

set theory, 468

SetSourceData method, 325, 332, 359

SetupSearchFoldersCollection procedure, 289

SetValue method, 558

Shadow property, 337

Shared Add-in template, 257

Shared Add-in Wizard, 257

shared file, 136

shared workbooks, conflicting changes in, 136

Shared Workspace task pane, 7, 20

SharePoint Services, 6

lists and, 10

support for, 20

SharepointUrl property, 542

sheet tabs, 14, 21, 230

SheetActivate event

for Application object, 277

for a workbook, 269, 270

sheets. See also worksheets

adding to the end of workbooks, 151

copying or moving to a new workbook, 153

deleting by name instead of position, 152

displaying on the sheet tab, 150

forcing to be printed in black and white, 154

repositioning in workbooks, 153

types of, 13, 149

Sheets collection

index value beginning with 1, 151

methods, 150-55

properties in common with Worksheets, 149-50

specifying an array in, 153

Sheets In New Workbook box, 13

SheetSelectionChange event, 266

Shell function, 446

ShellExecute function, 447

SHIFT key

aiding in the selection process, 413

combining with key codes, 126

key codes for, 127

preventing the Workbook_Open procedure from executing, 270

SHIFT+CTRL+F6, 53

SHIFT+F8, 35

SHIFT+F9, 35, 157

shortcut key, assigning to a macro, 31

shortcut menus, disabling, 276

ShortcutText property, 376

Show method

displaying a dialog box, 385

of FileDialog object, 293

modal form as the default, 400

of a user form, 399

Show Next Statement item, 47

ShowAllItems property, 355

ShowAutoFilter property, 542

ShowCommandPopup routine, 380

ShowDatabaseInfo routine, 500

ShowDropButtonWhen property, 414

ShowError property, 188

ShowForm subroutine, 430

ShowImportExportValidationErrors property, 554

ShowInput property, 188

ShowPopup method, 368, 380

ShowTotals property, 542

Simonyi, Dr. Charles, 55

simple properties, 306

simple variable, compared to an object variable, 301

simultaneous scrolling of windows, 7

Single data type, 59, 62

single procedure view, 51

single quotes in SQL, 473

single-line If...Then...Else statements, 74

single-line text boxes, 405

single-precision floating-point number, 59

Size property of Font object, 232

Size To Fit item on the Format menu, 46

Size to Grid item on the Format menu, 46

SLOPE function, 5

SmallBags function, 101

SmallChange property

of ScrollBar control, 411

of SpinButton control, 407

smart documents, 6

Solver Add-in, 240

Sort property, 492, 493

sorting on protected worksheets, 158

source data for a PivotTable, 344

Source property, 492, 514

SourceType property, 542

Space parameter, 133

SpecialCells methods, 164, 176

SpecialEffect property, 402

Spell checking feature, 275

SpinButton control, 407, 408

SpinDown event, 407

SpinUp event, 407

Split command, 53

spreadsheet functionality, 526

Spreadsheet Web Components, 534

spreadsheets

comparing to databases, 467-70

publishing with Web components, 11

SQL (Structured Query Language), 468

extensions to, 471

manipulating databases, 471-80

SQL Server, 467

connection strings, 511

databases, 485

SQLState property of Error object, 487

square brackets ([]) in a time format, 217

Start command, 446

Start Searching button, 7

StartRow parameter, 133

StartUpPosition property, 398

State property

of CommandBarButton object, 376

of Connection object, 484

statements, provided in SQL, 471

statements element

of Function procedure, 99

of Sub procedure, 86

static controls, 401

Static element

of Function procedure, 99

of Sub procedure, 86

Static keyword, 97, 98

static procedures, 98

Static statement, 62

static variables, 62

static Web page, 521

static worksheet data, 520

statistical functions, 3-5

status bar, 21, 117

status messages, 67-70

StatusBar property, 117

STDEV function, 5, 206

STDEVA function, 5

STDEVP function, 5

STDEVPA function, 5

Step Into item, 47

Step Out item, 47

Step Over item, 47

step value in a For...Next loop, 77

STEYX function, 5

stop box, displaying during validation, 188

Stop Recording toolbar, 29, 30

storage requirements for data types, 58

stored procedures, 489, 490

STR function, 194

Strikethrough property, 232

string array, 65

string data, 194, 195

String data type, 59

string description of an error, 83

string expressions in conversion functions, 61

string variables in message boxes, 70

strings

adding characters to the beginning or end of, 199

comparing, 498

declaring, 60

determining the number of characters in, 197

empty, 60, 126, 468

finding within another string, 202-5

handling, 59

returning characters from, 200-202

types of, 59

structure of a workbook, 143

Structured Query Language. See SQL (Structured Query Language)

Style property

of ComboBox control, 414, 430

of CommandBarButton object, 376

of CommandBarComboBox object, 378

of MultiPage control, 436, 503

of TabStrip control, 416

Sub procedures

adding to a code module, 86

compared to Function procedures, 85

constructing a series of, 54

defining, 85-97

defining the scope of, 90-93

elements of, 86

running from within procedures, 93-97

syntax of, 86

SubAddress parameter of FollowHyperlink method, 146

subelements of Root element, 548

subroutines

called from within objects, 300

calling to process information on user forms, 405

defaulting to Public, 310

marking as Public, 304

public, 309

Subscript property, 232

subscription services, 8

subtractive color system, 220

SUM function, 98, 206

SUMIF function, 206

Summarize procedure, 206-8

summary calculations, 206-8

summary functions in SQL, 477

summary operation for cell data, 21

Superscript property, 232

Swedish krona, 94

syntax errors, 50

system model, 69

---