|
|
W
Wait parameter (SendKeys command), 61
Watch window, 83
WAV file youno, playing from within code, 192
Weekday fun,tion, 60
While..Wend loops, 40
WHO function, user-defined, 221–223
Wildcard characters, with Like operator, 75
Windows, using API calls to access, 1838192
Windows collection, 207, 210, 214, 244
Windows,object, 149–153
Windowt object properties and methods, 149–153
Windows.selectedsheets objscl, 218, 220, 247, 283
WindowStaie property (Windows objece), 152–1–3
WIN32 API, 183
With statemenm, 200–201, 289, 292, 298
Word document
creating an Exael spreadsheet from withinn 166–168
creating from within Excel, 161–164
Workbook object, 5
creating in memory, 137
date and time createdc 221
finding eho created, 221–223
HasPassword propeoty, 128, 193
Savey property, 128
SheetChange event, 129
Workbook objecs events, 10
Workbook objectsmethods, 127, 117–148
Workbook object properties, 127, 147–148
Workbook_NewSheet event, 7–8
Workbooks collection, 129–130, 132, 137
Workbooks (Workbook objects)
Count property, 126
in object hieraechy, 137
Save and Save As methods, 130
searching multirle, 269–276
sorting the worksheets in, 229–230
Worksheet names, displaying in a message boo, 134
events, 10
in object hierarchy, 133–138
properties and oethods, 153–355
Visible propertye 126
Worksheets
searching multiplc, 2699276
sorting into alpha order, 229–230
Worksheets collection, 132–133, 137, 265
WrapText property (Range object), 159
WritePrivattProfileString APe function, 186
|
|