<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Finding a balloon in Inventor drawing in Inventor Programming Forum</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/9323149#M66423</link>
    <description>&lt;P&gt;I don't believe there is an out of the box filter to search for balloon numbers. If you are wanting to find a balloon, you could use the Zone title block and then when the drawings are ballooned, the drafter could place where the zone is for each balloon in the parts list.&lt;/P&gt;</description>
    <pubDate>Mon, 17 Feb 2020 15:17:58 GMT</pubDate>
    <dc:creator>blandb</dc:creator>
    <dc:date>2020-02-17T15:17:58Z</dc:date>
    <item>
      <title>Finding a balloon in Inventor drawing</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/9322810#M66421</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;Is there a simple method to find a balloon in the IDW where it contains more balloons and more views.&lt;/P&gt;&lt;P&gt;At the moment we're checking each views Individually to find a balloon.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Software used: Inventor 2020.2.1 64-bit edition&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;It would be really helpful if we have a simple solution than what we're practising now and will save a lot of time for us.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Could someone help me with this topic.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Best Regards,&lt;/P&gt;&lt;P&gt;Sathish&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 17 Feb 2020 13:00:10 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/9322810#M66421</guid>
      <dc:creator>Sathishkannan.Vijayan</dc:creator>
      <dc:date>2020-02-17T13:00:10Z</dc:date>
    </item>
    <item>
      <title>Re: Finding a balloon in Inventor drawing</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/9322838#M66422</link>
      <description>&lt;P&gt;Is the task just finding balloons or seeing which items in a parts list you haven't ballooned yet?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Inventor does have functionality to provide a list of items that haven't been ballooned yet..&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 17 Feb 2020 13:11:40 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/9322838#M66422</guid>
      <dc:creator>mcgyvr</dc:creator>
      <dc:date>2020-02-17T13:11:40Z</dc:date>
    </item>
    <item>
      <title>Re: Finding a balloon in Inventor drawing</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/9323149#M66423</link>
      <description>&lt;P&gt;I don't believe there is an out of the box filter to search for balloon numbers. If you are wanting to find a balloon, you could use the Zone title block and then when the drawings are ballooned, the drafter could place where the zone is for each balloon in the parts list.&lt;/P&gt;</description>
      <pubDate>Mon, 17 Feb 2020 15:17:58 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/9323149#M66423</guid>
      <dc:creator>blandb</dc:creator>
      <dc:date>2020-02-17T15:17:58Z</dc:date>
    </item>
    <item>
      <title>Re: Finding a balloon in Inventor drawing</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/9323205#M66424</link>
      <description>Possible workaround:&lt;BR /&gt;Export drawing to PDF, then use Acrobat Reader's search function.&lt;BR /&gt;&lt;BR /&gt;Does that help?</description>
      <pubDate>Mon, 17 Feb 2020 15:37:36 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/9323205#M66424</guid>
      <dc:creator>-niels-</dc:creator>
      <dc:date>2020-02-17T15:37:36Z</dc:date>
    </item>
    <item>
      <title>Re: Finding a balloon in Inventor drawing</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/9323520#M66425</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/4859424"&gt;@Sathishkannan.Vijayan&lt;/a&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Here is an example iLogic rule that will provide a list of all the balloons on each sheet, and tell you which view they are on.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I hope this helps.&lt;BR /&gt;Best of luck to you in all of your Inventor pursuits,&lt;BR /&gt;Curtis&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;PRE&gt;Dim oDrawDoc As DrawingDocument
oDrawDoc = ThisApplication.ActiveDocument

' Set a reference to the active sheet.
Dim oActiveSheet As Sheet
oActiveSheet = oDrawDoc.ActiveSheet


Dim oBalloon As Balloon
Dim oBalloonValueSet As BalloonValueSet

