Recent content by mfleming

Another stupid question I have is how to I run the Program in Autocad? When I load the project it shows the parts where it actually goes throught the drawings/blocks (not sure what this is called) but I cant see the FORM WINDOW unless I use the TEST function inside the VBA Editor. Basically...

I tried Swamp but no reply. I have got it so I can change the visibily state. Just not sure what "values" I use to set the lookup. I keep getting Invalid input. dybprop(i).Value = "12" Under the watch window the type is Variant/String and for value it just says custom. I'm thinking it...

So from my original question, how do I update/change these values?

Error 13 Type Mismatch Debug.Print " Value---> " & lookuptbl(lCnt).Value

TCARPENTER1 I get error 13 Type Mismatch in Debug.Print "lookuptbl(" & lCnt & "): Show --> " & lookuptbl(lCnt).Show & _ " Property Name --> " & lookuptbl(lCnt).PropertyName & _ " Value --> " & lookuptbl(lCnt).Value

Nope chaninging lookuptbl = element.GetDynamicBlockProperties TO Set lookuptbl = element.GetDynamicBlockProperties gives me Run-Time error 13.. Type mismatch. It works ok if I leave OFF the Set. My New Code: Private Sub CommandButton4_Click() Dim element As Object Dim lookuptbl As...

Yes and No. This will change the width and height using their parameters BUT I want to add them the LookUP Paramater (which basically has a big list of widths and lengths in specific combinations (ie. 24"w X 48"h, 24"w X 32"h, 22"w X 48"h) I'm wanting to use my excel list to be updated into...

TCARPENTER1 I believe I already use the GetDyn.... code except when I try to put the () at the end I get an error. lookuptbl = elementBlock.GetDynamicBlockProperties lookuptbl GETS the info and it displays it as lookuptbl(0), lookuptbl(1) and so on. I tried changing the "show" value and I...

Hello. I'm working on an app that will take width & height values from an excel file and add them to the LOOKUP of my rectangle shape Dynamic Block. In the end I want to be able to update my Dynamic Blocks in the drawing with the NEW LOOKUP values to Stretch the Width & Height. My Dynamic...

I have almost fixed this. There is only one Flip that doesn't seem to be working. The Flip Door Swing. It works when I just flip the door swing but if I try and stretch the door opening after it is flipped it gets all messed up. Can anyone help me out I have no idea how to fix this?

Thanks I'll look into Pivot Tables. I tried the sumif function but I couldn't get a good way to cycle through all the data when its not in just two columns.

Hello. I'm combine unique names and add the quantities. I use data extraction in AutoCAD to excel and I get all my Parts and qtys. Column-A = Parts Name Column-B = Qty for Parts in Column A Column-C = Parts Name Column-D = Qty for Parts in Column C Column-E = Parts Name Column-F = Qty for...

Hello. I'm looking for a internal drain detail for comercial buildings. Mainly how th drain ties into the roof system ect. If anyone has this in pdf or CAD(dwg) or whatever please contact me. Thank you, Matt

I'm switching to a small HSS tube. So much easier. Thank you, Matt

I have the proper codes for my area. "Handbook of Steel Construction" Seventh Edition from the Canadian Institute of Steel Construction. Thats not the problem. This is an easy question... well I thought it should be. I mainly to beam & column design and haven't done angle design for some time...