Главная    Ex Libris    Книги    Журналы    Статьи    Серии    Каталог    Wanted    Загрузка    ХудЛит    Справка    Поиск по индексам    Поиск    Форум   
blank
Авторизация

       
blank
Поиск по указателям

blank
blank
blank
Красота
blank
McFedries P. — VBA for the 2007 Microsoft Office System
McFedries P. — VBA for the 2007 Microsoft Office System



Обсудите книгу на научном форуме



Нашли опечатку?
Выделите ее мышкой и нажмите Ctrl+Enter


Название: VBA for the 2007 Microsoft Office System

Автор: McFedries P.

Аннотация:

VBA for the 2007 Microsoft® Office System shows you how to take full advantage of the 2007 Microsoft Office suite by automating routine Office tasks. No matter which Office application you’re using, there are some tasks you perform dozens of times, such as typing a section of text, running a series of menu commands, or formatting a document in a particular way.This book shows you how to accomplish the same tasks by incorporating them into a macro that you can run with just a few mouse clicks or keystrokes. This book shows you the basics of VBA programming from the ground up. Even if you’ve never programmed before, VBA for the 2007 Microsoft® Office System will have you up to speed with VBA in no time.You’ll learn how to write programs that control Word, Excel, PowerPoint, Access databases, and even Outlook email.You get dozens of example macros that not only illustrate the concepts in the book but also provide you with practical, business-oriented tools that you can use right away to improve your productivity.


Язык: en

Рубрика: Технология/

Статус предметного указателя: Готов указатель с номерами страниц

ed2k: ed2k stats

Год издания: 2007

Количество страниц: 406

Добавлена в каталог: 30.12.2007