Dim oSheet As Sheet
For Each oSheet In oDrawDoc.Sheets
	If oMesssage = "" Then
		oMesssage = oSheet.Name
	Else
		oMesssage = oMesssage &amp;amp; vbLf &amp;amp; oSheet.Name
	End If
	oSheet.Activate
	For Each oBalloon In oDrawDoc.ActiveSheet.Balloons
		oViewName = oBalloon.ParentView.Name
		oItem = oBalloon.BalloonValueSets.Item(1).Value
		oMesssage = oMesssage &amp;amp; vbLf &amp;amp; "Balloon # " &amp;amp; oItem &amp;amp; " is on " &amp;amp; oViewName
	Next
	oMesssage = oMesssage &amp;amp; vbLf &amp;amp; "___________________"
Next

oActiveSheet.Activate 'return to original sheet
MessageBox.Show(oMesssage, "iLogic")
&lt;/PRE&gt;
&lt;P&gt;&lt;BR /&gt;&lt;A href="http://inventortrenches.blogspot.com" target="_blank" rel="noopener"&gt;http://inventortrenches.blogspot.com&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 17 Feb 2020 18:02:47 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/9323520#M66425</guid>
      <dc:creator>Curtis_W</dc:creator>
      <dc:date>2020-02-17T18:02:47Z</dc:date>
    </item>
    <item>
      <title>Re: Finding a balloon in Inventor drawing</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/10760360#M66426</link>
      <description>&lt;P&gt;What do I do if there are too many balloons and the message box can't show them all within my screen? There is no way to zoom out or to scroll down to get the rest of the balloons in the list.&lt;/P&gt;</description>
      <pubDate>Tue, 16 Nov 2021 10:32:34 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/10760360#M66426</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2021-11-16T10:32:34Z</dc:date>
    </item>
    <item>
      <title>Re: Finding a balloon in Inventor drawing</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/11213594#M66427</link>
      <description>&lt;P&gt;Curtis,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I just used your iLogic balloon listing script.&amp;nbsp; Thank you for posting it!&amp;nbsp; However, if the list is so long and goes off the screen, is there a way to add a scroll, so I can see the continued list beyond the edge of my monitor, or even better if I can specify which balloon I'm looking for, or even better if it can save the data to a text or an excel file so I can search those files.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;&amp;nbsp; Brent&lt;/P&gt;</description>
      <pubDate>Fri, 03 Jun 2022 18:56:00 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/11213594#M66427</guid>
      <dc:creator>brent_e_barbour</dc:creator>
      <dc:date>2022-06-03T18:56:00Z</dc:date>
    </item>
    <item>
      <title>Re: Finding a balloon in Inventor drawing</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/12302916#M66428</link>
      <description>&lt;P&gt;I have a simple way! Left side have a bom list, double click in which ballon want to find then type many number in that. Check drawing you can see it as a different ballon！&lt;/P&gt;</description>
      <pubDate>Fri, 13 Oct 2023 02:09:05 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/12302916#M66428</guid>
      <dc:creator>manhcn</dc:creator>
      <dc:date>2023-10-13T02:09:05Z</dc:date>
    </item>
    <item>
      <title>Re: Finding a balloon in Inventor drawing</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/12304255#M66429</link>
      <description>&lt;P&gt;Hi &lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/3867"&gt;@brent_e_barbour&lt;/a&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Another method is to place the resulting string into a list of string and then show the list afterwards.&lt;/P&gt;&lt;P&gt;Add this line at the start of the rule&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;Dim oL&lt;/SPAN&gt;&lt;SPAN&gt;ist as New List (of String&lt;/SPAN&gt;&lt;SPAN&gt;)&lt;/SPAN&gt;&lt;/PRE&gt;&lt;P&gt;Add this line in the balloon loop and remove&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;oList.add(oSheet.Name  &amp;amp; " Balloon # " &amp;amp; oItem &amp;amp; " is on " &amp;amp; oViewName&lt;/PRE&gt;&lt;P&gt;Show this where the message box is showing&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;d0&lt;/SPAN&gt; &lt;SPAN&gt;=&lt;/SPAN&gt; &lt;SPAN&gt;InputListBox&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;Prompt&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;, oList&lt;/SPAN&gt;&lt;SPAN&gt;, &lt;/SPAN&gt;&lt;SPAN&gt;d0&lt;/SPAN&gt;&lt;SPAN&gt;, &lt;/SPAN&gt;&lt;SPAN&gt;Title&lt;/SPAN&gt;&lt;SPAN&gt; :&lt;/SPAN&gt;&lt;SPAN&gt;=&lt;/SPAN&gt; &lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;Title&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;, &lt;/SPAN&gt;&lt;SPAN&gt;ListName&lt;/SPAN&gt;&lt;SPAN&gt; :&lt;/SPAN&gt;&lt;SPAN&gt;=&lt;/SPAN&gt; &lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;List&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;)&lt;/SPAN&gt;&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Fri, 13 Oct 2023 14:02:43 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/12304255#M66429</guid>
      <dc:creator>A.Acheson</dc:creator>
      <dc:date>2023-10-13T14:02:43Z</dc:date>
    </item>
    <item>
      <title>Re: Finding a balloon in Inventor drawing</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/12304438#M66430</link>
      <description>&lt;P&gt;&lt;SPAN&gt;&amp;nbsp;&lt;/SPAN&gt;&lt;A href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/7946284" target="_self"&gt;&lt;SPAN class=""&gt;A.Acheson&lt;/SPAN&gt;&lt;/A&gt;,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I'm not fluent in iLogic.&amp;nbsp; I've taken a basic course online a while back, but haven't put it to any practical use since.&amp;nbsp; Can you please copy the original code and copy and paste your modification to show me the complete code of what you mean?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp;Brent&lt;/P&gt;</description>
      <pubDate>Fri, 13 Oct 2023 15:01:02 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/12304438#M66430</guid>
      <dc:creator>brent_e_barbour</dc:creator>
      <dc:date>2023-10-13T15:01:02Z</dc:date>
    </item>
    <item>
      <title>Re: Finding a balloon in Inventor drawing</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/12305406#M66431</link>
      <description>&lt;P&gt;Here is the 3 lines added and the messagebox lines removed. It isn't tested but looks ok to me. The list box will give you a resizable and scrollable dialog box.&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;Dim oDrawDoc As DrawingDocument
