Visual Basic Customization

[#1]

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.

[#2]

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

~'J'~

[#3]

Just for example

~'J'~

[#4]

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

[#5]

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

[#6]

~'J'~,


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

Regards

WillieR

[#7]

Use it in Acad
See you tomorrow

~'J'~

[#8]

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

~'J'~

[#9]

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

[#10]

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