Excel 2007 : Load text files into new columns of spreadsheet

**scytheslash** · 05-19-2012, 05:07 AM

I checked out a similar thread which answers some of this question
http://www.excelforum.com/excel-prog...ets-macro.html

and this blogpost which does it without code (but adds data continuously to the same column):
http://blogs.office.com/b/microsoft-...hout-code.aspx

But i was wondering, is it possible to format this code, such that i can get all the text files in new columns and NOT in new sheets? And also is it possible to, say... give a column gap after every 32 files? I have loads of .txt files with no delimiters, so it's difficult to get the data into new columns, by simple formatting. I just want each new file to start in a new column, (and they all have only one row of data), and after 32 such columns there has to be an additional column left empty, and the next 32 files loaded.

Thanks, in advance!

**JBeaucaire** · 05-19-2012, 04:43 PM

'TXTs TO COLUMNS
Here's a macro for importing all the txt files in a folder into separate columns of a single sheet. The filename each dataset comes from is placed at the top of each column.

TXTs to Columns

In the macro, to add the blank column in every 33rd column, change this:

Please Login or Register  to view this content.

...to this:

Please Login or Register  to view this content.

**scytheslash** · 05-19-2012, 05:31 PM

Thank you, SO, SO much Jerry

The past 2 days have been real fun, i got to tweak around with excel a lot, and i didn't even know I could DO this stuff in Excel!

Just one thing, what's the

Please Login or Register  to view this content.

do? I checked and it seems it has something to do with indicating the platform on which you're working?

Thanks again, this really helps me with my work