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.
