VBA for Autocad book - any suggestion?

[ODEY]

hi guys,

i'm aware that autocad will soon drop its support for VBA and will adapt VB.net instead. i have tried working w/ autolisp but i found it lacking and limited in some areas and besides i'm working with autocad 2009 & excel 2003 so i guess VBA is the right prog language to use to create routines that will link autocad and excel together. i don't have a background at all in visual basic and just wondering if there is any particular book you can suggest that is available in amazon.com, or an ebook that can be shared would be great.

tnx!

[10west]

"Using Visual Basic with AutoCAD"

by Andrew G. Roe
Autodesk Press

"VBA dor AutoCAD 2002", maybe others?
Jeffrey E. Clark
Prentice Hall

I recommend getting a couple good Visual basic core language books, which are ususally numerous at bookstores new and used, since many principles used to connect to Excel, are related to connecting to AutoCAD, or word.

Wrox publishing has good Excel VBA books, which always have a good VBprimer in the introductory sections

www.planet-source-code.com has some projects for download in VB and VBA with good sample projects, with full source and project files for perusal

The Cadence magazine, and I assume website has or had ongoing VB sections

autodesk.com is also a good resource for supports from Autodesk and others.

What helped me was actually building projects I needed and wanted to use in AutoCAD like a particular simple problem which you can expand from, and be motivated to absorb because it has a use you can apply WHILE developing and learning. I used VBA and also started connecting externally through the VB IDE, so now with .NET and other COM compliant languages you have many choices for controlling COM exposing apps from various platforms for development.