Index_W

 < Day Day Up > 



W

Wait method, 117, 128

warning box, during validation, 188

Watch window, 45

Web

currency quotes on, 94

Excel color palette on, 226-29

publishing worksheets to, 523-25

Web Components

adding interactivity with, 534-35

in Office 2003, 11

Web Options dialog box, 522

Web pages

adding interactivity on, 526

containing frames, 528

naming, 521

opening as workbooks, 528

opening in Excel, 528

parsing, 532

posting on the Internet, 523-25

presenting results as, 533-37

publishing to behave like spreadsheets, 11

saving help and informational files as, 146

saving worksheets as, 520-23, 534

specifying titles for, 522

Web Queries, 529-31, 532

Web server. See also server

communicating with, 536-37

posting new results directory to, 534

sending information to, 536

setting up, 533

Web Servers Home Directory, 533

Web sites, 525, 531

Web-based worksheets, 525-27

WebTables property, 531

Weekday function, 214

Weight argument of BorderAround method, 237

Weight property of Borders object, 236

Where clause

comparison operators in, 473

in Select statement, 473

in Update statement, 479

white space

determining for a worksheet, 154

stripping from a string, 196

white VBA color constant, 219

width of a cell, 174

Width property

of ChartObject object, 337

of Column object, 172

of CommandBar object, 368

of CommandBarControl object, 375

of a user form, 398

of a user form control, 403

of UserForm object, 398

wildcard characters

used with the Access database, 474-75

using with SEARCH, 203

Window menu in Visual Basic Editor, 53

Window Settings options, 51

window state of an application, 446

windows. See also code windows

arranging all open when a workbook is deactivated, 271

controlling the zoom level of, 114

layout preventing users from changing, 143

moving, 49

moving to display a particular cell, 114

returning the currently selected, 113

returning to a docked position, 49

simultaneous scrolling of two, 7

specifying dockable, 52

undocking, 49

Windows authentication, 504

Windows Explorer, 53

Windows program controls, 19

Windows registry

manually changing, 250

verifying entries in, 256

Windows-based applications, starting from a DOS window, 446

wininet.dll file, wrapper for, 536

With...End With command, 73

WithEvents keyword, 278, 304, 310

WizardApp.xls, 432

wizards

building multi-step, 431-41

collecting options for, 438-40

navigating pages in, 435-37

running, 441

summarizing options in, 440

Word application, late binding with, 450

Word documents, 457-59, 460-62

WordWrap property, 405

Workbook event procedures, 268

Workbook events, 265, 267-73

Workbook object, 107

calling the Save method, 135

contained in an Application object, 326

creating, 456

events attached to, 268

events for, 267

as the parent of the Charts collection, 326

returned by ActiveWorkbook, 115

as the top-level object, 457

workbook window

controls, 19

scrolling through, 276

Workbook_Activate event, 246

Workbook_AddinInstall event, 245

Workbook_AddinUninstall event, 245

Workbook_BeforeClose event, 434, 500

Workbook_BeforeSave procedure, 271

Workbook_Close event, 246

Workbook_Deactivate event, 246

Workbook_Open event, 246, 269

in Application object, 277

in Excel Query program, 499

in ThisWorkbook module, 433

Workbook_Open event procedure, 268, 269, 272, 279

WorkbookOpen function, 279

workbooks, 13, 129

activating, 137, 145

adding sheets to the end of, 151

adding XML to manually, 550-53

building new quarterly, 115

changing every open, 129

changing the active, 137

changing the position of sheets in, 153

checking for write-protected, 142

checking to see if open, 134

closing, 138

comparing side by side, 7

copying color palettes from, 225

creating, 129, 151, 241-43

detecting when opened, 279

digitally signing, 39

displaying in Print Preview mode, 148

displaying macros in, 31

forcing to recalculate, 120

of macro currently running, 119

making backup copies of, 137

maximizing, 270

maximum number of colors, 14

methods, 145-47

modifying all charts in, 338

opening, 130-35

opening Web pages as, 528

printing and previewing, 147-48

properties of, 138-44

protecting from changes, 142-43

providing hot keys specific to, 126

recalculating, 119, 120, 272

referencing the currently selected, 115

removing protection from, 144

requiring passwords to open, 141-42, 157

saving, 135-37, 138, 141, 242

selecting a range of cells from, 415

signing VBA code associated with, 39

write-protected, 142

Workbooks collection, 129-48

worksheet elements

assigning colors to, 223

formatting, 230-31

Worksheet events, 265, 273-76

worksheet functions, 197

Worksheet object

contained in Workbook object, 326

containing a PivotTable, 348

events for, 273

Worksheet_Change procedure, 230

calling itself repeatedly, 266

executing, 275

monitoring the Change event, 267

WorksheetFunction object

calling the PMT function, 209

calling the SEARCH and FIND functions, 204

calling worksheet functions as properties of, 197

need for, 196

worksheets, 13, 14

alternative data sets for, 15

centering vertically on the printed page, 154

changing the name of, 149

changing the tabs of, 230

code ensuring an empty, 357

colors in, 219-31

compared to tables, 467

computing the previous row in, 425

creating with new PivotTables, 357-58

data limits of, 14

dealing with two-dimensional data, 341

entering information into, 419-31

event triggered when right- clicking, 274

forcing to print on a specified number of pages, 155

methods, 156-60

navigating among, 14

navigating event procedures in, 274

number of default, 13

printing on a specified number of pages, 154

proving two at a time, 159

publishing to the Web, 523-25

recalculating all formulas in, 156

reducing read and writes to, 185

reformatting the elements of, 219-37

removing unused from a workbook, 116

retrieving currently selected, 112

right-clicking, 276

saving as Web pages, 520-23, 534

selecting, 160

shrinking for printing, 154

typing data into, 187

Worksheets collection, 149-50, 151

Write# statements, 296

write-only property, 304

write-protected workbooks, 142

WriteReserved property, 142

write-reserved workbook, 130

WriteResPassword parameter, 130, 136



 < Day Day Up > 



Microsoft Excel 2003 Programming Inside Out
Microsoft Office Excel 2003 Programming Inside Out (Inside Out (Microsoft))
ISBN: 0735619859
EAN: 2147483647
Year: 2006
Pages: 161

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