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 ...