{"course":{"productid":24606,"modality":1,"active":true,"language":"en","title":"VBA Programming with Office 2019","productcode":"O19VBA","vendorcode":"FL","vendorname":"Fast Lane","fullproductcode":"FL-O19VBA","courseware":{"has_ekit":false,"has_printkit":true,"language":"de"},"url":"https:\/\/portal.flane.de\/course\/training-o19vba","contents":"<ul>\n<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>","outline":"<h5> 1 Before you start<\/h5>\n<h5> 2 Office programmieren<\/h5><ul>\n<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>\n<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>\n<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>\n<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>\n<h5> 6 Shared VBA elements<\/h5><ul>\n<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>\n<h5> 7 Programming the Office applications<\/h5><ul>\n<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>\n<h5> 8 Communication between office applications<\/h5><ul>\n<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>\n<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>\n<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>\n<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>\n<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>\n<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>\n<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>\n<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>","comments":"<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>","summary":"<p>With the book &quot;VBA Programming - Integrated Solutions with Office 2019&quot; you will learn the most important programming techniques and the object models up to the development of your own integrated solutions in all Office applications. This compact VBA Office training book is ideal for use in training courses and for self-study. Benefit from numerous tips, the commented code examples and the exercises at the end of the chapters.<\/p>\n<ul>\n<li>The VBA development environment and language elements<\/li><li>Object-oriented programming with VBA<\/li><li>Shared VBA elements<\/li><li>Programming of Office applications<\/li><li>Communication between Office applications<\/li><li>Use custom dialogs<\/li><li>Database access in Office applications<\/li><li>Integrated solutions with Office 2019 applications<\/li><\/ul><p>\nTailored to the learning topics in &quot;VBA Programming - Integrated Solutions with Office 2019&quot;, BuchPlus gives you a comprehensive digital media package with sample, practice, and results files, quick reviews, knowledge tests, supplemental learning content, and a glossary.<\/p>","contents_plain":"- 1 Before you start\n- 2 Office programmieren\n- 3 The VBA development environment\n- 4 The language elements of VBA\n- 5 Object-oriented programming with VBA\n- 6 Shared VBA elements\n- 7 Programming the Office applications\n- 8 Communication between office applications\n- 9 Using Custom Dialogs\n- 10 Database access in Office applications\n- 11 Integrated solutions with Word\n- 12I ntegrated solutions with Excel\n- 13 Integrated solutions with Access\n- 14 Integrated solutions with PowerPoint\n- 15 Integrated solutions with Outlook","outline_plain":"1 Before you start\n\n\n 2 Office programmieren\n\n\n- 2.1 Areas of application of VBA\n- 2.2 Integrated solutions\n- 2.3 A simple example of an integrated solution\n- 2.4 Adding macros to the toolbar for access\n 3 The VBA development environment\n\n\n- 3.1 Using the VBA development environment\n- 3.2 Components of the development environment\n- 3.3 The Project Explorer\n- 3.4 The properties window\n- 3.5 Using the Code Window\n- 3.6 Input helpers for Visual Basic instructions\n- 3.7 Automatic work at end of instruction\n- 3.8 Working with procedures\n- 3.9 Working with the Direct Window\n- 3.10 The local window\n- 3.11 Exercises\n 4 The language elements of VBA\n\n\n- 4.1 Use modules\n- 4.2 Programming with procedures\n- 4.3 Sub-Procedures\n- 4.4 Property procedures\n- 4.5 Function procedures\n- 4.6 Use variables\n- 4.7 Using constants\n- 4.8 VBA data types\n- 4.9 Operatoren\n- 4.10 Controlling program flow with control structures\n- 4.11 Exercise\n 5 Object-oriented programming with VBA\n\n\n- 5.1 What are objects\n- 5.2 The object hierarchies (object models)\n- 5.3 Properties and methods\n- 5.4 Object variables\n- 5.5 Listings\n- 5.6 Using the object catalog\n- 5.7 Exercise\n\n 6 Shared VBA elements\n\n\n- 6.1 VBA elements for Office applications\n- 6.2 Programming application windows\n- 6.3 Search files\n- 6.4 Dialog window for file and folder selection\n- 6.5 Input dialogs and message windows\n- 6.6 Exercise\n\n 7 Programming the Office applications\n\n\n- 7.1 The Word Object Model\n- 7.2 Working with documents\n- 7.3 Accessing document content\n- 7.4 The Excel object model\n- 7.5 Working with workbooks and spreadsheets\n- 7.6 Accessing cells and cell ranges\n- 7.7 The Access Object Model\n- 7.8 Working with Access databases\n- 7.9 Accessing controls in forms and reports\n- 7.10 The PowerPoint object model\n- 7.11 Working with presentations and slides\n- 7.12 Accessing the slide content\n- 7.13 The Outlook Object Model\n- 7.14 Accessing folders\n- 7.15 Accessing elements\n- 7.16 Exercises\n\n 8 Communication between office applications\n\n\n- 8.1 Integrated Office Automation\n- 8.2 Technical basics\n- 8.3 Creating a reference to an object library\n- 8.4 Declaring object variables for automation\n- 8.5 Creating object instances\n- 8.6 Close object and release working memory\n- 8.7 Suppressing Automation Object Messages\n- 8.8 Exercise\n 9 Using Custom Dialogs\n\n\n- 9.1 Communication with the user\n- 9.2 Creating UserForm dialogs\n- 9.3 Using and programming UserForm dialogs\n- 9.4 Programming controls\n- 9.5 Exercise\n 10 Database access in Office applications\n\n\n- 10.1 Object models for accessing databases\n- 10.2 Database access with ADO\n- 10.3 Connecting to a data source\n- 10.4 Selecting and opening a record group\n- 10.5 Reading out data records\n- 10.6 Access to data fields\n- 10.7 Add and edit records\n- 10.8 Database access with DAO\n- 10.9 Exercise\n 11 Integrated solutions with Word\n\n\n- 11.1 Opportunities for integrated solutions\n- 11.2 Using Excel's chart function\n- 11.3 Transferring addresses from Access\n- 11.4 Exercise\n 12 Integrated solutions with Excel\n\n\n- 12.1 Opportunities for integrated solutions\n- 12.2 Using the print function of Word\n- 12.3 Daten aus Outlook und Access importieren\n- 12.4 Exercise\n 13 Integrated solutions with Access\n\n\n- 13.1 Opportunities for integrated solutions\n- 13.2 Document management database\n- 13.3 Reading documents into the database\n- 13.4 Search for documents\n- 13.5 Preview function for Word documents\n- 13.6 Preview function for Excel documents\n- 13.7 Archiving documents in the database\n- 13.8 Delete list of found documents\n- 13.9 Closing a hidden Word or Excel application\n- 13.10 Manage documents\n- 13.11 Open documents\n- 13.12 Exercise\n 14 Integrated solutions with PowerPoint\n\n\n- 14.1 Opportunities for integrated solutions\n- 14.2 The presentation creation\n- 14.3 Editing the title slide\n- 14.4 Creating a text slide with Word support\n- 14.5 Creating a chart slide with Excel support\n- 14.6 Search function for Excel workbooks\n- 14.7 Exercises\n 15 Integrated solutions with Outlook\n\n\n- 15.1 Opportunities for integrated solutions\n- 15.2 Creating notes in Word\n- 15.3 Sending serial e-mails with Word and Outlook\n- 15.4 Exercises","comments_plain":"This text was automatically translated. Please click here to read the original German version.","summary_plain":"With the book \"VBA Programming - Integrated Solutions with Office 2019\" you will learn the most important programming techniques and the object models up to the development of your own integrated solutions in all Office applications. This compact VBA Office training book is ideal for use in training courses and for self-study. Benefit from numerous tips, the commented code examples and the exercises at the end of the chapters.\n\n\n- The VBA development environment and language elements\n- Object-oriented programming with VBA\n- Shared VBA elements\n- Programming of Office applications\n- Communication between Office applications\n- Use custom dialogs\n- Database access in Office applications\n- Integrated solutions with Office 2019 applications\n\nTailored to the learning topics in \"VBA Programming - Integrated Solutions with Office 2019\", BuchPlus gives you a comprehensive digital media package with sample, practice, and results files, quick reviews, knowledge tests, supplemental learning content, and a glossary.","skill_level":"Beginner","version":"1.0","duration":{"unit":"d","value":2,"formatted":"2 days"},"pricelist":{"List Price":{"DE":{"country":"DE","currency":"EUR","taxrate":19,"price":1190},"SE":{"country":"SE","currency":"EUR","taxrate":25,"price":1190},"IL":{"country":"IL","currency":"ILS","taxrate":17,"price":4130},"CH":{"country":"CH","currency":"CHF","taxrate":8.1,"price":1680}}},"lastchanged":"2026-02-04T12:37:32+01:00","parenturl":"https:\/\/portal.flane.de\/ibb\/en\/json-courses","nexturl_course_schedule":"https:\/\/portal.flane.de\/ibb\/en\/json-course-schedule\/24606","source_lang":"en","source":"https:\/\/portal.flane.de\/ibb\/en\/json-course\/training-o19vba"}}