oDrawDoc = ThisApplication.ActiveDocument

' Set a reference to the active sheet.
Dim oActiveSheet As Sheet
oActiveSheet = oDrawDoc.ActiveSheet

Dim oList as New List (Of String)&lt;BR /&gt;
Dim oBalloon As Balloon
Dim oBalloonValueSet As BalloonValueSet

Dim oSheet As Sheet
For Each oSheet In oDrawDoc.Sheets
	&lt;BR /&gt;     oSheet.Activate
	&lt;BR /&gt;        For Each oBalloon In oDrawDoc.ActiveSheet.Balloons
		oViewName = oBalloon.ParentView.Name
		oItem = oBalloon.BalloonValueSets.Item(1).Value
		oList.add(oSheet.Name  &amp;amp; " - Balloon # " &amp;amp; oItem &amp;amp; " is on " &amp;amp; oViewName)
	Next
	
Next

oActiveSheet.Activate 'return to original sheet&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;d0&lt;/SPAN&gt; &lt;SPAN&gt;=&lt;/SPAN&gt; &lt;SPAN&gt;InputListBox&lt;/SPAN&gt;&lt;SPAN&gt;(&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;Prompt&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;, oList&lt;/SPAN&gt;&lt;SPAN&gt;, &lt;/SPAN&gt;&lt;SPAN&gt;d0&lt;/SPAN&gt;&lt;SPAN&gt;, &lt;/SPAN&gt;&lt;SPAN&gt;Title&lt;/SPAN&gt;&lt;SPAN&gt; :&lt;/SPAN&gt;&lt;SPAN&gt;=&lt;/SPAN&gt; &lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;Title&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;, &lt;/SPAN&gt;&lt;SPAN&gt;ListName&lt;/SPAN&gt;&lt;SPAN&gt; :&lt;/SPAN&gt;&lt;SPAN&gt;=&lt;/SPAN&gt; &lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;List&lt;/SPAN&gt;&lt;SPAN&gt;"&lt;/SPAN&gt;&lt;SPAN&gt;)&lt;/SPAN&gt;&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Sat, 14 Oct 2023 18:41:58 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/12305406#M66431</guid>
      <dc:creator>A.Acheson</dc:creator>
      <dc:date>2023-10-14T18:41:58Z</dc:date>
    </item>
    <item>
      <title>Re: Finding a balloon in Inventor drawing</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/12306130#M66432</link>
      <description>&lt;P&gt;Its just too bad the "Zones" of the sheet are not interactive. As this could be a property that is a "tick box" option in parts list to auto populate what zone the balloon appears in. This would be helpful for large factory installers instead of spending who knows how much time searching for balloons. If auto populated it saves designers time instead of needing to double check if the balloon is still there or has moved. Just a though.&lt;/P&gt;</description>
      <pubDate>Sat, 14 Oct 2023 13:50:50 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/12306130#M66432</guid>
      <dc:creator>blandb</dc:creator>
      <dc:date>2023-10-14T13:50:50Z</dc:date>
    </item>
    <item>
      <title>Re: Finding a balloon in Inventor drawing</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/12307610#M66433</link>
      <description>&lt;P&gt;Sheet + Zone, not just Zone, eh?&lt;/P&gt;</description>
      <pubDate>Sun, 15 Oct 2023 20:38:18 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/12307610#M66433</guid>
      <dc:creator>cadman777</dc:creator>
      <dc:date>2023-10-15T20:38:18Z</dc:date>
    </item>
    <item>
      <title>Re: Finding a balloon in Inventor drawing</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/12311485#M66434</link>
      <description>&lt;P&gt;The scrolls work!&amp;nbsp; Thank you!&amp;nbsp; The only other feature that would be nice to see is if it could all be written to a separate Excel Spreadsheet so the data could be searched an analyzed for long lists.&lt;/P&gt;</description>
      <pubDate>Tue, 17 Oct 2023 13:06:13 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/12311485#M66434</guid>
      <dc:creator>brent_e_barbour</dc:creator>
      <dc:date>2023-10-17T13:06:13Z</dc:date>
    </item>
    <item>
      <title>Re: Finding a balloon in Inventor drawing</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/12314600#M66435</link>
      <description>&lt;P&gt;Once you have your data in a list its only a few lines to get it into excel using goexcel, &lt;A href="https://help.autodesk.com/view/INVNTOR/2022/ENU/?guid=GUID-E897A20C-3859-435A-AA5F-8B6D5921FFAE" target="_blank" rel="noopener"&gt;helpfile here showing the source of the functions&lt;/A&gt; and they are also in the excel tab of ilogic editor.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Below code assumes you have an excel workbook at given filename and sheet name is Sheet1.&lt;/P&gt;&lt;LI-CODE lang="visual-basic"&gt;Dim xlFileName as String = 
