Reading files from a folder into excel spreadsheet
Posted on 2013-11-16
I am looking for help; with an excel script that
1. reads all files from a given folder (path can be hardcoded)
2. opens them as text and copies the contents into excel spreadsheet with 2 columns:
The resulting spreadsheet should have as many rows as there are files and should contain the contents of each file in the "FileContents" column.
Thank you, Experts!