Авторизация
Поиск по указателям
McFedries P. — VBA for the 2007 Microsoft Office System
Обсудите книгу на научном форуме Нашли опечатку?
Название: 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.
Язык: Рубрика: Технология /Статус предметного указателя: Готов указатель с номерами страниц ed2k: ed2k stats Год издания: 2007Количество страниц: 406Добавлена в каталог: 30.12.2007Операции: Положить на полку |
Скопировать ссылку для форума | Скопировать ID
Предметный указатель
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
Реклама
|
|
О проекте