Sign-In
Cart
VBA Automation for Excel 2019 Cookbook: Solutions to automate routine tasks and increase productivity with Excel and other MS Office applications
Paperback
ISBN13: 9781789610031
Publisher: Packt Pub
Published: Sep 18 2020
Pages: 364
Weight: 1.38
Height: 0.75 Width: 7.50 Depth: 9.25
Language: English
A comprehensive guide to gaining a 360-degree overview of the VBA programming language and learning how to build your own programs for automating routine tasks
Key Features
- Extend the capabilities of Excel and other Office applications with the help of Microsoft VBA
- Take your Excel programming skills to the next level by creating custom applications with dialogue boxes and the range object
- Automate repetitive and monotonous office work with VBA Excel programming
Book Description
Visual Basic for Applications (VBA) is a programming language developed by Microsoft to automate tasks in MS Office applications. This book will help you to focus on the essential aspects of your role by automating mundane tasks in Excel and other Office applications. With comprehensive coverage of VBA delivered in the form of practice problems and bite-sized recipes, this book will help you to hit the ground running.
Unlike most books that assume prior programming experience, this book starts with the fundamentals and gradually progresses to solving bigger problems.
You'll start by becoming familiar with VBA so that you can start recording macros right away. With this foundation in place, you'll advance to using the full capabilities of the language as you apply loops, functions, and custom dialog boxes to design your own automation programs. You'll also get to grips with embedded macros and other advanced tools to enhance productivity and explore topics relating to app performance and security. Throughout this VBA book, you'll cover multiple practice projects in Excel, Word, and PowerPoint while exploring tips and best practices to hone your skills.
By the end of this book, you'll have developed the skills you need to use VBA to create your own programs that control MS Office applications.
What you will learn
- Understand the VBA programming language's role in the context of the MS Office suite
- Discover various aspects of VBA programming such as its terminology, syntax, procedures, functions, and forms
- Investigate the elements, features, and characteristics of the VBA Editor to write and edit custom scripts
- Automate Excel sheets with the help of ranges
- Explore error handling and debugging techniques to catch bugs in your programs
- Create and use custom dialog boxes to collect data from users
- Customize and extend Office apps such as Excel, PowerPoint, and Word
Who this book is for
This book is for experienced Excel users, business analysts, finance professionals, and business users looking to boost their productivity by learning VBA programming to automate repetitive, tedious, or complex tasks. No prior programming experience is required to get started with this book.
Also in
Applications
R for Data Science: Import, Tidy, Transform, Visualize, and Model Data
Grolemund, Garrett
Wickham, Hadley
Paperback
Designing Machine Learning Systems: An Iterative Process for Production-Ready Applications
Huyen, Chip
Paperback
R for Data Science: Import, Tidy, Transform, Visualize, and Model Data
Grolemund, Garrett
Cetinkaya-Rundel, Mine
Wickham, Hadley
Paperback
Microsoft 365 Excel All-In-One for Dummies
Kusleika, Dick
Ringstrom, David H.
Alexander, Michael
Paperback
Cloud Finops: Collaborative, Real-Time Cloud Value Decision Making
Storment, J. R.
Fuller, Mike
Paperback
Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365)
Winston, Wayne
Paperback
Microsoft Copilot Studio Step by Step: Customizing Copilot and Creating Agents
Crosbie, Lisa
Paperback
The Insider You Built: How Organizations Stay in Control of Autonomous AI Agents
Stewart Gloster, Camille
Paperback
Ingeniería de Ia (Spanish Edition): Creación de Aplicaciones Con Modelos Fundacionales
Huyen, Chip
Paperback
An Introduction to Statistical Learning: With Applications in R
Witten, Daniela
Hastie, Trevor
James, Gareth
Paperback
Learning Generative AI Tools for Excel: Speed Up Your Everyday Tasks with Microsoft Excel, Copilot, Chatgpt, and Beyond
Duca, Angelica Lo
Paperback
Excel Formulas: Quickstudy Laminated Study Guide (Quickstudy Computer)
Jensen, Krista
Hales, John
Other
The AI Workweek: Cut Hours, Automate Busywork, and Focus on What Actually Matters
Gross, Ashley
Paperback
Learning Tableau 2025 - Sixth Edition: Leverage Tableau's newest features to revolutionize your data storytelling with AI-enhanced insights
Milligan, Joshua N.
Paperback
Soccer Analytics with Machine Learning: Learning Predictive Modeling Techniques with Sports Data
Shen, Weining
Joury, Ari
Gao, Haipeng
Paperback
Planning and Control Using Oracle Primavera P6 Versions 18 to 24 PPM Professional
Harris, Paul E.
Hanak, Jan
Paperback
Microsoft Power Bi Data Analyst Associate Study Guide: Prepare for the Pl-300 Exam and Use Power Bi Successfully
Turley, Paul
Paperback
Social Science Research Design and Statistics: A Practitioner's Guide to Research Methods and IBM SPSS Analysis
Baker, Jason D.
Ponton, Michael K.
Rovai, Alfred P.
Paperback
Planning and Control Using Oracle Primavera P6 Versions 8 to 21 PPM Professional
Harris, Paul E.
Paperback
Reimagining Collaboration: Slack, Microsoft Teams, Zoom, and the Post-COVID World of Work
Simon, Phil
Paperback
Planning and Control Using Oracle Primavera P6 Versions 18 to 23 PPM Professional
Harris, Paul E.
Paperback
Mastering QuickBooks 2026 - Seventh Edition: The complete guide to small business accounting with US QuickBooks Online
Shelton, Crystalynn
Paperback
The AI Agent Blueprint: A Practical Playbook for Building Agentic Artificial Intelligence: Launch Your First Agent in 30 Days
Daniels, Alexander J.
Paperback
Information Architecture: For the Web and Beyond
Arango, Jorge
Rosenfeld, Louis
Morville, Peter
Paperback
Python in Excel: Unlocking Powerful Data Analysis and Automation Solutions
Bastick, Liam
Newitt, Kathryn
Paperback
Master Your Data with Power Query in Excel and Power Bi: Leveraging Power Query to Get & Transform Your Task Flow
Escobar, Miguel
Puls, Ken
Paperback
Building Event-Driven Microservices: Leveraging Organizational Data at Scale
Bellemare, Adam
Paperback
Illustrated Microsoft(r) 365(r) & Office(r) Introductory, First Edition
Beskeen, David
Duffy, Jennifer
Wermers, Lynn
Paperback
The SaaS Email Marketing Playbook: Convert Leads, Increase Customer Retention, and Close More Recurring Revenue With Email
Garbugli, Étienne
Paperback
Software Profit Streams(TM): A Guide to Designing a Sustainably Profitable Business
Tanner, Jason
Hohmann, Luke
Paperback
Regression Modeling Strategies: With Applications to Linear Models, Logistic and Ordinal Regression, and Survival Analysis
Harrell Jr, Frank E.
Paperback
Data Visualization with Microsoft Power Bi: How to Design Savvy Dashboards
Zelensky, Maxim
Kolokolov, Alex
Paperback
AI for Gig Workers: Essential Strategies to Transform Your Freelance Career
Savage, Saiph
Savage, Liliana
Cerdeira, Pamela
Paperback
Analytics Engineering with Microsoft Fabric and Power Bi: The Definitive Guide for Building Enterprise-Grade Analytics Solutions
Watson, Shabnam
ILIC, Nikola
Paperback
Essential Math for AI: Next-Level Mathematics for Efficient and Successful AI Systems
Nelson, Hala
Paperback
Managing AI Projects: Drive Innovation and Successfully Navigate the Full AI Project Lifecycle
Runtasewee, Malini Jain
Sánchez, Adrián González
Paperback
Databricks Certified Data Engineer Associate Study Guide: In-Depth Guidance and Practice
Alhussein, Derar
Paperback
Python Machine Learning By Example - Fourth Edition: Unlock machine learning best practices with real-world use cases
Liu, Yuxi (Hayden)
Paperback
AI Can Make You Smarter: Practical Skills. Sharper Thinking. Business Value.
Kreitzberg, Charles B.
Paperback
Microsoft 365 Copilot Adoption: A Practical Guide for Business Leaders and Consultants
Smith, Mark
Smith, Megan
Paperback
Me, My Customer, and AI: The New Rules of Entrepreneurship
Werdelin, Henrik
Thorne, Nicholas
Hardcover
Power BI for Beginners: The 7-Day Method to Build Dashboards and Become a Data Strategist (Video Course Included)
Pierce, Callum
Pierce, Kora
Paperback
Microsoft Power Bi Visual Calculations: Simplifying Dax
Stikkelorum, Madzy
Lelijveld, Marc
Ter Heerdt, Jeroen
Paperback
Microsoft Excel in Easy Steps: Illustrated Using Excel in Microsoft 365
McGrath, Mike
Price, Michael
Paperback
The Developer's Playbook for Large Language Model Security: Building Secure AI Applications
Wilson, Steve
Paperback
Planning and Control Using Microsoft Project 365 and 2021: Including 2019, 2016 and 2013
Harris, Paul E.
Paperback
ML and Generative AI in the Data Lakehouse: Building and Deploying AI Applications at Scale
Haelen, Bennie
Paperback
Applied AI for Enterprise Java Development: Leveraging Generative Ai, Llms, and Machine Learning in the Java Enterprise
Eisele, Markus
Vinto, Natale
Bueno, Alex Soto
Paperback
Quickbooks Pro Desktop User Guide 2024: A Step-by-Step Handbook for Efficient Bookkeeping and Finance Management
Duncan, Michel M.
Paperback
Salesforce Certified Platform Administrator Study Guide: Launch and Elevate Your Salesforce Career
Wheeler, Mike
Paperback
Articulate Storyline 360: The Essentials and Beyond [2026 Edition]: A Hands-On, Project-Based Classroom in a Book for Building Engaging eLearning
Siegel, Kevin
Hadi, Kal
Paperback
Hexagonal Architecture Explained: How the Ports & Adapters architecture simplifies your life, and how to implement it, Updated 1st Ed.
Garrido de Paz, Juan Manuel
Cockburn, Alistair
Paperback
How AI Ate the World: A Brief History of Artificial Intelligence - And Its Long Future
Stokel-Walker, Chris
Paperback
Aprenda Visual Basic (Vba) Y Macros Para Excel: Más de 100 ejercicios resueltos, macros y juegos, para desarrollar tus habilidades de programación
Vidal Bosch, Josep Ramon
Paperback
High Performance Browser Networking: What Every Web Developer Should Know about Networking and Web Performance
Grigorik, Ilya
Paperback
Modern Data Analytics in Excel: Using Power Query, Power Pivot, and More for Enhanced Data Analytics
Mount, George
Paperback
Microsoft Excel VBA and Macros: Your Guide to Efficient Automation
Jelen, Bill
Syrstad, Tracy
Paperback
Boost Your Skills In Computer Basics for ESL Learners: (+ Online Simulations & Resources)
Wooden, Lois
Paperback
Numerical Python: Scientific Computing and Data Science Applications with Numpy, Scipy and Matplotlib
Johansson, Robert
Paperback
Machine Learning Design Patterns: Solutions to Common Challenges in Data Preparation, Model Building, and MLOps
Robinson, Sara
Munn, Michael
Lakshmanan, Valliappa
Paperback
Microsoft Office 365 Bible: Productivity Boost Edition. Skyrocket Efficiency with Office 365 Power Moves-Streamline Work, Master Shortcuts, and Impres
Tasker Publishing, Zen
Paperback
SAP Cloud Integration Cookbook: Advanced Cloud Integration with SAP Integration Suite
Reisinger, Thorsten
Urschick, Marc
Hardcover
The Big Book of Dashboards: Visualizing Your Data Using Real-World Business Scenarios
Wexler, Steve
Shaffer, Jeffrey
Cotgreave, Andy
Paperback
Dark Web: A Complete Guide to the Dark Web True Tales (The Addictive Input down able Gripping Crime Thriller of Mystery and Suspense)
Guerrero, Theodore
Paperback
Beyond Bullet Points: Using PowerPoint to Tell a Compelling Story That Gets Results
Atkinson, Cliff
Paperback
Learn Excel 2019 for Mac Expert Skills with The Smart Method: Tutorial teaching Advanced Techniques
Smart, Mike
Paperback