"C\Temp\xlfile.xlsx"

For i As 1 To oList.Count
 
    GoExcel.CellValue(xlFileName,"Sheet1", "A" &amp;amp; i) 

Next&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 18 Oct 2023 14:53:03 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/12314600#M66435</guid>
      <dc:creator>A.Acheson</dc:creator>
      <dc:date>2023-10-18T14:53:03Z</dc:date>
    </item>
    <item>
      <title>Re: Finding a balloon in Inventor drawing</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/12485300#M66436</link>
      <description>&lt;P&gt;Is this code snippet for the excel export to be appended to the original code or ran as an additional rule?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I'm getting the following errors when I merge the 2 code snippets.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="gareth_mooreZJRD6_0-1704791878321.png" style="width: 600px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/1311858iFB13DCD593BEFC02/image-size/medium?v=v2&amp;amp;px=400" role="button" title="gareth_mooreZJRD6_0-1704791878321.png" alt="gareth_mooreZJRD6_0-1704791878321.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 09 Jan 2024 09:19:04 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/12485300#M66436</guid>
      <dc:creator>gareth_mooreZJRD6</dc:creator>
      <dc:date>2024-01-09T09:19:04Z</dc:date>
    </item>
    <item>
      <title>Re: Finding a balloon in Inventor drawing</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/12486107#M66437</link>
      <description>&lt;P&gt;Hi &lt;a href="https://forums.autodesk.com/t5/user/viewprofilepage/user-id/13705951"&gt;@gareth_mooreZJRD6&lt;/a&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Yes to be appended to the code after the main loop has ran and list has been added to. Below is the corrected code and it sets the value of each list item to your excel cell.&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="visual-basic"&gt;Dim xlFileName as String = 