Операции: Положить на полку | Скопировать ссылку для форума | Скопировать ID
blank
Предметный указатель
Messages (Outlook), supplementing reminders with email messages      227—228
METHODS      217
Methods, Activate      88 152
Methods, Add, Documents collection      118
Methods, Add, Names collection      162
Methods, Add, Presentations collection      166
Methods, Add, Recipients object      226
Methods, Add, Slides collection      171
Methods, Add, Workbooks collection      147
Methods, Add, Worksheets collection      151
Methods, AddComment      176
Methods, AddConnector      176
Methods, AddCurve      176
Methods, AddItem      253
Methods, AddLabel      176
Methods, AddLine      176
Methods, AddMediaObject      177
Methods, AddNew      205—206
Methods, AddPicture      177
Methods, AddPolyline      177
Methods, AddShape      177
Methods, AddTextEffect      177
Methods, AddTitle      178
methods, apply      181
Methods, ApplyTemplate      167
Methods, Calculate      140 152
Methods, CalculateFull      140
methods, Cells      154
Methods, CheckSpelling      75 87
Methods, Clear, Err object      332
Methods, Clear, ListBox object      253
Methods, Close      76
Methods, Close, Document object      121
Methods, Close, MailItem object      222
Methods, Close, Presentation object      167
Methods, Close, Workbook object      150
Methods, Collapse      132
Methods, Columns      156
Methods, Copy, MailItem object      222
Methods, Copy, Worksheet object      152
Methods, CopyFromRecordset      210
methods, CopyTo      217
Methods, CreateItem      225
Methods, DataSeries      163
Methods, Delete, Attachment object      229
Methods, Delete, MailItem object      222
Methods, Delete, MAPIFolder object      217
Methods, Delete, Range object      128—129
Methods, Delete, Recordset object      207
Methods, Delete, Worksheet object      152
Methods, Display      86 222
Methods, Duplicate      181
Methods, Evaluate      140—141
Methods, Execute      86—87
Methods, Find      202
Methods, Flip      182
Methods, Forward      225
Methods, GetDefaultFolder      214
Methods, GetRows      208
Methods, getSelectedItemIndex      291
Methods, IncrementLeft      182
Methods, IncrementRotation      182
Methods, IncrementTop      182
Methods, InsertAfter      127
Methods, InsertBefore      127
Methods, InsertFromFile      172
Methods, InsertParagraph      127
Methods, InsertParagraph Before      127
Methods, InsertParagraphAfter      127
Methods, Invalidate      294
Methods, InvalidateControl      294
Methods, listing      27—28
Methods, Logoff      233—234
Methods, Logon      232
Methods, Move, MailItem object      222
Methods, Move, Recordset object      200
Methods, Move, Worksheet object      152
Methods, MoveEnd      130
Methods, MoveFirst      200
Methods, MoveLast      200
methods, MoveNext      200
Methods, MovePrevious      200
Methods, MoveStart      130
Methods, MoveTo      217
Methods, multiple methods      80—81
Methods, named arguments      76
Methods, NewWindow      88
methods, Offset      157—158
Methods, OnKey      142—143
Methods, OnRepeat      145—146
Methods, OnTime      144
Methods, OnUndo      145—146
Methods, Open, Documents collection      116
Methods, Open, Presentations collection      166
Methods, Open, properties      195
Methods, Open, Recordset object      193—196
Methods, Open, Workbooks collection      146—147
Methods, overview      75—77
Methods, PickFolder      216—217
Methods, PickUp      182
methods, Print      348—349
Methods, PrintOut      167—168
Methods, Raise      333
methods, Range      125 153—154 171 175
Methods, RemoveItem      253
Methods, Reply      225
Methods, ReplyAll      225
Methods, Resize      163
Methods, Rows      155—156
methods, Run      187—188
Methods, Save, Document object      119
Methods, Save, Presentation object      168
Methods, SaveAs, Attachment object      229
Methods, SaveAs, Document object      120
Methods, SaveAs, Presentation object      168
Methods, Select      129 182
Methods, Show      85
Methods, Sort      75
Methods, syntax      75—76
Methods, Update      204
Methods, Wait      104 141
Microsoft Office Security Options dialog box      302
Microsoft Root Certificate Program      304
Mid function      64 369
Mid$ function      64 66 369
MidB function      369
MidB$ function      369
Min property (ScrollBar object)      253
Minute function      69 362
MIRR function      63 364
Misc properties (forms)      240—241
MkDir statement      316 358
mnuCloseDocument2_OnAction procedure      280
mod operator      55
Modify Button dialog box      12
Modular programming      104
modules, creating      17—18
modules, exporting      300
modules, importing      300
modules, opening      18—19
modules, removing      301
Modules, renaming      299—300
modulus operator      55
Monitoring procedure values, data tips feature      347
Monitoring procedure values, Locals window      344
Monitoring procedure values, Quick Watch feature      347
Monitoring procedure values, watch expressions      344—346
Month function      69 362
MonthName function      69 362
Move method, MailItem object      222
Move method, Recordset object      200
Move method, Worksheet object      152
MoveEnd method      130
MoveFirst method      200
MoveLast method      200
MoveNext method      200
MovePrevious method      200
MoveStart method      130
MoveTo method      217
MsgBox function      21 329 367
MsgBox function, Buttons parameter      46—48
MsgBox function, return values      48—49
MsgBox function, syntax      45—46
multidimensional arrays      44
MultiLine property (TextBox object)      250
MultiPage controls      257—258
MultiPage object      257—258
Multiple If...Then...Else statements      95—96
multiplication operator (*)      55
MultiSelect property (ListBox object)      252
MyRibbon.xml file, adding to document package      268—269
MyRibbon.xml file, creating      267—268
MyRibbon.xml file, renaming and opening      269
Name property, forms      240
Name property, Presentation object      167
Name property, Recipient object      226
Name property, Shape object      179
Name property, Slide object      173
Name property, Worksheet object      151
Name statement      316 358
named arguments      76
Named ranges containing active cell, selecting      160—161
Names collection      162
Names, Excel range names, defining      162
Names, macro names      20
Names, module names      299—300
names, range names      352
Names, variable names      34
NameSpace object,      213
NameSpace object, Folders property      214
NameSpace object, Logoff method      233—234
NameSpace object, Logon method      232
NameSpace object, PickFolder method      216—217
Navigating records      199—201
negation operator (-)      55
NewWindow method      88
NewWorkbookWithCustom Sheets procedure      148
Not equal operator (<>)      57
NOT operator      57
Now function      69 363
NPer function      62—63 364
NPV function      63 364
Number property (Err object)      330
Numbers, random numbers, generating      61—62
Numbers, serial numbers      68
numeric expressions, financial functions      62—63
numeric expressions, math functions      60—62
Numeric expressions, overview      60
Object Browser      84
Object data type      36
object hierarchy      73
Object models, choosing      190—191
Objects      see “Collections”
Objects, ActiveDocument      116
objects, ActivePresentation      166
Objects, ActiveWindow      88
objects, ActiveWorkbook      146
objects, ADO (ActiveX Data Objects)      189
objects, application      73 81 139
Objects, Application, Calculate method      140
Objects, Application, CalculateFull method      140
Objects, Application, Caption property      82
Objects, Application, CheckSpelling method      87
Objects, Application, CreateItem method      225
Objects, Application, Dialogs property      83—87
Objects, Application, Evaluate method      140—141
Objects, Application, Height property      83
Objects, Application, Left property      83
Objects, Application, OnKey method      142—143
Objects, Application, OnRepeat method      145—146
Objects, Application, OnTime method      144
Objects, Application, OnUndo method      145—146
Objects, Application, StatusBar property      82
Objects, Application, Top property      83
Objects, Application, UsableHeight property      83
Objects, Application, UsableWidth property      83
Objects, Application, Wait method      141
Objects, Application, Width property      83
Objects, Application, WindowState property      83
Objects, Application, WorksheetFunction property      139—140
objects, assigning to variables      79—80
Objects, Attachment      229
Objects, CheckBox      251
objects, ComboBox      252
objects, CommandButton      249
Objects, comparing with Is operator      80
Objects, converting strings into      140—141
objects, DAO (Data Access Objects)      190
Objects, definition of      71
objects, Document      73 115
Objects, Document, Close method      121
Objects, Document, Range method      125
Objects, Document, Save method      119
Objects, Document, SaveAs method      120
Objects, Documents      73 115
Objects, Err, methods      332—333
Objects, Err, overview      330
objects, Err, properties      330—332
Objects, events, definition of      77
Objects, events, event handlers      77—78
objects, frame      250
Objects, Label      249
objects, ListBox      252—253
objects, MailItem, methods      221—223
objects, MailItem, properties      220—221
Objects, MAPIFolder, listing      214—215
objects, MAPIFolder, methods      217
Objects, MAPIFolder, prompting users for      216—217
Objects, MAPIFolder, referencing      214
objects, methods      see “Specific methods”
Objects, methods, multiple methods      80—81
Objects, methods, named arguments      76
Objects, methods, overview      75—77
Objects, methods, syntax      75—76
Objects, MultiPage      257—258
objects, NameSpace      213
Objects, NameSpace, Folders property      214
Objects, NameSpace, Logoff method      233—234
Objects, NameSpace, Logon method      232
objects, NameSpace, PickFolder method      216—217
Objects, Object Browser      84
Objects, object hierarchy      73
Objects, OptionButton      250—251
Objects, Options      73
objects, overview      71—73
Objects, Paragraph      136—138
Objects, Presentation, methods      167—168
Objects, Presentation, properties      166—167
Objects, Presentation, SlideShowSettings property      187
Objects, Presentation, specifying      165—166
Objects, Presentations      165
Objects, properties, multiple properties      80—81
Objects, properties, overview      74
Objects, properties, referencing      73
Objects, properties, returning value of      75
Objects, properties, setting value of      75
Objects, Range (Excel), defining range names      162
Objects, Range (Excel), inserting data into ranges      162—163
Objects, Range (Excel), resizing ranges      163—164
Objects, Range (Excel), returning data about ranges      163
1 2 3 4 5 6 7 8 9 10 11
blank
Реклама
blank
blank
HR
@Mail.ru
       © Электронная библиотека попечительского совета мехмата МГУ, 2004-2024
Электронная библиотека мехмата МГУ | Valid HTML 4.01! | Valid CSS! О проекте