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: 279
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.
© Super User or respective owner