Index_M

 < Day Day Up > 



M

macro code, 34, 35

Macro dialog box, opening, 41, 91

macro helpers for PivotTable presentations, 359

Macro Name box, 29

macro security settings, 36

macro toolbar buttons, 32

macro viruses, 36

macro writer's trick, 356

macros, 29

adding weekday and date, 113

assigning to key sequences, 31

assigning to menu items, 33

assigning to toolbar buttons, 32

breaking up into several procedures, 54

building a new quarterly workbook, 115

calculating the active sheet, 120

creating charts as object variables, 322

creating new sheets, 112

debugging, 34-36

digitally signing, 39

displaying alerts while running, 116

editing or viewing, 41

executing the next step in, 35

implementing security for, 36-40

increasing the Zoom level, 114

intersection of two ranges, 124

iterating through a collection class, 315

locating the ProductList.xls file, 120

monthly totals, 122

one-click access to zoom, 114

pausing, 117

recalculating all open workbooks, 119, 120

recording, 29, 356, 531

removing all unused worksheets, 116

running, 31-34, 93

saving every open workbook, 137

signing with expired certificates, 39

skipping a step in, 35

storing, 55

viewing VBA code for, 29

Macros dialog box, 48

magenta VBA color constant, 219

magnification level, 154

mail. See e-mail messages, sending

Main procedure, 104

main program feature of an EXE component, 248

Make Same Size item on the Format menu, 46

MakeConnection method, 353

MakeOutlookAppointment- LateBinding procedure, 450-52

malware, 36

manual page breaks, 155

Map property, 558

Margin Indicator Bar, 51

marker sequences, 203

MatchEntry property, 413

MatchFound property, 415

MatchRequired property, 415, 430

MAX function, 206, 477

Max property

of ScrollBar control, 411

of SpinButton control, 407

Maximize button, 19

MaxLength property, 406

maxOccurs=unbounded parameter setting, 548

Me keyword, 311, 313, 505

measures, 342, 343

MEDIAN function, 206

median value, 206

Medium macro security level, 37

member of a collection, 108

MemoryUsed property

of PivotCache object, 353

of PivotField object, 355

menu item, assigning a macro to, 33

menu structure, dialog boxes accessing options, 392

menu system, parts of, 365-71

MenuAnimationStyle property, 366

menus

adding items to existing, 382

manipulating for custom add-ins, 365

in Visual Basic Editor, 44-48

message box statement, 67

message boxes

button options for, 68-69

creating, 67-70, 104

displaying, 69, 119

displaying error descriptions, 429

displaying information about charts, 139

with a welcome or information message, 70

messages on the status bar, 67-70, 117

metadata, 6

methods, 27, 107, 119, 300

adding to allow initialization of all properties of a class, 313

characterizing as verbs, 300

of a class, 304

of Command object, 488

of CommandBar object, 367-68

of CommandBarComboBox object, 378-79

of CommandBarControl object, 373-76

of CommandBars collection, 366-67

of Connection object, 484

defining, 309

of Errors collection, 486

of ListObject object, 542-44

of Recordset object, 491-94

for taking action in workbooks, 145-47

of user form controls, 402-4

of Validation object, 187

of XmlMap object, 554-56

of XPath object, 557

Microsoft Access. See Access

Microsoft ActiveX Data Objects 2.7 library, 498

Microsoft Excel. See Excel

Microsoft Excel 11.0 Object Library, 254

Microsoft Excel Object Model, 107, 108

Microsoft Internet Controls object library, 532

Microsoft Internet Transfer Control, 536

Microsoft Jet, 485

Microsoft Office applications. See Office applications

Microsoft Office Excel 2003. See Excel

Microsoft Office Excel Add-in, 239

Microsoft Office Excel item on the View menu, 45

Microsoft Office Excel Objects folder, 42

Microsoft Office Web Components. See Web Components

Microsoft Office Web site, 239

Microsoft OLE DB Provider for ODBC Drivers, 486