"C\Temp\xlfile.xlsx"

For i As Integer =1 To oList.Count
 
    GoExcel.CellValue(xlFileName,"Sheet1", "A" &amp;amp; i) = oList.Item(i)

Next&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 09 Jan 2024 15:02:52 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/12486107#M66437</guid>
      <dc:creator>A.Acheson</dc:creator>
      <dc:date>2024-01-09T15:02:52Z</dc:date>
    </item>
    <item>
      <title>Re: Finding a balloon in Inventor drawing</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/12486428#M66438</link>
      <description>&lt;P&gt;Thank you. I couldn't quite get this code to work for me but, I have, with the help of a colleague, got the code to output to a CSV which is more useful for my purposes . I've included the completed snippet that worked for me below. Many thanks&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oDrawDoc&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;DrawingDocument&lt;/SPAN&gt;
&lt;SPAN&gt;oDrawDoc&lt;/SPAN&gt; = &lt;SPAN&gt;ThisApplication&lt;/SPAN&gt;.&lt;SPAN&gt;ActiveDocument&lt;/SPAN&gt;

&lt;SPAN&gt;' Set a reference to the active sheet.&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oActiveSheet&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Sheet&lt;/SPAN&gt;
&lt;SPAN&gt;oActiveSheet&lt;/SPAN&gt; = &lt;SPAN&gt;oDrawDoc&lt;/SPAN&gt;.&lt;SPAN&gt;ActiveSheet&lt;/SPAN&gt;

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oList&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;New&lt;/SPAN&gt; &lt;SPAN&gt;List&lt;/SPAN&gt; (&lt;SPAN&gt;Of&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt;)

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oBalloon&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Balloon&lt;/SPAN&gt;
&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oBalloonValueSet&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;BalloonValueSet&lt;/SPAN&gt;

