Excel VBA Macro Programming

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