VBA-Automation-for-Excel-2019-Cookbook

KO | EN

gitlite — search

#java #golang #nodejs #javascript #static-code-analysis #go #react #library #rust #build #python #css

VBA-Automation-for-Excel-2019-Cookbook

★ 50 Open GitHub ↗

VBA Automation for Excel 2019 Cookbook, published by Packt

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# VBA Automation for Excel 2019 Cookbook

This is the code repository for [VBA Automation for Excel 2019 Cookbook](https://www.packtpub.com/business-other/vba-automation-cookbook?utm_source=github&utm_medium=repository&utm_campaign=9781789610031), published by Packt.

**Solutions to automate routine tasks and increase productivity with Excel and other MS Office applications**

## What is this book about?
Visual Basic for Applications (VBA) is a programming language developed and owned by Microsoft to automate routine computing tasks in MS Office applications. This book provides comprehensive coverage of VBA automation using a variety of practice problems to help you automate daily tasks and extend the capabilities of Excel and other Office applications.

This book covers the following exciting features:
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 dialogue boxes to collect data from users
Customize and extend Office apps such as Excel, PowerPoint, and Word

If you feel this book is for you, get your [copy](https://www.amazon.com/dp/1789610036) today!

## Instructions and Navigations
All of the code is organized into folders. For example, Chapter02.

The code will look like the following:
```
Private Sub Workbook_BeforeClose(Cancel As Boolean)
    MsgBox "This file cannot be closed"
    Cancel = True
End Sub
```

**Following is what you need for this book:**
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.

With the following software and hardware list you can run all code files present in the book (Chapter 1-18).
### Software and Hardware List
| No | Software required | OS required |
| -------- | ------------------------------------ | ----------------------------------- |
| 1 | Excel 2019/365 | Windows |

We also provide a PDF file that has color images of the screenshots/diagrams used in this book. [Click here to download it](https://static.packt-cdn.com/downloads/9781789610031_ColorImages.pdf).

### Code in Action
Click on the following link to see the Code in Action: 
https://bit.ly/3jQRvVk

### Related products
* Learn Microsoft Office 2019 [[Packt]](https://www.packtpub.com/product/learn-microsoft-office-2019/9781839217258?utm_source=github&utm_medium=repository&utm_campaign=9781839217258) [[Amazon]](https://www.amazon.com/dp/1839217251)

* Learn Power Query [[Packt]](https://www.packtpub.com/product/learn-power-query/9781839219719?utm_source=github&utm_medium=repository&utm_campaign=9781839219719) [[Amazon]](https://www.amazon.com/dp/B08739LHNN)

## Get to Know the Author
**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.
### Download a free PDF

If you have already purchased a print or Kindle version of this book, you can get a DRM-free PDF version at no cost. Simply click on the link to claim your free PDF.
 <a href="https://packt.link/free-ebook/9781789610031">https://packt.link/free-ebook/9781789610031 </a>

VBA-Automation-for-Excel-2019-Cookbook

Explore Similar Repositories

Was this content helpful?

Recent Feedback

Download README