Van Niekerk VBA Automation for Excel 2019 Cookbook

Solutions to automate routine tasks and increase productivity with Excel and other MS Office applications
1. Auflage 2020
ISBN: 978-1-78961-633-0
Verlag: De Gruyter
Format: EPUB
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)

E-Book, Englisch, 362 Seiten

No detailed description available for "VBA Automation for Excel 2019 Cookbook".

Autoren/Hrsg.

Van Niekerk, Mike

Fachgebiete

• Mathematik | Informatik EDV | Informatik Business Application Tabellenkalkulation
• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Programmier- und Skriptsprachen
• Mathematik | Informatik EDV | Informatik Business Application Integrierte Softwarepakete

Inhaltsverzeichnis

Table of Contents - Getting Started with VBA
- Working with the VBA Editor
- The VBA Object Model
- Working with Procedures

- Next Level Recording

- VBA Language Elements
- Working with Ranges
- Using Functions

- Implementing Program Flow
- Implementing Automation
- Handling Errors
- Debugging
- Creating and Modifying Dialog Boxes
- Creating UserForms

- UserForm Controls
- Creating Custom Functions
- Creating Word Documents with Excel VBA
- Working with PowerPoint in Excel VBA

Über Autor(innen)

Van Niekerk Mike:

Mike Van Niekerk has consulted as an IT lecturer since 1995, mainly presenting project management and Microsoft Office end user application courses. With 39 years of applied experience in many industries, including language courses and the writing of manuals, he has acquired an exceptional ability to transfer knowledge. Being a Microsoft Office Specialist and Microsoft Certified Trainer, he is highly experienced in MS Word, Excel, PowerPoint, Access, MS Project, and VBA. He also works with, and trains on, Outlook, Publisher, and Visio. The training he has done includes all these applications on all levels, from beginner to advanced. He has written MS Office training manuals for several IT training companies in South Africa.