Àâòîðèçàöèÿ
Ïîèñê ïî óêàçàòåëÿì
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
Ïðåäìåòíûé óêàçàòåëü
Objects, Range (Excel), returning with Cells method 154 Objects, Range (Excel), returning with Columns method 156 Objects, Range (Excel), returning with Offset method 157—158 Objects, Range (Excel), returning with Range method 153—154 Objects, Range (Excel), returning with Rows method 155—156 Objects, Range (Excel), selecting 158—161 Objects, Range (Word), Bold property 126 Objects, Range (Word), Case property 126 Objects, Range (Word), Delete method 128—129 Objects, Range (Word), deleting text 128—129 Objects, Range (Word), Font property 126 Objects, Range (Word), formatting text 126 Objects, Range (Word), InsertAfter method 127 Objects, Range (Word), InsertBefore method 127 Objects, Range (Word), inserting text 127—128 Objects, Range (Word), InsertParagraph method 127 Objects, Range (Word), InsertParagraphAfter method 127 Objects, Range (Word), InsertParagraphBefore method 127 Objects, Range (Word), InsertParagraphsAnd Text procedure 127—128 Objects, Range (Word), Italic property 126 Objects, Range (Word), reading and changing range text 126 Objects, Range (Word), returning with Range method 125 Objects, Range (Word), returning with Range property 125 objects, RecentFiles 73 116—117 Objects, Recipients 226 Objects, Recordset, accessing recordset data 198—199 Objects, Recordset, adding records 205—206 Objects, Recordset, AddNew method 205—206 Objects, Recordset, BOF property 200 Objects, Recordset, Delete method 207 Objects, Recordset, deleting records 207—208 Objects, Recordset, editing records 203—205 Objects, Recordset, EOF property 200 objects, Recordset, Fields property 198 Objects, Recordset, Find method 202 Objects, Recordset, finding records 202—203 Objects, Recordset, GetRows method 208 Objects, Recordset, Move method 200 Objects, Recordset, MoveFirst method 200 Objects, Recordset, MoveLast method 200 Objects, Recordset, MoveNext method 200 Objects, Recordset, MovePrevious method 200 Objects, Recordset, navigating records 199—201 Objects, Recordset, Open method 193—195 Objects, Recordset, opening with Open method 194—196 Objects, Recordset, opening with SELECT statement 196—198 Objects, Recordset, opening with tables 193—194 Objects, Recordset, overview 192—193 Objects, Recordset, Update method 204 objects, Scrollbar 253 Objects, Selection, Collapse method 132 Objects, Selection, collapsing selection 132 Objects, Selection, creating 129 Objects, Selection, extending selection 131—132 Objects, Selection, MoveEnd method 130 Objects, Selection, MoveStart method 130 Objects, Selection, moving insertion point 130 Objects, Selection, overview 129 Objects, Selection, Type property 129 Objects, Sentences 133—135 Objects, Shape, adding to slides 175—178 Objects, Shape, methods 176—178 181—182 Objects, Shape, properties 178—180 Objects, Shape, specifying 174—175 Objects, Slide, adding to presentations 171 Objects, Slide, methods 171 174 Objects, Slide, properties 172—173 Objects, Slide, specifying 170—171 objects, SlideShowSettings 187 objects, SlideShowTransitions 186 Objects, SpinButton 253—254 Objects, TabStrip 254—257 Objects, TabStrip, initializing 256 Objects, TabStrip, modifying controls in 256—257 objects, Textbox 249—250 Objects, ThisDocument 116 objects, ThisWorkbook 146 Objects, ToggleButton 251 objects, Window 88 Objects, Words 132—133 Objects, Workbook, closing workbooks 150 Objects, Workbook, creating workbooks 147 Objects, Workbook, opening workbooks 146—147 Objects, Workbook, saving workbooks 148—149 Objects, Workbook, specifying number of worksheets 147—148 Objects, Workbooks 146 Objects, Worksheet, creating worksheets 151 Objects, Worksheet, methods 152—153 Objects, Worksheet, properties 151—152 Objects, Worksheet, specifying 150—151 Oct function 61 365 Oct$ function 61 365 ODBC Microsoft Access Setup dialog box 192 Office 2007 Ribbon see “Ribbon customization” Offset method 157—158 On Error GoTo statement 325 On Error Resume Next statement 324 On Error statement 358 On...GoSub, On...GoTo statement 358 onAction attribute (controls) 276 one-dimensional arrays 44 OnKey method 142—143 OnRepeat method 145—146 OnTime method 144 OnUndo method 145—146 Open method, Documents collection 116 Open method, Presentations collection 166 Open method, properties 195 Open method, Recordset object 193—196 Open method, Workbooks collection 146—147 Open statement 358 Opening, database connections 191 Opening, Excel workbooks 146—147 Opening, modules 18—19 Opening, PowerPoint presentations 166 Opening, recordsets 192—193 Opening, recordsets with Open method 194—196 Opening, recordsets with SELECT statement 196—198 Opening, recordsets with tables 193—194 opening, windows 88 Opening, Word documents with Open method 116 Opening, Word documents with RecentFiles object 116—117 operands 54 operators, AND 95 operators, arithmetic operators 55 operators, assignment (=) 54 Operators, comparison operators 56—57 80 operators, concatenation 56 operators, definition of 54 Operators, logical operators, And 67 Operators, logical operators, Not 67 Operators, logical operators, Or 67 Operators, logical operators, table of 57 Operators, logical operators, Xor 67 operators, order of precedence 57—58 Operators, order of precedence, controlling 58—60 Operators, order of precedence, table of 58 Optimizing procedures, avoiding data selection 319 Optimizing procedures, avoiding recalculation 319 Optimizing procedures, hiding documents 319 Optimizing procedures, loops 320—321 Optimizing procedures, turning off screen updating 319 Option Base 0|1 statement 358 option buttons 250—251 Option Compare Text|Binary statement 358 Option Explicit statement 351 358 Option Private statement 358 OptionButton object 250—251 Options object 73 OR operator 95 Order of precedence (operators) 57—58 Order of precedence (operators), controlling 58—60 Order of precedence (operators), table of 58 Outgoing messages, handling (Outlook) 219—220 Outlook, attachments, adding to messages 230—231 Outlook, attachments, Attachment objects 229 Outlook, attachments, removing from forwarded messages 229—230 Outlook, custom rules 223—224 Outlook, folders, AddItem event 218—219 Outlook, folders, custom rules 223—224 Outlook, folders, listing all folders 214—215 Outlook, folders, methods 217 Outlook, folders, prompting users for 216—217 Outlook, folders, referencing default folders 214 Outlook, folders, spam 224—225 Outlook, incoming message handling 217 Outlook, logging off 233—234 Outlook, logging on 232 Outlook, MailItem object, methods 221—223 Outlook, MailItem object, properties 220—221 Outlook, messages, creating 225 Outlook, messages, forwarding 225 Outlook, messages, replying to 225 Outlook, messages, sending 226—227 Outlook, messages, specifying message recipients 226 Outlook, messages, supplementing reminders with email messages 227—228 Outlook, NameSpace object 213 Outlook, NameSpace object, Folders property 214 Outlook, NameSpace object, Logoff method 233—234 Outlook, NameSpace object, Logon method 232 Outlook, NameSpace object, PickFolder method 216—217 Outlook, outgoing message handling 219—220 Outlook, overview 213 Outlook, referencing from other applications 231 Overflow errors 330 Paragraph object 136—138 Parameter Info feature (IntelliSense) 29—30 Parameters, displaying information about 29—30 Partition function 367 PasswordChar property (TextBox object) 250 Path property (Presentation object) 167 pausing procedures 141 Pausing procedures, breakpoints, setting 341 Pausing procedures, entering break mode at beginning of procedure 340 Pausing procedures, entering break mode from error dialog boxes 340 Pausing procedures, entering break mode with Esc key 341 Pausing procedures, entering break mode with Stop statement 342 Pausing procedures, exiting break mode 342 Pausing procedures, overview 339—340 PerformCalculations procedure 42 period (.) 40 Personal Macro Workbook 7 PickFolder method 216—217 PickUp method 182 Picture properties (forms) 241 PictureAlignment property (forms) 241 PictureSizeMode property (forms) 241 PictureTiling property (forms) 241 plus sign (+) 47 55 Pmt function 29 62—63 364 Position properties (forms) 241 PowerPoint presentations 165 PowerPoint presentations, creating 166 PowerPoint presentations, Juggling presentation 168 PowerPoint presentations, Juggling presentation, AddJugglingSlides procedure 173—174 PowerPoint presentations, Juggling presentation, CreateJuggling Presentation procedure 169—170 PowerPoint presentations, Juggling presentation, Main procedure 169 PowerPoint presentations, Juggling presentation, RunJugglingSlideShow procedure 187—188 PowerPoint presentations, Juggling presentation, SetUpJugglingSlides procedure 183—185 PowerPoint presentations, Juggling presentation, SetUpStartPage procedure 180—181 PowerPoint presentations, opening 166 PowerPoint presentations, Presentation object, methods 167—168 PowerPoint presentations, Presentation object, properties 166—167 PowerPoint presentations, Presentation object, SlideShowSettings property 187 PowerPoint presentations, Presentation object, specifying 165—166 PowerPoint presentations, Presentations collection 166 PowerPoint presentations, shapes, adding to slides 175—178 PowerPoint presentations, shapes, methods 176—178 181—182 PowerPoint presentations, shapes, properties 178—180 PowerPoint presentations, shapes, specifying 174—175 PowerPoint presentations, slide shows, running 187—188 PowerPoint presentations, slide shows, settings 187 PowerPoint presentations, slide shows, transitions 186 PowerPoint presentations, slides, creating 171 PowerPoint presentations, slides, inserting from files 172 PowerPoint presentations, slides, methods 174 PowerPoint presentations, slides, properties 172—173 PowerPoint presentations, slides, specifying 170—171 PPmt function 63 365 Precedence (operators) 57—58 Precedence (operators), controlling 58—60 Precedence (operators), table of 58 Prefixes, data type 38 Presentation object, methods 167—168 Presentation object, properties 166—167 Presentation object, SlideShowSettings property 187 Presentation object, specifying 165—166 presentations see “PowerPoint presentations” Presentations collection 166 Presentations object 165 Print method 348—349 print statement 358 Printing data in Immediate window 348—349 PrintOut method 167—168 Private statement 358 Procedure command (Insert menu) 20 Procedures see “Macros” Procedures, AddingARecord 205—206 Procedures, AddJugglingSlides 173—174 Procedures, Application_ItemSend 219 Procedures, Application_Quit 218 Procedures, Application_Reminder 227—228 Procedures, Application_Startup 218 Procedures, assigning keyboard, shortcuts to 142—143 Procedures, BackUpTbDrive 328—329 Procedures, BigNumbers 105—106 Procedures, BoldAndItalic 145 Procedures, btnChooseAnotherStyle_OnAction 287 Procedures, btnCloseWindow_GetEnabled 297 Procedures, btnCloseWindow_OnAction 296 Procedures, btnPromptToSaveChanges_OnAction 279 Procedures, btnRefreshList_OnAction 295—297 procedures, ButtonTest 48 Procedures, ButtonTest2 49 Procedures, cbWindows_GetItemCount 292—293 Procedures, cbWindows_GetItemID 292 Procedures, cbWindows_GetItemLabel 293 Procedures, cbWindows_OnChange 296—297 Procedures, chkToggleProofingErrors_OnAction 282 Procedures, CloseAllOpenDocuments 121—122 Procedures, ColorTester 101 Procedures, ConcatenateStrings 157 Procedures, CreateJuggling Presentation 169—170 Procedures, debugging, break mode 339—342 Procedures, debugging, breakpoints 341 Procedures, debugging, compile errors 338 Procedures, debugging, data tips feature 347 Procedures, debugging, debugging tips and techniques 350—352 Procedures, debugging, Immediate window 348—350 Procedures, debugging, Locals window 344 Procedures, debugging, logic errors 339 Procedures, debugging, overview 337—338 Procedures, debugging, Quick Watch feature 347 Procedures, debugging, runtime errors 338—339 Procedures, debugging, stepping into procedures 343 Procedures, debugging, stepping out of procedures 343 Procedures, debugging, stepping over procedures 343 Procedures, debugging, stepping to cursor 343 Procedures, debugging, syntax errors 338 Procedures, debugging, watch expressions 344—346
Ðåêëàìà
|
|
Î ïðîåêòå