O19VBAFLFast LaneFL-O19VBA1.0<ul> <li>1 Before you start</li><li>2 Office programmieren</li><li>3 The VBA development environment</li><li>4 The language elements of VBA</li><li>5 Object-oriented programming with VBA</li><li>6 Shared VBA elements</li><li>7 Programming the Office applications</li><li>8 Communication between office applications</li><li>9 Using Custom Dialogs</li><li>10 Database access in Office applications</li><li>11 Integrated solutions with Word</li><li>12I ntegrated solutions with Excel</li><li>13 Integrated solutions with Access</li><li>14 Integrated solutions with PowerPoint</li><li>15 Integrated solutions with Outlook</li></ul><h5> 1 Before you start</h5> <h5> 2 Office programmieren</h5><ul> <li>2.1 Areas of application of VBA</li><li>2.2 Integrated solutions</li><li>2.3 A simple example of an integrated solution</li><li>2.4 Adding macros to the toolbar for access</li></ul><h5> 3 The VBA development environment</h5><ul> <li>3.1 Using the VBA development environment</li><li>3.2 Components of the development environment</li><li>3.3 The Project Explorer</li><li>3.4 The properties window</li><li>3.5 Using the Code Window</li><li>3.6 Input helpers for Visual Basic instructions</li><li>3.7 Automatic work at end of instruction</li><li>3.8 Working with procedures</li><li>3.9 Working with the Direct Window</li><li>3.10 The local window</li><li>3.11 Exercises</li></ul><h5> 4 The language elements of VBA</h5><ul> <li>4.1 Use modules</li><li>4.2 Programming with procedures</li><li>4.3 Sub-Procedures</li><li>4.4 Property procedures</li><li>4.5 Function procedures</li><li>4.6 Use variables</li><li>4.7 Using constants</li><li>4.8 VBA data types</li><li>4.9 Operatoren</li><li>4.10 Controlling program flow with control structures</li><li>4.11 Exercise</li></ul><h5> 5 Object-oriented programming with VBA</h5><ul> <li>5.1 What are objects</li><li>5.2 The object hierarchies (object models)</li><li>5.3 Properties and methods</li><li>5.4 Object variables</li><li>5.5 Listings</li><li>5.6 Using the object catalog</li><li>5.7 Exercise</li></ul> <h5> 6 Shared VBA elements</h5><ul> <li>6.1 VBA elements for Office applications</li><li>6.2 Programming application windows</li><li>6.3 Search files</li><li>6.4 Dialog window for file and folder selection</li><li>6.5 Input dialogs and message windows</li><li>6.6 Exercise</li></ul> <h5> 7 Programming the Office applications</h5><ul> <li>7.1 The Word Object Model</li><li>7.2 Working with documents</li><li>7.3 Accessing document content</li><li>7.4 The Excel object model</li><li>7.5 Working with workbooks and spreadsheets</li><li>7.6 Accessing cells and cell ranges</li><li>7.7 The Access Object Model</li><li>7.8 Working with Access databases</li><li>7.9 Accessing controls in forms and reports</li><li>7.10 The PowerPoint object model</li><li>7.11 Working with presentations and slides</li><li>7.12 Accessing the slide content</li><li>7.13 The Outlook Object Model</li><li>7.14 Accessing folders</li><li>7.15 Accessing elements</li><li>7.16 Exercises</li></ul> <h5> 8 Communication between office applications</h5><ul> <li>8.1 Integrated Office Automation</li><li>8.2 Technical basics</li><li>8.3 Creating a reference to an object library</li><li>8.4 Declaring object variables for automation</li><li>8.5 Creating object instances</li><li>8.6 Close object and release working memory</li><li>8.7 Suppressing Automation Object Messages</li><li>8.8 Exercise</li></ul><h5> 9 Using Custom Dialogs</h5><ul> <li>9.1 Communication with the user</li><li>9.2 Creating UserForm dialogs</li><li>9.3 Using and programming UserForm dialogs</li><li>9.4 Programming controls</li><li>9.5 Exercise</li></ul><h5> 10 Database access in Office applications</h5><ul> <li>10.1 Object models for accessing databases</li><li>10.2 Database access with ADO</li><li>10.3 Connecting to a data source</li><li>10.4 Selecting and opening a record group</li><li>10.5 Reading out data records</li><li>10.6 Access to data fields</li><li>10.7 Add and edit records</li><li>10.8 Database access with DAO</li><li>10.9 Exercise</li></ul><h5> 11 Integrated solutions with Word</h5><ul> <li>11.1 Opportunities for integrated solutions</li><li>11.2 Using Excel&#039;s chart function</li><li>11.3 Transferring addresses from Access</li><li>11.4 Exercise</li></ul><h5> 12 Integrated solutions with Excel</h5><ul> <li>12.1 Opportunities for integrated solutions</li><li>12.2 Using the print function of Word</li><li>12.3 Daten aus Outlook und Access importieren</li><li>12.4 Exercise</li></ul><h5> 13 Integrated solutions with Access</h5><ul> <li>13.1 Opportunities for integrated solutions</li><li>13.2 Document management database</li><li>13.3 Reading documents into the database</li><li>13.4 Search for documents</li><li>13.5 Preview function for Word documents</li><li>13.6 Preview function for Excel documents</li><li>13.7 Archiving documents in the database</li><li>13.8 Delete list of found documents</li><li>13.9 Closing a hidden Word or Excel application</li><li>13.10 Manage documents</li><li>13.11 Open documents</li><li>13.12 Exercise</li></ul><h5> 14 Integrated solutions with PowerPoint</h5><ul> <li>14.1 Opportunities for integrated solutions</li><li>14.2 The presentation creation</li><li>14.3 Editing the title slide</li><li>14.4 Creating a text slide with Word support</li><li>14.5 Creating a chart slide with Excel support</li><li>14.6 Search function for Excel workbooks</li><li>14.7 Exercises</li></ul><h5> 15 Integrated solutions with Outlook</h5><ul> <li>15.1 Opportunities for integrated solutions</li><li>15.2 Creating notes in Word</li><li>15.3 Sending serial e-mails with Word and Outlook</li><li>15.4 Exercises</li></ul><p>This text was automatically translated. Please click <span class="cms-link-marked"><a class="fl-href-prod" href="/ibb/de/course/training-o19vba"><svg role="img" aria-hidden="true" focusable="false" data-nosnippet class="cms-linkmark"><use xlink:href="/css/img/icnset-linkmarks.svg#linkmark"></use></svg>here</a></span> to read the original German version.</p>- 1 Before you start - 2 Office programmieren - 3 The VBA development environment - 4 The language elements of VBA - 5 Object-oriented programming with VBA - 6 Shared VBA elements - 7 Programming the Office applications - 8 Communication between office applications - 9 Using Custom Dialogs - 10 Database access in Office applications - 11 Integrated solutions with Word - 12I ntegrated solutions with Excel - 13 Integrated solutions with Access - 14 Integrated solutions with PowerPoint - 15 Integrated solutions with Outlook1 Before you start 2 Office programmieren - 2.1 Areas of application of VBA - 2.2 Integrated solutions - 2.3 A simple example of an integrated solution - 2.4 Adding macros to the toolbar for access 3 The VBA development environment - 3.1 Using the VBA development environment - 3.2 Components of the development environment - 3.3 The Project Explorer - 3.4 The properties window - 3.5 Using the Code Window - 3.6 Input helpers for Visual Basic instructions - 3.7 Automatic work at end of instruction - 3.8 Working with procedures - 3.9 Working with the Direct Window - 3.10 The local window - 3.11 Exercises 4 The language elements of VBA - 4.1 Use modules - 4.2 Programming with procedures - 4.3 Sub-Procedures - 4.4 Property procedures - 4.5 Function procedures - 4.6 Use variables - 4.7 Using constants - 4.8 VBA data types - 4.9 Operatoren - 4.10 Controlling program flow with control structures - 4.11 Exercise 5 Object-oriented programming with VBA - 5.1 What are objects - 5.2 The object hierarchies (object models) - 5.3 Properties and methods - 5.4 Object variables - 5.5 Listings - 5.6 Using the object catalog - 5.7 Exercise 6 Shared VBA elements - 6.1 VBA elements for Office applications - 6.2 Programming application windows - 6.3 Search files - 6.4 Dialog window for file and folder selection - 6.5 Input dialogs and message windows - 6.6 Exercise 7 Programming the Office applications - 7.1 The Word Object Model - 7.2 Working with documents - 7.3 Accessing document content - 7.4 The Excel object model - 7.5 Working with workbooks and spreadsheets - 7.6 Accessing cells and cell ranges - 7.7 The Access Object Model - 7.8 Working with Access databases - 7.9 Accessing controls in forms and reports - 7.10 The PowerPoint object model - 7.11 Working with presentations and slides - 7.12 Accessing the slide content - 7.13 The Outlook Object Model - 7.14 Accessing folders - 7.15 Accessing elements - 7.16 Exercises 8 Communication between office applications - 8.1 Integrated Office Automation - 8.2 Technical basics - 8.3 Creating a reference to an object library - 8.4 Declaring object variables for automation - 8.5 Creating object instances - 8.6 Close object and release working memory - 8.7 Suppressing Automation Object Messages - 8.8 Exercise 9 Using Custom Dialogs - 9.1 Communication with the user - 9.2 Creating UserForm dialogs - 9.3 Using and programming UserForm dialogs - 9.4 Programming controls - 9.5 Exercise 10 Database access in Office applications - 10.1 Object models for accessing databases - 10.2 Database access with ADO - 10.3 Connecting to a data source - 10.4 Selecting and opening a record group - 10.5 Reading out data records - 10.6 Access to data fields - 10.7 Add and edit records - 10.8 Database access with DAO - 10.9 Exercise 11 Integrated solutions with Word - 11.1 Opportunities for integrated solutions - 11.2 Using Excel's chart function - 11.3 Transferring addresses from Access - 11.4 Exercise 12 Integrated solutions with Excel - 12.1 Opportunities for integrated solutions - 12.2 Using the print function of Word - 12.3 Daten aus Outlook und Access importieren - 12.4 Exercise 13 Integrated solutions with Access - 13.1 Opportunities for integrated solutions - 13.2 Document management database - 13.3 Reading documents into the database - 13.4 Search for documents - 13.5 Preview function for Word documents - 13.6 Preview function for Excel documents - 13.7 Archiving documents in the database - 13.8 Delete list of found documents - 13.9 Closing a hidden Word or Excel application - 13.10 Manage documents - 13.11 Open documents - 13.12 Exercise 14 Integrated solutions with PowerPoint - 14.1 Opportunities for integrated solutions - 14.2 The presentation creation - 14.3 Editing the title slide - 14.4 Creating a text slide with Word support - 14.5 Creating a chart slide with Excel support - 14.6 Search function for Excel workbooks - 14.7 Exercises 15 Integrated solutions with Outlook - 15.1 Opportunities for integrated solutions - 15.2 Creating notes in Word - 15.3 Sending serial e-mails with Word and Outlook - 15.4 ExercisesThis text was automatically translated. Please click here to read the original German version.2 days1190.001190.004130.001680.00