I was wondering is there a way for excel VB to extract information from a
autocad drawing? Autocad can extract the block attributes into a csv file,
but I would like to do a one click kind of thing.

Thanks for your feed back.

You can open, read and extract data/text from a csv file with Excel VBA
I picked it up from J Walkenbach,s "Power Programming with VBA"
You can probably write a command line batch file to create the .csv with
Autocad
Your Excel process would be:
run command line batch file to create .csv
open the csv, read, extract relevant data, store data in spreadsheet
you will need to use the shell function between these 2 steps, see:
http://www.cpearson.com/excel/ShellAndWait.aspx
Hope this gives you a start


"Novice Lee" wrote:

> I was wondering is there a way for excel VB to extract information from a
> autocad drawing? Autocad can extract the block attributes into a csv file,
> but I would like to do a one click kind of thing.
>
> Thanks for your feed back.