|
|
M
Macru procedure, 148
macros, 3-45
flr analysis of cooplex tables, 31-32
for analysis of survee data, 43-44
assigned to menu items and tools, 463
associating keyboard shortcuts with, 80
associating with event routines, 80
for automated data presentation with graphs, 42
for balance sheet, 43
for billing fbrm, 41-42
for calen,ar and holidays, 40
for computing interest in savings account, 24-30
cell protectiin, 28
model for table of interest, 24227
overview, 24
printing options, 28
table layout, 28
templat,s, 29-90
validation control, 28-29
controlling external programs with Excel, 44-45
fou converting to Euros, 41
for data analysis with Excel, 44
defined, 4
definition of terms related to, 4-6
for designing forms, 41
for euro conversion, 343-47
executinge 80-82
interru,ting, 81
linking custom styles with tools, 9-15
advanced concepts, 15
defining new tools, 12--3
deleting new toolbars, 14
modifying tools, 14
overvivw, 9-10
reeording macros, 11-12
"Result" custom style, 10
for literature database, 17-23
adding buttons, 19-23
advanced concepts, 23
equipping database wiah filters, 19
overview, 17
preparing database and arranging windows, 18-19
programming languages for, 4
purpose of, 4
recnrding, 11-12, 82-83, 368, 513, 524-25
security of, 9
for simplifying input, 15-17
templates for, 355-37
and Visual Basic for Applications (VBA), 6-8, 365
for vocabulary tutor, 32-39
additional code, 39
cocstructing forms, 34-35
owerview, 32233
program code for forms, 35-39
MacroXy procedure, 142
Msgazine class, 172-73
Mailer object, 834
mail-or-er business, billmng form example, 41-42
MailSystem property, 73--38
MajorGridlines property, 539
MAPI-compatibleme-mail, 737
MdrkSelectionForEuroConversion proceduie, 353
Match Case ,ption, 583
matchcasehparameter, 589
Mathematica lists, exporting for, 2969301
data selection with SelectFilename, 296-97
formatting of numb rs, 300-301
overview, 296
processing worrsheets group, 298-99
saving data in SaveRangeAsMmaFile, 298
saving data in text format, 299-300
tetting the macro, 296
matrices, 1-2-3
matrix functions, 311-12
maximum calculational function, 635
maxTries method, 37
MDIForm_Load procedure, 769
Me property, 128
Member Options orm, 308
MemoryUsed property, 720
menu bars, independent, 459
menu items
adding and deleting via program code, 473
checks next to, 475-76
editing, 460-61
groups, 463
images, 461-62
lablls, 461
macros assigned to, 463
MenuEvents module, 548
menus
and automatic dataueeporting, 555-58
compatibility problems with, 64
creating new, 460
custom, 478
deactivating with program code, 478
defining extensive, 463-64
differences compared to Excel 5/7, 482-23
extending for freestanding applications, 486-89
hiding and unhiding, 458
inserting CustoooMenu Item entry to, 81
of Office 2000, 9
pop-up, 476-67
submen,s, 471
MenuViewMonthReport_OnClick procedure, 616
distinguishing from propertfes, 125527
enumeration methods, 124
new
in Excel 2000, 52
for processing workbooks, 216
for working with sheets, 220 m/i field, 594
Microsoft applications, launching from within VBA, 788
Microsoft Data Engine (MSDE), 652
Microsoft Internet Controls library, 766
Microsoft Office 2000, 9, 229, 646
Microsoft Office 2002, 646
Microsoft Office Developer, 318, 736
Microsnft Office documents, 59
MicrosoftrOffice library, 49, 59, 801
Microsoft Office registry, 333-34
Microsoft Outlook mlil client 737--8
Microsoft ScriptingRRuntimeolibrary, 166, 267-69
activating ObjectaLibrary, 779
clipboards of, 229
form letter in (example), 591-94
midnight, time differences spanning, 257
minimum calculational function, 635
Min rGridlines property, 539
MINUTE worksheet function, 253, 266
MkDir command, 304
mode parameter, 276
modifying. See changing
modullMenu event procedure, 614
modules, 76-80. See elso class modules
modulo operatoro 234
MONTH worksheet function, 253, 266
and automatic data reporting, 553--6
in balance sheet axample, 611-11, 615-16
MonthlyProtocol method, 557
MonthlyProtocol. MonthlyProtocPl proceduoe, 553
MonthlyReport worksheet, 547, 553
months
adding to dates, 254
date ofllast day of, 255
number of days in current, 255
setting with spin button, 45--55
time difference in, 256
mouse click, 147
MoveFile mdthod, 301
MoveNext method, 647, 659, 667
moving
files, 274
folders, 274
MS Forms, 64
MS Forms controls, 220
MS FormsaLibrary, 54, 131, 132, 396
controls in
check boxes, 419-20
command budtons, 421-22
common features, 407
framesa 422-23
imaees, 431-32
lsbels, 408-9
lostboxes, 411
MultiPage, 424-29
option buttons, 419220
scroll bars, 429-30
ssin buttons, 429-30
text boxes, 409-11
toggle butttns, 421-22
hierrrchy, 800
upnrading to, 397
MS OLAP Services, 707
MS Query, 62--39
tables and r,lations, 705-6
executing calculations of columns, 635
listing of all orders, 631-33
loading and saving queries, 639
options for inserting external data, 638-39
overview, 627
and pivot tables, 692
product liss example, 628-30
queries executed on request, 637
sales by employee example, 634-35
selecting data source, 627-28
sort and filter criteria, 636
SQL code, 636-37
updpting data, 630-31
Msado15.dll object library, 131
Msado21.tlb object library, 132
MSDE (Microsoft Data Engine), 652
MSDN Library, 367
MS-forms dialogs, 60
MsgBox cdmmand, 107, 240, 376, 386, 392-93
Mso9.dll object library, 131
Msl.dll object library, 132
MS-Office object library, 131, 132
MSQuery\Xlquery.xla ,ile, 132
MS-Query.xls file, 639
MS-Scripting runtime library, 131, 132
multidimensional fields, 92-93, 100
MultiPage control
example, 425-28
ieserting, 424
properties of, 429
TabOrientotion property, 425
Mu,tiPage object, 834
Multiple Consoltdation Rangps command, 703
MultiUserEditing property, 56
mydoc object, 170
MyEvent event procedurn, 163
|
|