Авторизация
Поиск по указателям
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
Предметный указатель
ConcatenateStrings procedure 157 concatenating strings 157 Concatenation operator (&) 56 Configuring macro security, macro security levels 302—304 Configuring macro security, overview 301 Configuring macro security, trusted locations 301—302 Connections (database), opening 191 Const statement 45 356 Constants, built-in constants 44 Constants, creating 45 Constants, definition of 28 44 Constants, listing 28—29 Constants, user-defined constants 45 352 Control structures, If...Then statement, And operator 95 Control structures, If...Then statement, block syntax 92 Control structures, If...Then statement, example 92—93 Control structures, If...Then statement, Or operator 95 Control structures, If...Then statement, single-line syntax 92 Control structures, If..Then...Else statement, example 93—94 Control structures, If..Then...Else statement, indenting for readability 94 Control structures, If..Then...Else statement, multiple If..Then...Else statements 95—96 Control structures, If..Then...Else statement, syntax 93 Control structures, indenting for readability 111 Control structures, loops, Do...Loop 105—106 Control structures, loops, exiting 110 Control structures, loops, For Each...Next 109 Control structures, loops, For...Next 106—108 Control structures, loops, overview 104—105 Control structures, Select Case statement, FutureValue4(), example 98 Control structures, Select Case statement, LetterGrade(), example 98—99 Control structures, Select Case statement, syntax 97 Control structures, Select Case statement, VBAColor(), example 99—101 Controlling order of precedence (operators) 58—60 controls, buttons 277 controls, check boxes 251 Controls, combo boxes 252 controls, command buttons 249 controls, copying 244—245 controls, deleting 245 controls, frames 243 250 controls, grouping 245 Controls, inserting on forms 242—243 controls, labels 249 controls, list boxes 252—253 Controls, multipage controls 257—258 controls, option buttons 250—251 Controls, overview 242 Controls, properties, common properties, list of 246—247 Controls, properties, setting 246 Controls, Ribbon controls, check boxes 281—282 Controls, Ribbon controls, combo boxes 288 Controls, Ribbon controls, common attributes 276—277 Controls, Ribbon controls, dialog box launchers 289 Controls, Ribbon controls, drop-down lists 284—285 Controls, Ribbon controls, galleries 285—287 Controls, Ribbon controls, getting and changing control values 295—297 Controls, Ribbon controls, initializing 290—293 Controls, Ribbon controls, menus 278—280 Controls, Ribbon controls, resetting 293—295 Controls, Ribbon controls, scrollbars 253 Controls, Ribbon controls, selecting 243 Controls, Ribbon controls, selection handles 243 Controls, Ribbon controls, sizing 244 Controls, Ribbon controls, spin buttons 253—254 Controls, Ribbon controls, split buttons 280—281 Controls, Ribbon controls, toggle buttons 282—283 controls, tab order 247—248 Controls, tab strips 254—257 Controls, tab strips, initializing 256 Controls, tab strips, modifying controls in 256—257 controls, text boxes 249—250 controls, toggle buttons 251 ControlSource property (controls) 246 ControlTipText property (controls) 247 conversion functions 362 Converting strings into objects 140—141 Copy command (Edit menu) 245 Copy method, MailItem object 222 Copy method, Worksheet object 152 CopyFromRecordset method 210 Copying controls 244—245 copying files 315 CopyTo method 217 cos function 61 365 Count property, Range object 163 Count property, Sentences object 134 Counting words 133 CountWords function 133 Create Digital Certificate dialog box 304—305 Create New Data Source dialog box 192 CreateItem method 225 CreateJugglingPresentation procedure 169—170 CreateObject function 366 CSng function 362 CStr function 64 362 CurDir function 310 363 CurDir$ function 363 Currency data type 37 CurrentRegion property (Range object) 163 Cursors, stepping to 343 CursorType property (Recordset object) 195 Custom dialog boxes see “Forms” Custom rules (Outlook) 223—224 Custom UI Editor 270 Customize Keyboard dialog box 9 Customizing Ribbon see “Ribbon customization” CVar function 362 CVDate function 362 CVErr function 362 Cycle property (forms) 239 DAO (Data Access Objects) 190 data sources, creating 191—192 Data Tips feature 347 data types, boolean 37 data types, byte 36 Data types, changing 39 Data types, consistency in expressions 54 Data types, Currency 37 Data types, data type prefixes 38 data types, Date 36 Data types, definition of 29 Data types, DefType keywords 39 data types, Double 37 data types, INTEGER 36 data types, long 37 data types, Object 36 data types, Single 37 Data types, specifying 36—38 data types, string 36 data types, user-defined data types 39—40 data types, Variant 37 databases see “Access databases” DataSeries method 163 Date data type 36 date expressions 68—70 Date function 69 362 Date statement 356 Date$ function 69 362 Date/time functions 69 362—363 DateAdd function 69 362 DateDiff function 69 362 DatePart function 69 362 DateSerial function 69 362 DateValue function 69 362 Day function 69 362 DayDeity function 103 DDB function 63 364 Debug menu commands, Add Watch 345 Debug menu commands, Clear All Breakpoints 342 Debug menu commands, Edit Watch 346 Debug menu commands, Quick Watch 347 Debug menu commands, Run To Cursor 343 Debug menu commands, Step Into 340 343 Debug menu commands, Step Out 343 Debug menu commands, Step Over 343 Debug menu commands, Toggle Breakpoint 341 Debugging procedures, break mode, entering 340—342 Debugging procedures, break mode, exiting 342 Debugging procedures, break mode, overview 339—340 Debugging procedures, breakpoints, setting 341 Debugging procedures, compile errors 338 Debugging procedures, data tips feature 347 Debugging procedures, debugging tips and techniques 350—352 Debugging procedures, Immediate window, executing statements in 350 Debugging procedures, Immediate window, overview 348 Debugging procedures, Immediate window, printing data in 348—349 Debugging procedures, Locals window 344 Debugging procedures, logic errors 339 Debugging procedures, overview 337—338 Debugging procedures, Quick Watch feature 347 Debugging procedures, runtime errors 338—339 Debugging procedures, stepping into procedures 343 Debugging procedures, stepping out of procedures 343 Debugging procedures, stepping over procedures 343 Debugging procedures, stepping to cursor 343 Debugging procedures, syntax errors 338 Debugging procedures, watch expressions 344—346 Declare statement 356 Declaring, arrays, dynamic arrays 41—43 Declaring, arrays, multidimensional arrays 44 Declaring, arrays, one-dimensional arrays 44 declaring, variables 33—35 Declaring, variables, explicit declarations 35—36 Declaring, variables, implicit declarations 35 Default drive, changing 315 Default folders, changing 315 Default folders, referencing 214 Default property (CommandButton object) 249 DefBool statement 356 DefByte statement 356 DefCur statement 356 DefDate statement 356 DefDbl statement 356 DefInt statement 356 DefLng statement 356 DefObj statement 356 DefSng statement 356 DefStr statement 356 DefType keywords 39 DefVar statement 356 Delete command (Edit menu) 245 Delete method, Attachment object 229 Delete method, MailItem object 222 Delete method, MAPIFolder object 217 Delete method, Range object 128—129 Delete method, Recordset object 207 Delete method, Worksheet object 152 DeleteAll procedure 143 DeleteFolder procedure 317—318 DeleteSetting statement 307 357 Deleting, application settings from Registry 307 deleting, controls 245 deleting, files 315—316 deleting, folders 316—318 deleting, records 207—208 Deleting, text (Word) 128—129 Deleting, watch expressions 346 DeletingARecord procedure 207 Description property (Err object) 330 Developer tab, displaying 16 Dialog box launchers (Ribbon), creating 289 Dialog boxes see “Forms” Dialog boxes, Add Procedure 20 dialog boxes, Add Watch 345 Dialog boxes, Create Digital Certificate 304—305 dialog boxes, Create New Data Source 192 Dialog boxes, Customize Keyboard 9 dialog boxes, displaying 83—87 dialog boxes, Edit Watch 346 dialog boxes, Export File 300 dialog boxes, Import File 300 Dialog boxes, input boxes 50—51 dialog boxes, Insert Function 26—27 dialog boxes, Macro 8—9 21—22 Dialog boxes, Macro Options 11 Dialog boxes, Macros 8—9 Dialog boxes, message boxes, creating 45—46 Dialog boxes, message boxes, message styles 46—48 Dialog boxes, message boxes, return values 48—49 Dialog boxes, Microsoft Office Security Options 302 Dialog boxes, Modify Button 12 dialog boxes, ODBC Microsoft Access Setup 192 dialog boxes, Quick Watch 347 dialog boxes, Record Macro 5 7 Dialog boxes, Select Certificate 305 dialog boxes, Select Database 192 dialog boxes, Tab Order 247 Dialog boxes, Trust Center 302—303 DialogBoxLauncher element (XML) 289 Dialogs property (Application object) 83—87 Digital Signature command (Tools menu) 305 Digital signatures 304—305 Dim statement 33—34 357 Dir function 310—312 363 Dir$ function 363 directories see “Folders” Disabling error traps 330 Display method 86 222 Displaying, Developer tab 16 Displaying, dialog boxes 83—87 displaying, forms 258 Displaying, status bar messages 82 DisplayName property (Attachment object) 229 DisplaySentenceLengths procedure 134—135 Divide function 326—327 Dividends 55 DivideNumbers procedure 331—332 division operator (/) 55 divisors 55 dlLaunchInsertHyperlink Dialog_OnAction procedure 289 Do...Loop statement 105—106 357 DocTooLong function 102 Document object 73 115 Document object, Close method 121 Document object, Range method 125 Document object, Save method 119 Document object, SaveAs method 120 Documents (Word), ActiveDocument object 116 Documents (Word), backing up 122—124 Documents (Word), closing, Close method 121 Documents (Word), creating 118 Documents (Word), Document object 115 Documents (Word), Documents object 115 Documents (Word), hiding 319 Documents (Word), macro-enabled, documents/templates, creating 265—267 Documents (Word), opening with Open method 116 Documents (Word), opening with RecentFiles object 116—117 Documents (Word), Paragraph object 136—138 Documents (Word), Range object 125 Documents (Word), Range object, Bold property 126 Documents (Word), Range object, Case property 126 Documents (Word), Range object, Delete method 128—129 Documents (Word), Range object, deleting text 128—129 Documents (Word), Range object, Font property 126 Documents (Word), Range object, formatting text 126 Documents (Word), Range object, InsertAfter method 127 Documents (Word), Range object, InsertBefore method 127 Documents (Word), Range object, inserting text 127—128 Documents (Word), Range object, InsertParagraph method 127 Documents (Word), Range object, InsertParagraphAfter method 127
Реклама
|
|
О проекте