topic Re: Exporting multiple tables to Excel in VBA Forum

Exporting multiple tables to Excel

CHtCAD — Tue, 01 Dec 2009 20:55:59 GMT

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.

Re: Exporting multiple tables to Excel

Hallex — Wed, 02 Dec 2009 11:03:00 GMT

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

~'J'~

Re: Exporting multiple tables to Excel

Hallex — Wed, 02 Dec 2009 12:53:49 GMT

Just for example

~'J'~

Re: Exporting multiple tables to Excel

CHtCAD — Wed, 02 Dec 2009 21:54:17 GMT

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

Re: Exporting multiple tables to Excel

Hallex — Wed, 02 Dec 2009 22:14:48 GMT

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

Re: Exporting multiple tables to Excel

CHtCAD — Wed, 02 Dec 2009 22:25:14 GMT

~'J'~,

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

Regards

WillieR

Re: Exporting multiple tables to Excel

Hallex — Wed, 02 Dec 2009 23:45:21 GMT

Use it in Acad
See you tomorrow

~'J'~

Re: Exporting multiple tables to Excel

Hallex — Thu, 03 Dec 2009 07:42:31 GMT

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

~'J'~

Re: Exporting multiple tables to Excel

CHtCAD — Thu, 03 Dec 2009 22:35:18 GMT

~'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.

Re: Exporting multiple tables to Excel

Hallex — Fri, 04 Dec 2009 09:44:58 GMT

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'~

Re: Exporting multiple tables to Excel

Hallex — Fri, 04 Dec 2009 12:00:06 GMT

I had added tab reorder you need

~'J'~