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?