Visual Basic Customization

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

Exporting multiple tables to Excel

579 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 (579 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 (579 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 (579 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 (579 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 (579 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 (579 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 (579 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 (579 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 (579 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

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community