Importing multiple text files into one worksheet

Hi there,

I am looking to import many text files into one excel sheet. (Excel 2007)

The files are saved every hour and contain identical tab delimited columns. There are 10 columns and 4 rows in each file.

The filenames contain the date and timestamp. I would like to import this data into column A.

I am struggling with pieces of codes I have picked up from the web - and just can't seem to get each element working. I have exhausted every post I can find on the subject!

Any suggestions for code would be much appreciated.

Best,
Rob


Also posted on code cage - I had no idea these sites were linked - or this was an issue

http://www.thecodecage.com/forumz/mi...post1055001033

Hi gwatcheater,

Give this a whirl:

Please Login or Register  to view this content.

Oh - are they all in the same workbook - else we'll need to revise.

crosspost

http://www.thecodecage.com/forumz/mi...nto-excel.html

Originally Posted by xladept

Hi gwatcheater,

Give this a whirl:

Please Login or Register  to view this content.

Oh - are they all in the same workbook - else we'll need to revise.

Thanks for the code - not sure how this works? does this open and paste data from any text files?

this is what I currently have- but need to evolve:

Please Login or Register  to view this content.

When I run - I am prompted to open a file manually - once I select one - the import begins for all files - how can I avoid this manual step?

I would like to add the filename of each text file to column A if possible (as these contain date and time info)

If possible I would like to not import row 1 of each text file as it is a header


thanks
Rob



(re: Crosspost - I had no idea all the forums were linked accross different sites - apologies)

I believe that you could just use:

Please Login or Register  to view this content.

to populate any cell that you designated.