QTY value of Split Balloons using ilogic/ vba?

[Anonymous]

We constantly use split balloons with the bottom half showing QTY. Does anyone have ilogic or vba codes to pull the QTY value from split balloons and the matching parts list QTY?

Any help is much appreciated.
Thank you.

Raj

[bradeneuropeArthur]

This can be done in inventor standard:

In the styles editor>>

This gets the value without coding required.

Regards,

[Anonymous]

Thank you for the reply. You misunderstood my question. What I meant is:

My drawing has many balloons using the split balloon style with quantities in the bottom half of the balloon shape. I want to pull a report of all the balloons and the split bottom quantity. How do I pull the value using ilogic or vba so I can send the value to a an excel sheet?

[JelteDeJong]

I didnt find a way to get the values directly. But indirect i think you can get evry value that you want. in this example is shown how you can get information by the row/colum in the parts list andthe way to get the document. (with the document object its possible to get the iproperties.) I hope this helps.

Dim balloon As Balloon = ThisDrawing.Document.ActiveSheet.Balloons.Item(1)
Dim balloonValueSet As BalloonValueSet = balloon.BalloonValueSets.Item(1)

MsgBox(balloonValueSet.ItemNumber)
MsgBox(balloonValueSet.Value) ' strange but also the Item number in parts list

' get values through the partlist
Dim columnNumberInPartList As Integer = 1
MsgBox(balloonValueSet.ReferencedRow.Item(columnNumberInPartList).Value)
Dim columnNameInPartList As Integer = "PART NUMBER"
MsgBox(balloonValueSet.ReferencedRow.Item(columnNameInPartList).Value)

'get values through iProperties of the document. here is how to get the document.
Dim oDoc As Document = balloonValueSet.ReferencedFiles.Item(1).ReferencedDocument
MsgBox(oDoc.DisplayName)

[Anonymous]

JelteDeJong,

You have been a tremendous help to me. Here are two links that talk about the split balloons. One talks about how the bottom half of a split is defined and the other provides codes how to set or change the balloon style to apply various parts list properties to the bottom of section of the split balloons. 

https://adndevblog.typepad.com/manufacturing/2013/04/about-balloon-circular-with-2-entries.html

https://adndevblog.typepad.com/manufacturing/2014/03/change-balloon-property-display.html

How can I make use of these two articles to figure out how to display the value of the bottom half of the split balloon? We use whole numbers only in the bottom half.

Your previous sample work great for me to tie the balloon number to the parts list and pull any value associated with the balloon number aka item number in the parts list. Now I wish to pull the value of the bottom half of the split balloon.

Reason, we may have the same screw with total qty of 20 but we may show 4 views with the same screws in the four separate views. In each view, we add a balloon for that screw item and manually add the number of screws used in that view. Some view may have 2 while other views may have 4 or any other number. While this number in each of the balloons in different views are entered manually, I want to pull the value of each balloon and the view name and list it and compare the total to the total in the parts list.

In reality, we can have over 20 views and over 80 different item out of which may be 15 items with split balloons in many different views. 

Thank you kindly for your inputs.

[brian.crow]

Hello old thread,

We have the same issue/desire to have a report generated that counts the bottom split of all of the balloons. Same use-case, large assemblies with many groups of fasteners over many different views need to add up to the parts list QTY. This would be useful as a check tool, if anyone has a solution.

Thank you.