Importing CSV files into Excel using a macro

Posted by B-Ballerl on Super User See other posts from Super User or by B-Ballerl
Published on 2011-01-08T08:45:22Z Indexed on 2011/01/11 9:55 UTC
Read the original article Hit count: 253

Filed under:
|
|
|

I'm want to develop a macro where in my excel worksheet I type a date in a specific cell, and the macro will go into a folder containing text files. A database you could say. I want it to find the corresponding file name which is written as a date, put the data through a delimeter, and paste into the cells directly below where I orginally put the date.

I'm very new with Macro's so if you must answer try to be a little more simple than you might usually be.

Thanks In Advance if anyone can Help!!

Update

The folder will always be in the same place and the text files will all be formatted DD_MM_YYYY. And there cells below will always be empty

Some Pictures to Make what I'm asking, easier to figure out. View the Image in a new tab for better res.

Result Data Input Step 1 Data Input Step 2 Data Input Step 3

© Super User or respective owner

Related posts about excel

Related posts about database