Walls object, 530, 536, 538, 859
warnings, during macro execution, 360
watch expressions, 377-79
Web components
best for intranets , 743
definition of, 741
drawbacks, 742
in Excel 2000, 53
functions, 742
Web Service Description Language (WSDL), 749
Web services
example application, 750-54
glossary, 749
overview, 747-48
Toolkit 2.0, 748-49
WebOptions object, 744, 860
WebQuery (Import) object, 53
WeekDay function, 251, 265
WEEKDAY worksheet function, 253, 266
WeekdayName function, 252, 266
weeks, adding to dates, 254
While “Wend loop, 119, 280
whole numbers , computing with, 89-90
Window object, 128
hierarchy, 795
methods and properties, 860-861
window-specific options, 328, 330
WindowFreeze Panes command, 19
WindowActivate event, 147, 156, 157
WindowDeactivate event, 147, 156, 157
WindowResize event, 147, 156, 157
windows
arranging, 18-19, 390
closing from project explorer, 74
docked , 74
important properties of, 218
methods for processing, 217
overlapping, 74
re-opening from project explorer, 74
splitting at current position of cell pointer, 222
transforming into icons, 221-22
WindowsFolder parameter, 272
WindowState property, 218
WinWordAddresses, 592, 593
With keyword, 134-35, 202
With End With keyword combination, 134
WithEvents keyword, 151, 160
Word application. See Microsoft Word
Workbook object, 125, 144, 145, 154
in Excel 97, 56
file-specific options, 330
hierarchy, 795
methods and properties, 861
Workbook Open procedure, 609-10
Workbook_AddinInstall procedure, 735
Workbook_AddinUninstall procedure, 735
Workbook_BeforeClose procedure, 224, 556
Workbook_BeforePrint procedure, 145
Workbook_Close procedure, 145
Workbook_NewSheet procedure, 146
Workbook_Open procedure, 145, 224, 556, 609, 610, 723, 733
Workbook_SheetActivate procedure, 144, 146
Workbook_SheetDeactivate procedure, 146
WorkbookActivate event, 156
WorkbookActivate procedure, 481, 488-89, 491
WorkbookAddinInstall event, 156
WorkbookAddinUninstall event, 156
WorkbookBeforeClose event, 156
WorkbookBeforePrint event, 157
WorkbookBeforeSave event, 157
WorkbookDeactivate event, 157
WorkbookDeactivate procedure, 488-89, 491
WorkbookNewSheet event, 157
workbooks, 215-16
changing active workbook, 146
methods and properties, 862
methods for processing, 216
opening, 221
properties of, 216
references to other workbooks, 133-34
worksheet calculational programs, difference from genuine database systems, 572-73
worksheet functions, 232, 266
Worksheet object, 144, 145
hierarchy, 796
methods and properties, 862
Protect method of, 49
worksheet-specific options, 330
worksheet recalculation, 147
Worksheet_Activate procedure, 146, 152, 163
Worksheet_Deactivate procedure, 146
WorksheetFunction.Ceiling function, 244
WorksheetFunction.Days360 function, 265
WorksheetFunction.Even function, 244
WorksheetFunction.Floor function, 244
WorksheetFunction.Odd function, 244
WorksheetFunction.Round function, 244
WorksheetFunction.RoundDown function, 244
WorksheetFunction.RoundUp function, 244
WorksheetFunctions object, 862
WorksheetFunction.WeekDay function, 265
worksheets, 218-19
controls in
accessing via code, 442-43
advantages, 438-39
communication between, 443
disadvantages, 439
formatting, 441
positioning, 442
program code for, 445
working with, 439-41
data imported into, 630
invisible, 507-8
methods and properties, 63, 862
result, 672-73, 674
inserting data into, 684
result cells in, 677-78
survey, 674, 684
surveyresults, 679
Worksheets( ) object, 125
Worksheets( ).QueryTables.Add, 304
Worksheets( ).SaveAs, 304
Worksheets.Copy method, 291-92
WriteAttributes procedure, 428
WriteBlankLines method, 276, 303
WriteLine method, 276, 303
WSDL (Web Service Description Language), 749
ws.QueryTables.Add command, 643
ws.QueryTables(n) command, 643