Visual Basic Customization

Visual Basic Customization

Reply
Contributor
CHtCAD
Posts: 12
Registered: ‎02-09-2009
Message 1 of 11 (627 Views)

Exporting multiple tables to Excel

627 Views, 10 Replies
12-01-2009 12:55 PM
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.
*Expert Elite*
Hallex
Posts: 1,569
Registered: ‎10-08-2008
Message 2 of 11 (627 Views)

Re: Exporting multiple tables to Excel

12-02-2009 03:03 AM 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
*Expert Elite*
Hallex
Posts: 1,569
Registered: ‎10-08-2008
Message 3 of 11 (627 Views)

Re: Exporting multiple tables to Excel

12-02-2009 04:53 AM in reply to: CHtCAD
Just for example

~'J'~
_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Contributor
CHtCAD
Posts: 12
Registered: ‎02-09-2009
Message 4 of 11 (627 Views)

Re: Exporting multiple tables to Excel

12-02-2009 01:54 PM 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
*Expert Elite*
Hallex
Posts: 1,569
Registered: ‎10-08-2008
Message 5 of 11 (627 Views)

Re: Exporting multiple tables to Excel

12-02-2009 02:14 PM 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
Contributor
CHtCAD
Posts: 12
Registered: ‎02-09-2009
Message 6 of 11 (627 Views)

Re: Exporting multiple tables to Excel

12-02-2009 02:25 PM 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
*Expert Elite*
Hallex
Posts: 1,569
Registered: ‎10-08-2008
Message 7 of 11 (627 Views)

Re: Exporting multiple tables to Excel

12-02-2009 03:45 PM in reply to: CHtCAD
Use it in Acad
See you tomorrow

~'J'~
_____________________________________
C6309D9E0751D165D0934D0621DFF27919
*Expert Elite*
Hallex
Posts: 1,569
Registered: ‎10-08-2008
Message 8 of 11 (627 Views)

Re: Exporting multiple tables to Excel

12-02-2009 11:42 PM 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
Contributor
CHtCAD
Posts: 12
Registered: ‎02-09-2009
Message 9 of 11 (627 Views)

Re: Exporting multiple tables to Excel

12-03-2009 02:35 PM 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.
*Expert Elite*
Hallex
Posts: 1,569
Registered: ‎10-08-2008
Message 10 of 11 (627 Views)

Re: Exporting multiple tables to Excel

12-04-2009 01:44 AM 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 :smileyhappy:

~'J'~
_____________________________________
C6309D9E0751D165D0934D0621DFF27919
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Are You Going To Be @ AU 2014? Feel free to drop by our AU topic post and share your plans, plug a class that you're teaching, or simply check out who else from the community might be in attendance. Ohh and don't forgot to stop by the Autodesk Help | Learn | Collaborate booths in the Exhibit Hall and meet our community team if you get a chance!