Autocad Drawing to Excel Sheet.

[Anonymous]

Hello,

I have a code for export autocad drawing to excel sheet.I need some changes in that code.This Code work for partslist.I would like to chage code for input Index data into Excel Sheet same as Partlist.So I change the Points(x,y Position)but i can't able to input the data correctly.Herewith I enclosed Drawing and Excel for reference.

Thanks in advance,
Bharathi

[Anonymous]

Hi
I have not have enough time
to work with this project
I did just a slightly changing here

~'J'~

[Anonymous]

Hello Fatty,

Thanks For your reply and for made some changes.It will bit help for me.

Thanking you,
Bharathi

[Anonymous]

You are welcome
Cheers 🙂

~'J'~

[Anonymous]

Hello Fatty,

Thanks you so much...I Finish Index Export work... :). I have one doubt...if there is empty cell it didnt work, as you told already i put [ - ] symbol.If there is 200 hook up drawing, client have to check all drawing and put hyphen(-) symbol.Suppose, if the client mistakenly leave one cell blank export data will also wrong.so,with out using hyphen can we acheive this export data.Can you give me any suggestion to solve.


Thanks,
Bharathi Message was edited by: Bharathi

[Anonymous]

Yes, it is
If you have an empty cells it will not
work, because it's count string values only
To avoid this trouble you need to fill all of the
empty cells with any symbols, say with minus
sign: "-" or with another one
I can't to find another solution of this problem

~'J'~

[Anonymous]

Hai Fatty,

when we export data from autocad to excel, if acadtext is no problem.if in between the value is attribute, that value can not export to excel.i need to export both attribute and acdtext in same code.how we can acieve this.can you help me.

here with i attach autocad drawing for your reference.

thanks a lot,
bharthi

[Anonymous]

hai fatty,

First, I change all the attribute into text style and export to excel.It is working.Is there any other method.if means, can you tell me.

thanks a lot,
bharathi

[Anonymous]

I think you no need any program for that
Just type in command line EATTEXT and
follow prompts

Or try this project:
C:\Program Files\AutoCAD 2008\Sample\VBA\attext.dvb
(search for file in your ACAD folder)

~'J'~

[Anonymous]

Hai Fatty,

Thanks For your Help Fatty! 🙂

Thanks,
Bharathi