Macro to delimit and compile multiple files to one sheet:

All,

This is my first post on here. I've searched for quite a while to see if there is existing information on here to help me and while there's some, I can't seem to get it to work exactly. I have multiple files I'm downloading daily into the following location: \\10.6.1.129\exports\LUNLEV

All files contain the same column data, come out as a comma delimited file, but have varying rows of information. I tried to attach them to this post but it's considered an invalid file type because it's a download directly from our ERP software. The files are comma delimited though and open fine with excel, you just have to run the delimit program when you open it (see attached images): 1.JPG 2.JPG 3.JPG 4.JPG

I'd like to be able to run a macro that delimits the data and compiles it into one workbook. Is that possible?

I have pretty much the very same situation. Have a set of files that contain date extracted from our point of sale that I consolidate into one workbook The number of files varies but they are all in the same location and I use a command line prompt to copy all the files into one and then open it in Excel. All the files need to be in the same location, then open a command line prompt and change to the directory where the files are located. Then enter the following command prompt in order to copy all files into one (I assume that all of the files have a .csv extension, but it can be any and it will work): copy *.csv combined.csv.

The combined.csv can be any name, it is just the one I choose to use. Hope this helps a little.

Thanks Canuck, I'm still stuck on how to get the files delimited to begin with. The data is comma delimited but the file is not a .csv it's actually a .file. The macro I'm looking for will open all the .files in a location, run the delimiter tool, then combine all the data in one sheet. Right now, I can do the macro recorder to get the code to open and delimit the data but not combine it.

Wanted to post the properties of the types of files we're working with, we open them in Excel but they don't come out of our ERP software as a common Excel file: 5.JPG

The files in question aren't excel files, and the filter on these forums wouldn't let me attach them because it didn't recognize the structure. That's why I posted the images to show the "type" of files I was dealing with. I really don't have an Excel sheet to post, the only code I have is the macro recording to open and delimit one of the files but I need to be able to open/delimit/and combine all the files in the target location:

Sub Macro1()
'
' Macro1 Macro
'

'
    ChDir "\\10.6.1.129\exports\LUNLEV"
    Workbooks.OpenText Filename:="\\10.6.1.129\exports\LUNLEV\ARNO", Origin:= _
        437, StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
        ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, Comma:=True, _
        Space:=False, Other:=False, FieldInfo:=Array(Array(1, 1), Array(2, 1), Array( _
        3, 1), Array(4, 1), Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1), Array(9, 1), Array(10 _
        , 1), Array(11, 1), Array(12, 1)), TrailingMinusNumbers:=True
End Sub