Microsoft Outlook. See entries under Outlook

Microsoft SQL Server. See SQL Server

Microsoft Visual Studio .NET. See Visual Studio .NET

Microsoft Windows SharePoint Services. See SharePoint Services

MID function, 202, 204

MIN function, 206, 477

Min property

of ScrollBar control, 411

of SpinButton control, 407

Minimize button, 19

minus sign (-), 134

Minute function, 214

mixed state for a button, 376

modal form, displaying, 399

modality for a message box, 69

MODE function, 206

mode parameter of Open statement, 295

Mode property of Connection object, 484

modeless forms, 399, 400

Modify method, 189

ModifyActiveChart procedure, 328

ModifyChart procedures, 328

ModifySpecificChart procedure, 329

Module item on the Insert menu, 45

module windows, 51

module-level variables

declaring, 63, 259

resetting, 48

modules, 42. See also code modules

adding, 53

copying between projects, 57

creating, 55

deleting, 56

exporting, 56

inserting into current projects, 45

opening, 53

separating code by task, 53

Modules folder, 42

month, weekday and date for the upcoming, 113

Month function, 214

monthly payment on a loan, 208

MonthlyPayment function, 209

MonthName function, 214

Move method

of CommandBarControl object, 374, 375

of Recordset object, 491

of Sheets collection, 153

MoveFirst method, 491

MoveLast method, 491, 493

MoveNext method

in CopyRows routine, 515

of Recordset object, 492, 493

MovePrevious method, 492, 493

MsgBox (message box) function, 67, 68-69

MsgBox procedure, 104

msinet.ocx, 536

msoBarFloating value, 370

msoControlActiveX constant, 372

msoControlAutoCompleteCombo constant, 372

msoControlButton constant, 372

msoControlButton objects, 375, 380

msoControlButtonDropdown constant, 372

msoControlButtonPopup constant, 372

msoControlComboBox constant, 372

msoControlCustom constant, 372

msoControlDropdown constant, 372

msoControlEdit constant, 372

msoControlExpandingGrid constant, 372

msoControlGauge constant, 372

msoControlGenericDropdown constant, 373

msoControlGraphicCombo constant, 373

msoControlGraphicDropdown constant, 373

msoControlGraphicPopup constant, 373

msoControlGrid constant, 373

msoControlLabel constant, 373

msoControlLabelEx constant, 373

msoControlOCXDropdown constant, 373

msoControlPane constant, 373

msoControlPopup constant, 373

msoControlPopup item, 380

msoControlSpinner constant, 373

msoControlSplitButtonMRUPopup constant, 373

msoControlSplitButtonPopup constant, 373

msoControlSplitDropdown constant, 373

msoControlSplitExpandingGrid constant, 373

MsoControlType enumeration, 366, 367

msoControlWorkPane constant, 373

msoFileDialog constants, 292

msoFileType constants, 283

msoFileTypeExcelWorkbooks constant, 283

msoLastModified constants, 284

msoSearchIn constants, 288

multidimensional arrays, 65, 186

multidimensional reports, 341

multi-line If...Then...Else statements, 74

MultiLine property of a text box, 439

Multiline property of TextBox control, 405

multi-line text box control, 440

multi-line text boxes, 405

MultiPage control, 417

containing connection information, 502

hiding tabs, 503

incrementing the Value property, 436

leaving tabs visible in design mode, 502

Page objects contained in, 434

tabs at the top of, 436

MultiPage1_Change event, 437

multiple applications, 465-66

multiple cells, transferring, 185

multiple file types for a search, 286

multiple items, selecting, 413

multiple object variables, 303

MultiRow property, 416

MultiSelect property, 413

multi-step wizard, 431-41

My List Has Headers check box, 540

MyCOMAddinSetup Wizard, 261

MySuppliers.xml file, 549-50

MySuppliers.xsd schema, 558, 560



 < 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

Similar book on Amazon

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