Insert Block from Excel using VBA

[Anonymous]

Hi everyone
I need help writting a vba code that able to read information from excel and then insert and fill out attribute data base on excel information.
For example, in excel, I have a colum call "ref no". under that I have ref no like 01, 02, 03...
I like this program to read this excel for ref no. Then it will search current CAD application for block with attribute ref no is 01. It it can't find one, it will insert one with the attribute fillout. If it finds one, will do nothing.
Anything will help, thank you very much

[Anonymous]

This is my specialization (to integrate Acad and Excel)
However I have to modify one of my existing macros.
Send me an e-mail if you would like to have this.
http://members.asiaco.com/tigrek

Dr. Tigrek

[Anonymous]

helloi sir
i want to insert an excel file already created ,to the autoCAD file.Is it possible and if yes then can any one please tell me the code for doing it through VBA

sumi

[Anonymous]

Hi Sumi,

If you look in the sample files provided with the program you will find
nearly everything you need.

--

Regards,


Laurie Comerford
www.cadapps.com.au

wrote in message news:5059790@discussion.autodesk.com...
helloi sir
i want to insert an excel file already created ,to the autoCAD file.Is it
possible and if yes then can any one please tell me the code for doing it
through VBA

sumi

[Anonymous]

thanks sir
sir that sample file is reading the attributes from the drawing file but i have a excel file and want to insert that complete file in the same format to autocad.
is this possible and please tell me how .
thanks & regards
sumi

[Anonymous]

http://discussion.autodesk.com/thread.jspa?threadID=449339

this is my modified macro to search for specific blocks and output them to an excel spreadsheet, it should be easy to modify it to suit your needs.
i'm having some strange issues with it, but you could try it anyway.