VBA
Discuss AutoCAD ActiveX and VBA (Visual Basic for Applications) questions here.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Exporting multiple tables to Excel

10 REPLIES 10
Reply
Message 1 of 11
CHtCAD
2533 Views, 10 Replies

Exporting multiple tables to Excel

Hi, We have drawings will multiple tables on then, they are generated with bills of material. (5 off per drawing). We are looking for a piece of scrips that can prompt to select the tables in one select and export direct to excel and put the tables on individual tabs. Can anyone help.

Regards Willie R.
10 REPLIES 10
Message 2 of 11
Hallex
in reply to: CHtCAD

Post an example drawing and I can start working something out.
Would be good to see the output Excel file too

~'J'~
_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Message 3 of 11
Hallex
in reply to: CHtCAD

Just for example

~'J'~
_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Message 4 of 11
CHtCAD
in reply to: CHtCAD

Hi ~'J'~,

I have attached a zip with a dwg and pdf of the dwg. The drawing is a spool fab drawing with tables on it, when you open the dwg you might not see the items through the viewport, not that it matters that much but if you want to see the objects I have attached a like to the object enabler on the web. Thanks for this and if you need any more info please let me now.

regards

Willie R.


http://www.map-software.com/index.php?option=com_content&view=article&id=9&Itemid=5
Message 5 of 11
Hallex
in reply to: CHtCAD

Ok, I need a time for this job
Did you tryed my example on the single drawing?
I need to know how it works on your end to move
further
Oops your drawing was created in the newer version than I have - I can't open it
Save it in A2008 version and post here again (just a drawing only)

~'J'~ Edited by: hallex on Dec 2, 2009 10:16 PM
_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Message 6 of 11
CHtCAD
in reply to: CHtCAD

~'J'~,


As requested. The script you attached to the earler thread, is that for use on acad or excel?

Regards

WillieR
Message 7 of 11
Hallex
in reply to: CHtCAD

Use it in Acad
See you tomorrow

~'J'~
_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Message 8 of 11
Hallex
in reply to: CHtCAD

Willie,
Let me know how it works
(Maybe need to change the References accordingly to your
Acad/Excel environments)

~'J'~
_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Message 9 of 11
CHtCAD
in reply to: CHtCAD

~'J'~

Your a star. Being a bit of a pain, would it be posable reverse the tabs in excel with ' Bought In Mechanical Schedule' being first through to ' Supports Schedule' last. Also would it be posable to have headings in the second row, i.e. Items Desctiption etc as black bold. Also you you mind looking at another bit of export I need.?

willie.
Message 10 of 11
Hallex
in reply to: CHtCAD

Never did it before, I mean tab reorder
Ok, I will try
About another import better yet to start
a new thread I think
There are too many smart guys here who
could be help you too 🙂

~'J'~
_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Message 11 of 11
Hallex
in reply to: CHtCAD

I had added tab reorder you need

~'J'~
_____________________________________
C6309D9E0751D165D0934D0621DFF27919

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report

”Boost