Tool for automatically generating and laying out an entity relationship diagram?

I’ve seen a lot of tools which can reverse engineer an ERD from an existing database, but I haven’t been able to find one which is capable of automatically laying out the diagram in a reasonable way. Most of them just plop all the entities down on top of each other and call it a day. Some make an attempt at organizing the entities, but they don’t do a very good job of it.

Importing CSV files into Excel using a macro

I 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 delimiter, and paste into the cells directly below where I originally put the date.