Excel to AutoCAD and back

I have been asked to create a cross section of our product in AutoCAD based on user input to our sales Excel workbook. This should automatically generate a drawing for the sales staff to give to a prospective customer.

I am an old AutoCAD user and have been using Excel for quite a few years and written some code but this is just a bit of a large nut for me to crack.

Anyone have any good ideas where I could go for some good advice and examples of how to accomplish this task?

Thanks, Dennis, but were you pointing me to a URL? I may be missing something but I don't see a link. Am I supposed to?:no:

I just may be blind, deaf and dumb...

Thanks, Denis! But pretty much all that does is test the communication between the two programs and proves what I already knew that AutoCAD is faster at entity creation than Excel. But the problem for me is to get a better understanding of the code that I will need to write in order to accomplish our goal of automating AutoCAD with a changing list of paramaters from Excel. This task will primarily be performed at the sales level with people who are not CAD oriented.

I hoped to be able to find a site where someone has already accomplished this so that I could look at the code or at least get some idea as to where to start. I realize that the link you gave me provided a little of this but the energy there was focused on speed and time issues and not complex entities.

Thanks, again...