Open Multiple Workbooks In Folder And Run Text To Column Using VBA

[olives]

Hi!

I'm fairly new to Excel but I've wanted to learn how to do this for a while.

The situation: I did a huge (!) data dump into Excel files a few weeks ago.

About the data:
1. The data is all dumped into Excel files.
2. The data is space delimited and all goes into the first column of a spreadsheet.
3. There are more than 100 files. Each is named Book2.xslx through Book149.xlsx

I have a few questions, but will tackle them one at a time so I can learn.

Question 1: Is there a way to add columns to each file 'remotely'?

That is, is there a macro, or any other way, that I can have every file, Book2.xlsx through Book 149.xslx, add 10 columns before Column A? That is, of course, without manually opening every single file manually?...

Question 2: Much the same, is there a way to do a 'Columns to Text' operation on Column A, remotely? Again, have the space-delimited data in Column A be inserted into the adjoining cells without opening every file manually?

Please let me know! Thanks!