Index_W


W

Wait parameter (SendKeys command), 61
Watch window, 83
WAV file sound, playing from within code, 192
Weekday function, 60
While..Wend loops , 40
WHO function, user -defined, 221 ‚ 223
Wildcard characters , with Like operator, 75
Windows, using API calls to access, 183 ‚ 192
Windows collection, 207, 210, 214, 244
Windows object, 149 ‚ 153
Windows object properties and methods , 149 ‚ 153
Windows.selectedsheets object, 218, 220, 247, 283
WindowState property (Windows object), 152 ‚ 153
WIN32 API, 183
With statement, 200 ‚ 201, 289, 292, 298
Word document
creating an Excel spreadsheet from within, 166 ‚ 168
creating from within Excel, 161 ‚ 164
Workbook object, 5
creating in memory, 137
date and time created, 221
finding who created, 221 ‚ 223
HasPassword property, 128, 193
in object hierarchy, 136, 138
Saved property, 128
SheetChange event, 129
Workbook object events, 10
Workbook object methods, 127, 147 ‚ 148
Workbook object properties, 127, 147 ‚ 148
Workbook_NewSheet event, 7 ‚ 8
Workbook_Open event, 6 ‚ 7, 298
Workbooks collection, 129 ‚ 130, 132, 137
Workbooks (Workbook objects)
Count property, 126
in object hierarchy, 137
Save and Save As methods, 130
searching multiple, 269 ‚ 276
sorting the worksheets in, 229 ‚ 230
Worksheet names , displaying in a message box, 134
Worksheet object, 9, 153 ‚ 155
events, 10
in object hierarchy, 136 ‚ 138
properties and methods, 153 ‚ 155
Visible property, 126
Worksheets
searching multiple, 269 ‚ 276
sorting into alpha order, 229 ‚ 230
Worksheets collection, 132 ‚ 133, 137, 265
WrapText property (Range object), 159
WritePrivateProfileString API function, 186



Excel VBA Macro Programming
Excel VBA Macro Programming
ISBN: 0072231440
EAN: 2147483647
Year: 2004
Pages: 141

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