Excel 2003 importing data from multiple .txt files

@ JBeaucaire ... i do not know where the 'Go' button is ... i have used the 'Additional Options / Manage Attachments' in the hope that this is what you want?
Two txt files have been imported into base.xls using Semicolon delimiter ...

Originally Posted by JBeaucaire

Before I spend any time on this, did you try to adapt the code offered above by SNB? I'm sure he'll be happy to explain/expand on it if you try it.

yes i have looked at that code ... it returns a syntax error - after commenting that line out it returns a path unknown error
it doesn't seem to be tailored to the question in any way ...
it would be good to get a solution with some comments etc so it can be modified to suit the actual need
so no, it this time that code doesn't do a great deal

Dim FR As Long, NR As Long

Works a treat thank you ... I just want to comment out a little more and it would be good if you could give more info about FR and NR ... what exactly do they mean?

also, you have txtFile = Dir but the only other pointer to Dir is outside the loop so I am not sure where it is getting changed values from - can you give a little info on that too please?

otherwise this seems to meet the need very well thank you !!
normally this would take me 6-8 hours to scramble together as i am more a formulae person so this is very helpful ... where do i send the bottle of wine?

Originally Posted by JBeaucaire

FR = First Row (to enter sheet names)
NR = Next Empty Row (at bottom of current data set)

The DIR() function was "started" at the top of the macro. The next time we use it it simply reapplies the earlier function and moves on to the next file that matches the filter.

Great ... that helps a lot. Now of course i need to tidy up the things not included in my specs (like shifting all a column to the right, and populating A:B as it runs through).

All good ... got your text too thanks

Originally Posted by JBeaucaire

The macro given will populate the data into columns C:I, and will fill in the sheet name in column B. The only thing left is the column A which you provided no specifications for. I saw 2000 was in that column in the sample, but no absolute indication where that comes from.


If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

I have 'Solved' this question as it does finish the request. And yes, I do know how it works - I left some specs out because I wanted the framework with which I could tailor the rest of the process since some of the data is confidential etc ... with your explanations of terms etc I am perfectly happy with the outcome, and very grateful for your time.
Thanks again!