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

[olives]

All of these can be done. And though one could manipulate data in an Excel workbook without 'opening' the file, I'm sure you are just wanting to automate the process, and avoid having to manually open each file and make the changes..

Absolutely. You're right!

[Y]our request looks more like a project than a need for guidance. You'd be better off offering an amount as reward for getting the work done.

I just edited the first post because I do want to learn how to do these things myself... One at a time... Maybe because I'm broke, but also because like to play around with this stuff! So I'll take any help anyone can offer. Thanks!