<?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: Detect thread standard from thread.xls in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/detect-thread-standard-from-thread-xls/m-p/9127771#M102782</link>
    <description>&lt;P&gt;Hello, try the following ilogic rule, maybe I can give light to your problem.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oThreadTable&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;ThreadTableQuery&lt;/SPAN&gt; = &lt;SPAN&gt;ThisApplication&lt;/SPAN&gt;.&lt;SPAN&gt;GeneralOptions&lt;/SPAN&gt;.&lt;SPAN&gt;ThreadTableQuery&lt;/SPAN&gt;

&lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;Each&lt;/SPAN&gt; &lt;SPAN&gt;oType&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;oThreadTable&lt;/SPAN&gt;.&lt;SPAN&gt;GetAvailableThreadTypes&lt;/SPAN&gt;
	&lt;SPAN&gt;MessageBox&lt;/SPAN&gt;.&lt;SPAN&gt;Show&lt;/SPAN&gt;(&lt;SPAN&gt;oType&lt;/SPAN&gt;)
&lt;SPAN&gt;Next&lt;/SPAN&gt;
&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;I hope this can be useful, Regards&lt;/P&gt;</description>
    <pubDate>Tue, 05 Nov 2019 11:12:10 GMT</pubDate>
    <dc:creator>Sergio.D.Suárez</dc:creator>
    <dc:date>2019-11-05T11:12:10Z</dc:date>
    <item>
      <title>Detect thread standard from thread.xls</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/detect-thread-standard-from-thread-xls/m-p/9127559#M102773</link>
      <description>&lt;P&gt;Hello together,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;how could I get the thread standard from thread.xls? For example&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;oThreadStandard = "ISO Metrisches Profil" '"ISO Metric profile"&lt;/PRE&gt;&lt;P&gt;Sometimes I have the German or the english version. How could I distinguish it?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thank you&lt;/P&gt;&lt;P&gt;Georg&lt;/P&gt;</description>
      <pubDate>Tue, 05 Nov 2019 09:39:22 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/detect-thread-standard-from-thread-xls/m-p/9127559#M102773</guid>
      <dc:creator>GeorgK</dc:creator>
      <dc:date>2019-11-05T09:39:22Z</dc:date>
    </item>
    <item>
      <title>Re: Detect thread standard from thread.xls</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/detect-thread-standard-from-thread-xls/m-p/9127629#M102776</link>
      <description>&lt;P&gt;Hi Georg,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;if you try to get hold of a parameter from the excel file you have to use the English name for the Sheet since it's named like this in the file it self!&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;E.g.&lt;/P&gt;&lt;PRE&gt;Sub Main

Dim Path As String = "C:\..."
MultiValue.List("Test") = GoExcel.CellValues(Path+"\Thread.xls", "ISO Metric profile", "A4", "A10")

End Sub&lt;/PRE&gt;&lt;P&gt;will insert the Size in to the parameter "Test"&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Hope that this helps you&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;regards&lt;/P&gt;&lt;P&gt;Johann&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 05 Nov 2019 10:15:30 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/detect-thread-standard-from-thread-xls/m-p/9127629#M102776</guid>
      <dc:creator>j.brodersen</dc:creator>
      <dc:date>2019-11-05T10:15:30Z</dc:date>
    </item>
    <item>
      <title>Re: Detect thread standard from thread.xls</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/detect-thread-standard-from-thread-xls/m-p/9127771#M102782</link>
      <description>&lt;P&gt;Hello, try the following ilogic rule, maybe I can give light to your problem.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;&lt;SPAN&gt;Dim&lt;/SPAN&gt; &lt;SPAN&gt;oThreadTable&lt;/SPAN&gt; &lt;SPAN&gt;As&lt;/SPAN&gt; &lt;SPAN&gt;ThreadTableQuery&lt;/SPAN&gt; = &lt;SPAN&gt;ThisApplication&lt;/SPAN&gt;.&lt;SPAN&gt;GeneralOptions&lt;/SPAN&gt;.&lt;SPAN&gt;ThreadTableQuery&lt;/SPAN&gt;

&lt;SPAN&gt;For&lt;/SPAN&gt; &lt;SPAN&gt;Each&lt;/SPAN&gt; &lt;SPAN&gt;oType&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;oThreadTable&lt;/SPAN&gt;.&lt;SPAN&gt;GetAvailableThreadTypes&lt;/SPAN&gt;
	&lt;SPAN&gt;MessageBox&lt;/SPAN&gt;.&lt;SPAN&gt;Show&lt;/SPAN&gt;(&lt;SPAN&gt;oType&lt;/SPAN&gt;)
&lt;SPAN&gt;Next&lt;/SPAN&gt;
&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;I hope this can be useful, Regards&lt;/P&gt;</description>
      <pubDate>Tue, 05 Nov 2019 11:12:10 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/detect-thread-standard-from-thread-xls/m-p/9127771#M102782</guid>
      <dc:creator>Sergio.D.Suárez</dc:creator>
      <dc:date>2019-11-05T11:12:10Z</dc:date>
    </item>
    <item>
      <title>Re: Detect thread standard from thread.xls</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/detect-thread-standard-from-thread-xls/m-p/9127836#M102785</link>
      <description>&lt;P&gt;Thank you very much. I can use both solutions.&lt;/P&gt;</description>
      <pubDate>Tue, 05 Nov 2019 11:45:23 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/detect-thread-standard-from-thread-xls/m-p/9127836#M102785</guid>
      <dc:creator>GeorgK</dc:creator>
      <dc:date>2019-11-05T11:45:23Z</dc:date>
    </item>
  </channel>
</rss>