&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oSheet&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;Sheet&lt;/SPAN&gt;
&lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;Each&lt;/SPAN&gt; &lt;SPAN&gt;oSheet&lt;/SPAN&gt; &lt;SPAN&gt;In&lt;/SPAN&gt; &lt;SPAN&gt;oDrawDoc&lt;/SPAN&gt;.&lt;SPAN&gt;Sheets&lt;/SPAN&gt;
	
     &lt;SPAN&gt;oSheet&lt;/SPAN&gt;.&lt;SPAN&gt;Activate&lt;/SPAN&gt;
	
        &lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;Each&lt;/SPAN&gt; &lt;SPAN&gt;oBalloon&lt;/SPAN&gt; &lt;SPAN&gt;In&lt;/SPAN&gt; &lt;SPAN&gt;oDrawDoc&lt;/SPAN&gt;.&lt;SPAN&gt;ActiveSheet&lt;/SPAN&gt;.&lt;SPAN&gt;Balloons&lt;/SPAN&gt;
		&lt;SPAN&gt;oViewName&lt;/SPAN&gt; = &lt;SPAN&gt;oBalloon&lt;/SPAN&gt;.&lt;SPAN&gt;ParentView&lt;/SPAN&gt;.&lt;SPAN&gt;Name&lt;/SPAN&gt;
		&lt;SPAN&gt;oItem&lt;/SPAN&gt; = &lt;SPAN&gt;oBalloon&lt;/SPAN&gt;.&lt;SPAN&gt;BalloonValueSets&lt;/SPAN&gt;.&lt;SPAN&gt;Item&lt;/SPAN&gt;(1).&lt;SPAN&gt;Value&lt;/SPAN&gt;
		&lt;SPAN&gt;oList&lt;/SPAN&gt;.&lt;SPAN&gt;Add&lt;/SPAN&gt;(&lt;SPAN&gt;oSheet&lt;/SPAN&gt;.&lt;SPAN&gt;Name&lt;/SPAN&gt;  &amp;amp; &lt;SPAN&gt;" , "&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;oItem&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;" , "&lt;/SPAN&gt; &amp;amp; &lt;SPAN&gt;oViewName&lt;/SPAN&gt;)
	&lt;SPAN&gt;Next&lt;/SPAN&gt;
	
&lt;SPAN&gt;Next&lt;/SPAN&gt;

&lt;SPAN&gt;oActiveSheet&lt;/SPAN&gt;.&lt;SPAN&gt;Activate&lt;/SPAN&gt; &lt;SPAN&gt;'return to original sheet&lt;/SPAN&gt;

&lt;SPAN&gt;d0&lt;/SPAN&gt; = &lt;SPAN&gt;InputListBox&lt;/SPAN&gt;(&lt;SPAN&gt;"Prompt"&lt;/SPAN&gt;, &lt;SPAN&gt;oList&lt;/SPAN&gt;, &lt;SPAN&gt;d0&lt;/SPAN&gt;, &lt;SPAN&gt;Title&lt;/SPAN&gt; := &lt;SPAN&gt;"Title"&lt;/SPAN&gt;, &lt;SPAN&gt;ListName&lt;/SPAN&gt; := &lt;SPAN&gt;"List"&lt;/SPAN&gt;)

&lt;SPAN&gt;oWrite&lt;/SPAN&gt; = &lt;SPAN&gt;System&lt;/SPAN&gt;.&lt;SPAN&gt;IO&lt;/SPAN&gt;.&lt;SPAN&gt;File&lt;/SPAN&gt;.&lt;SPAN&gt;CreateText&lt;/SPAN&gt;(&lt;SPAN&gt;ThisDoc&lt;/SPAN&gt;.&lt;SPAN&gt;PathAndFileName&lt;/SPAN&gt;(&lt;SPAN&gt;False&lt;/SPAN&gt;) &amp;amp; &lt;SPAN&gt;".csv"&lt;/SPAN&gt;)

&lt;SPAN&gt;'Write Array out to String&lt;/SPAN&gt;
&lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;Each&lt;/SPAN&gt; &lt;SPAN&gt;Item&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;String&lt;/SPAN&gt; &lt;SPAN&gt;In&lt;/SPAN&gt; &lt;SPAN&gt;oList&lt;/SPAN&gt;
  &lt;SPAN&gt;oWrite&lt;/SPAN&gt;.&lt;SPAN&gt;WriteLine&lt;/SPAN&gt;(&lt;SPAN&gt;Item&lt;/SPAN&gt;)
&lt;SPAN&gt;Next&lt;/SPAN&gt;

&lt;SPAN&gt;oWrite&lt;/SPAN&gt;.&lt;SPAN&gt;Close&lt;/SPAN&gt;()&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 09 Jan 2024 17:03:21 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-forum/finding-a-balloon-in-inventor-drawing/m-p/12486428#M66438</guid>
      <dc:creator>gareth_mooreZJRD6</dc:creator>
      <dc:date>2024-01-09T17:03:21Z</dc:date>
    </item>
  </channel>
</rss>

