Files, Folders & CSV
Let your macros walk through folders, read and write text files, and swallow a hundred CSV exports into one sheet.
The first lesson is free — no account needed.
About this course
Let your macros walk through folders and handle files. You check paths and whether a file exists, loop through every file in a folder, use the FileSystemObject, read text files line by line, write text and CSV files, parse CSV properly, import many files into one sheet and let the user pick files with FileDialog.