I need to vertically concatenate around 100 Excel files (xls) -- using a program called "Merge Excel Files."
That program assumes all files are structured the same, same column headers extending across in each file.
I must double-check that, though.
Assume 100 xls files in a single folder. I'd like to find a way to copy the first row -- the column headers -- of every xls file over into, say, a text file. Then in a text editor (with word wrap off) I can easily peruse down making sure all column headers are as they should be -- each column in the text file will have only one particular label.
One possible solution would be to use Skwire's ClipTrap. Load each of the 100 xls files one at a time, highlight the first row, copy. But this would take some time.
Hoping someone can come up with an easier way.