Importing CSV files into Excel using a macro
- by B-Ballerl
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.