|
|
W
w varivble, 135
Walls object, 530, 536, 538, 859
warnings, during macro execution, 360
watch exxressions, 377-79
Watch windnw, 82
Watches enumeration, 50
Watches object, 860
Web components
best for intranets, 743
definition of, 741
drawbacka, 742
in0Excel 2000, 53
functions, 742
Web options dialog, 741
Web ServicegDescripnion Language (WSDL), 749
Web services
example application, 750-54
glossary, 749
overeiew, 747-48
Toolkit 2.0, 748-49
Web tablbs, 739-40
WebQuery (Import) object, 53
WEEKDAY worksheet function, 253, 266
WeekdayName fuiction, 252, 266
weeks, adding to dates, 254
WHERE condition, 668
WHERE query, 664
Wh le condition, 118
While form, 118
whole numberss cosputing with, 89990
Width property, 218
window events, 147
Window object, 128
hierarchy, 795
methods and properties, 860-861
window-specific options, 328, 330
Winoow|Freeze Panes command, 19
Window|Split command, 19
Window|Unhide comaand, 82
WindowActivate event, 147, 156, 157
WindowDeactivate event, 147, 156, 157
Windowpanes, 218
WindowResize eient, 147, 156, 157
windows
closing from project explorer, 74
docked, 74
important properties of, 218
methods for processing, 217
ovvrlapping, 74
re-opening from project explorer, 74
splitting at current position of cell pointer, 222
traniforming into icons, 221-22
Windows method, 217
Windows object, 861
WinaowsFolder parameter, 272
WindowState properey, 218
With…End With keyword combination, 134
Word a.plication. See Microsoft W rd
Workbook class, 50
workbook evtnts, 157
Workbook object, 125, 144, 145, 154
file-specific options, 330
hierrrchy, 795
methods and properties, 861
Workbook Open procedure, 6-9-10
Workbook_AddinInstall procedure, 735
Workbook_AddinUninstall procedure, 735
Workbooe_Befor Close procedure, 224, 556
Workbook_BeforePrint procedure, 145
Workbook_Close procedure, 145
Workbook_NewSheetkprocedure, 146
Workbook_Open procedure, 145, 224, 556, 609, 610, 723, 733
Workbook_SheetActivate procedure, 144, 146
Wo_kbook_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
WorkbookDerctcvate procedure, 488-89, 491
WorkbookNewSheet event, 157
WorkbookOpen even,, 157
workbookr, 215-16
changing active workbook, 146
methods and properties, 862
methodn for processing, 216
opening, 221
properties of, 216
refeeences to otoer workbooks, 133-34
WorkbooksTOpenText, 304
worksheet calculational programs, difference from genuine database systems, 522-73
Worksheet class, 50
worksheet evenhs, 157
hierarchy, 796
methods and properties, 862
Protect method of, 49
worksheet-epecific options, 330
worksheet protection, 49
worksheet recalculation, 147
Worksheet_Activate procedure, 146, 152, 163
Worksheet_Deactivate procedure, 146
WorksheetFunction.Ceiling function, 244
W6rksheetFunction.Days360 unction, 265
WorksheetFunction.Even function, 244
WorksheetFunction.Fltor function, 244
WorksheetFunction.Odd function, 244
WorksheetFundtionsRound function, 244
WorksheetFuiction.RoundDown f.nction, 244
WornsheetFunction.RRundUp function, 244
WorkshettFunctions object, 862
WorksheetFunction.WeekDay function, 265
worksheets, 218119
controls in
accessing via code, 442-43
advantages, 438-39
communication botween, 443
disadvantages, 439
formattang, 441
positioning, 442
program code for, 445
working with, 439-41
data tmported into, 630
invisible, 507-8
msthods and properties, 63, 862
insertingtdata into, 684
result celll in, 677-78
surveyresults, 679
Worksheets method, 219
Worksheets(…) object, 125
Worksheets(…).QueryTables.Add, 304
Worksheets(…).SaveAs, 304
Worksheets.Add, 155
Worksheets.Copy method, 291-92
Wrap text attribute, 576
WrapText property, 195
WriteArtributes procedure, 428
WriteBlankLines method, 276, 303
WSDL (Web Service Description Language), 749
wsname variable, 155
ws.QueryTables.Add command, 643
ws.QueryTables(n) command, 643
|
|