Schedule Table Style with VBA

[buzz]

Anyone use VBA in their Schedule Table Styles with any sucess?

I am trying to insert a block into a Formula Column using GetObject

See screenshot...

With this formula, what happens is when the schedule updates it closes the current drawing and opens TEST.dwg in a new drawing, then as soon as that drawing is opened, it crashes. So maybe there is something like:

GetObject("C:\\TEST.dwg", this.drawing) ??

-Buzz

[Ben Jones]

The schedules actually use vbscript which looks very similar but is different.

Take a look here - The Architect's Desktop blog - ADT Schedule Resources. David Koch is awesome at this and is actually a moderator over on the ACA forums.

As for using getobject, I have found that it is terribly slow since it is working out of process. We have tried it on a number of different occasions and every time it hits the users in production, we have to find another way because it bogs modification/schedule update to a stand-still.

I know this isn't the fish...but I am trying to hand you the net...and possibly point out a few holes.

Hope this helps.

[buzz]

Thanks for the reply Ben, I will go check it out...

-Buzz

[elmoleaf]

Ever have any luck with this? I could've sworn I came across how to do this in an ATP or something by David Koch, but of course cannot find it now.
I'm trying to add a column to a schedule table that checks a property, and if it matchs, will add a specific block.

This is what I've got so far in a formula as the source for a property.

Select Case "[SpaceType_BOMA]"
Case "Occupant Areas"
Set BlockRefObj = ThisDrawing.ModelSpace.InsertBlock(0#, "oa-color", 1#, 1#, 1#, 0)
Case Else
End Select

Of course, I don't want the block in model space, but in the schedule table, so I'm still fumbling with getting the right info to make this work.
Thanks.

[Ed Jobe]

Of course, I don't want the block in model space, but in the schedule table, so I'm still fumbling with getting the right info to make this work.
Thanks.

So, you're saying you want to INSERT the block in a cell of a table?

[elmoleaf]

In an ACA schedule table, not a regular table.

[Ed Jobe]

The type of table was not the question. Are you trying to INSERT (as your code shows) or merely schedule an existing block. Perhaps both, insert a block and then schedule it? Before you can figure out how to do something, you need to be clear on what to do.

[jwanstaett]

so you need the Graphic Property of block xx to display for Space type yyy

no need to program just set up

1. each space type sould have it oun style
2. add Style Property set Applies to spaces
3. add a graphic property to the spaces style propertyset
4. Attach the Propety set to space style yyy
5. Set Display to block xx
6. add the Graphic proerty to your Schudel
7. Done

[elmoleaf]

so you need the Graphic Property of block xx to display for Space type yyy

no need to program just set up

1. each space type sould have it oun style
2. add Style Property set Applies to spaces
3. add a graphic property to the spaces style propertyset
4. Attach the Propety set to space style yyy
5. Set Display to block xx
6. add the Graphic proerty to your Schudel
7. Done

Yes, this is what I'm trying to accomplish. I have a separate display theme with colors that I'd like to integrate directly into my area schedule.
I added the graphic property as above etc, but the block in my schedule doesn't match the original (see attached). I have a small green square that gets rescaled smaller and color changed to magenta.
I can't find any means to override the color and scale in my schedule style.
Perhaps rather than a block file I should use image file option for the graphic property? I'll give that a try and let you know. Thank you.

[elmoleaf]

Ok, I see I can override the cell format for a column in my schedule table style to control the block size.
I can control the layer for the block via a layer key. But that's a bit roundabout and requires adding custom layer keys to put my custom color blocks all on their own layers.

The option to use an image file instead of a block file allows the item to retain its original color. But this requires creating separate image files outside of the cad drawing, and the color quality doesn't match what is in the drawing.
I really don't understand why when I use a block that has hard-coded colors in it, the schedule table treats it like a block that's drawn on layer 0 (colors get transformed to match that of the table).

Guess I stick with two separate tables, rather than integrating them.
This is all being done in Autocad for Architecture 2010, by the way. Thank you.