Главная    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
Предметный указатель
A1 cells, selecting on all worksheets      158—159
abs function      61 365
Accelerator property (controls)      246 249
Access databases, connections, opening      191
Access databases, data sources, creating      191—192
Access databases, object models, choosing      190—191
Access databases, overview      189
Access databases, records, adding      205—206
Access databases, records, deleting      207—208
Access databases, records, editing      203—205
Access databases, records, finding      202—203
Access databases, records, navigating      199—201
Access databases, recordsets, accessing recordset data      198—199
Access databases, recordsets, exporting from Access to Excel      210—212
Access databases, recordsets, opening with Open method      194—196
Access databases, recordsets, opening with SELECT statement      196—198
Access databases, recordsets, opening with tables      193—194
Access databases, recordsets, overview      192—193
Access databases, references, creating      190—191
Access databases, retrieving data into Excel, individual field values      208
Access databases, retrieving data into Excel, recordsets      210—212
Access databases, retrieving data into Excel, rows      208—210
Accessing recordset data      198—199
Activate method      88 152
activating Windows      88
Active items      74
ActiveConnection property (Recordset object)      195
ActiveDocument object      116
ActivePresentation object      166
ActiveWindow object      88
ActiveWorkbook object      146
ActiveX Data Objects (ADO)      189—190
Add method, Documents collection      118
Add method, Names collection      162
Add method, Presentations collection      166
Add method, Recipients object      226
Add method, Slides collection      171
Add method, Workbooks collection      147
Add method, Worksheets collection      151
Add Procedure dialog box      20
Add Watch command (Debug menu)      345
Add Watch dialog box      345
AddComment method      176
AddConnector method      176
AddCurve method      176
AddingARecord procedure      205—206
AddItem method      253
addition operator (+)      55
AddJugglingSlides procedure      173—174
AddLabel method      176
AddLine method      176
AddMediaObject method      177
AddNew method      205—206
AddPicture method      177
AddPolyline method      177
Address property, Range object      163
Address property, Recipient object      226
AddShape method      177
AddTextEffect method      177
AddTitle method      178
ADO (ActiveX Data Objects)      189—190
AdvanceMode property (SlideShowSettings object)      187
AdvanceOnClick property (SlideShowTransition object)      186
AdvanceOnTime property (SlideShowTransition object)      186
AdvanceTime property (SlideShowTransition object)      186
ampersand (&)      56
and operator      95
AnimationSettings property (Shape object)      178
AppActivate statement      356
Appearance properties (forms)      239
application object      73 81 139
Application object, methods, Calculate      140
Application object, methods, CalculateFull      140
Application object, methods, CheckSpelling      87
Application object, methods, CreateItem      225
Application object, methods, Evaluate      140—141
Application object, methods, OnKey      142—143
Application object, methods, OnRepeat      145—146
Application object, methods, OnTime      144
Application object, methods, OnUndo      145—146
Application object, methods, Wait      141
Application object, properties, Caption      82
Application object, properties, Dialogs      83—87
Application object, properties, Height      83
Application object, properties, Left      83
Application object, properties, ScreenUpdating      319
Application object, properties, StatusBar      82
Application object, properties, Top      83
Application object, properties, UsableHeight      83
Application object, properties, UsableWidth      83
Application object, properties, Width      83
Application object, properties, WindowState      83
Application object, properties, WorksheetFunction      139—140
Application settings, deleting from Registry      307
Application settings, reading from Registry      306—307
Application settings, reading section settings      309
Application settings, storing in Registry      305—306
Application window, properties      82—83
Application_ItemSend procedure      219
Application_Quit, procedure      218
Application_Reminder procedure      227—228
Application_Startup procedure      218
apply method      181
ApplyTemplate, method      167
arguments, named      76
arithmetic operators      55
Array function      366
Arrays, Array function      366
arrays, declaring      41
Arrays, definition of      40
arrays, dynamic arrays      41—43
Arrays, finding lower/upper bounds of      41—43
Arrays, multidimensional arrays      44
Arrays, one-dimensional arrays      44
AS keyword      38
ASC function      64 368
AscB function      368
AscW function      368
Assigning, objects to variables      79—80
Assigning, shortcut keys to Excel macros      10—11
Assigning, shortcut keys to Word macros      9—10
assignment operator (=)      54
Asterisk $(\ast)$      55
Atn function      61 365
Attachment object      229
Attachments (email), adding to messages      230—231
Attachments (email), Attachment objects      229
Attachments (email), removing from forwarded messages      229—230
Auto Syntax Check      351
AutoShapeType property (Shape object)      179
AutoSize property (controls)      246
BackColor property (forms)      239
Background property (Slide object)      172
Backing up Word documents      122—124
backslash (\)      55
BackStyle property (controls)      246
BackUpToDrive, procedure      328—329
BAS (Basic) file format      300
BCC property (MailItem object)      220
Beep statement      356
Behavior properties (forms)      239—240
BigNumbers procedure      105—106
Body property (MailItem object)      220
BodyFormat property (MailItem object)      220
BOF property (Recordset object)      200
Bold property (Range object)      126
BoldAndItalic procedure      145
Bookmarks, navigating recordsets with      201
BOOLEAN data type      37
BorderColor property (forms)      239
BorderStyle property (forms)      239
break mode, entering      340—342
Break mode, entering at beginning of procedure      340
Break mode, entering from error dialog boxes      340
Break mode, entering with Esc key      341
Break mode, entering with Stop statement      342
break mode, exiting      342
Break mode, overview      339—340
breakpoints, setting      341
btnChooseAnotherStyle_OnAction procedure      287
btnCloseWindow_GetEnabled procedure      297
btnCloseWindow_OnAction procedure      296
btnPromptToSave Changes_OnAction procedure      279
btnRefreshList_OnAction procedure      295—297
Bugs      see “Debugging procedures”
Buttons parameter (MsgBox function)      46—48
buttons, command buttons      249
buttons, creating      277
Buttons, option buttons      250—251
Buttons, split buttons      280—281
Buttons, toggle buttons      282—283
buttonTest procedure      48
ButtonTest2 procedure      49
Byte data type      36
Calculate method      140 152
CalculateAge function      70
CalculateFull method      140
Call statement      356
callbacks      267
CallByName function      366
Calling user-defined functions      26
Camel-style naming, convention      34
Cancel property (CommandButton object)      249
Caption property, Application object      82
Caption property, CommandButton object      249
Caption property, controls      247
Caption property, forms      239
Captions of title bars, changing      82
caret (^)      55
Case property (Range object)      126
CBool function      362
cbWindows_GetItemCount procedure      292—293
cbWindows_GetItemID procedure      292
cbWindows_GetItemLabel procedure      293
cbWindows_OnChange procedure      296—297
CByte function      362
CC property (MailItem object)      221
CCur function      362
CDate function      69 362
CDbl function      362
CDec function      362
Cells (Excel), returning      154
Cells (Excel), selecting, selecting A1 on all worksheets      158—159
Cells (Excel), selecting, selecting home cell on all worksheets      159—160
Cells (Excel), selecting, selecting named range that contains active cell      160—161
Cells method      154
Certified signing authorities      304
Changing, control values      295—297
Changing, data types      39
Changing, default drive      315
Changing, default folder      315
ChDir statement      315 356
ChDrive statement      315 356
Check boxes, checkBox element (XML)      281—282
Check boxes, CheckBox object      251
checking spelling      75 87
CheckSpelling method      75 87
chkToggleProofingErrors_OnAction procedure      282
Choose function      102—103 366
chr function      64 368
Chr$ function      64 368
ChrB function      368
ChrW function      368
CInt function      362
Clear All Breakpoints command (Debug menu)      342
Clear method, Err object      332
Clear method, ListBox object      253
CLng function      362
close method      76
Close method, Document object      121
Close method, MailItem object      222
Close method, Presentation object      167
Close method, Workbook object      150
Close statement      356
CloseAllOpenDocuments macro      121—122
closing all documents      121—122
Closing, Excel workbooks      150
Closing, Word documents      121—122
Code command (View menu)      248
Code continuation character (_)      66
Collapse method      132
Collapsing selection (Word)      132
collections      see “Objects”
Collections, Documents, Add method      118
Collections, Documents, Open method      116
Collections, elements      78
Collections, index values      78
Collections, Names      162
Collections, Presentations      166
Collections, Slides, Add method      171
Collections, Slides, InsertFromFile method      172
Collections, Workbooks, Add method      147
Collections, Workbooks, Open method      146—147
Collections, Worksheets      151
ColorTester procedure      101
Column property (Range object)      163
ColumnCount property (ListBox object)      252
ColumnHeads property (ListBox object)      252
Columns (Excel), returning      156
Columns method      156
Combo boxes, comboBox element (XML)      288
Combo boxes, ComboBox object      252
Command buttons      249
Command macros      see “Macros”
CommandButton object      249
Commands (menu), Debug menu, Add Watch      345
Commands (menu), Debug menu, Clear All Breakpoints      342
Commands (menu), Debug menu, Edit Watch      346
Commands (menu), Debug menu, Quick Watch      347
Commands (menu), Debug menu, Run To Cursor      343
Commands (menu), Debug menu, Step Into      340 343
Commands (menu), Debug menu, Step Out      343
Commands (menu), Debug menu, Step Over      343
Commands (menu), Debug menu, Toggle Breakpoint      341
Commands (menu), Edit menu, Complete Word      30
Commands (menu), Edit menu, Copy      245
Commands (menu), Edit menu, Delete      245
Commands (menu), Edit menu, List Constants      28
Commands (menu), Edit menu, List Properties/Methods      28
Commands (menu), Edit menu, Parameter Info      29
Commands (menu), Edit menu, Select All      243
Commands (menu), File menu, Export File      300
Commands (menu), File menu, Import File      300
Commands (menu), File menu, Remove      301
Commands (menu), Format menu, Group      245
Commands (menu), Format menu, Ungroup      245
Commands (menu), Formulas menu, Insert Function      26
Commands (menu), Insert menu, Procedure      20
Commands (menu), Macros menu, Record Macro      5 7
Commands (menu), Macros menu, Stop Recording      7—8
Commands (menu), Tools menu, Digital Signature      305
Commands (menu), View menu, Code      248
Commands (menu), View menu, Immediate Window      348
Commands (menu), View menu, Tab Order      247
Commands (menu), View menu, Watch Window      344
Comments, commenting out statements      351
Comments, definition of      22
Comparison operators      56—57 80
compile errors      338
Complete Word feature (IntelliSense)      30
1 2 3 4 5 6 7 8 9 10 11
blank
Реклама
blank
blank
HR
@Mail.ru
       © Электронная библиотека попечительского совета мехмата МГУ, 2004-2020
Электронная библиотека мехмата МГУ | Valid HTML 4.01! | Valid CSS! О проекте