CHAPTER 13Excel power

In this chapter, you will:

  • List all files in a folder

  • Import data from a CSV file

  • Learn methods of splitting and merging data

  • Export data to an XML file

  • Create a log file

  • Learn favorite techniques of various VBA pros

Amajor secret of successful programmers is to never waste time writing the same code twice. They all have little bits—or even big bits—of code that they use over and over again. Another big secret is to never take 8 hours doing something that can be done in 10 minutes—which is what this book is about!

This chapter contains programs donated by several Excel power programmers. These are programs they have found useful and that they hope will help you, too. Not only can these programs save you time, but they ...

Get Microsoft Excel 2019 VBA and Macros, First Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.