Chapter 13
Excel 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
Clean a report so you can analyze the data
Learn favorite techniques of various VBA pros
A major 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 ...
Get Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365) 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.
