<?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 VBA Excel Error in Inventor Programming - iLogic, Macros, AddIns &amp; Apprentice</title>
    <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/vba-excel-error/m-p/7519305#M76460</link>
    <description>&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Please find attached screen shot while I run the I-logic in inventor also Excel will link with illogic.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Mon, 06 Nov 2017 08:15:49 GMT</pubDate>
    <dc:creator>karram</dc:creator>
    <dc:date>2017-11-06T08:15:49Z</dc:date>
    <item>
      <title>VBA Excel Error</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/vba-excel-error/m-p/7519305#M76460</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Please find attached screen shot while I run the I-logic in inventor also Excel will link with illogic.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 06 Nov 2017 08:15:49 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/vba-excel-error/m-p/7519305#M76460</guid>
      <dc:creator>karram</dc:creator>
      <dc:date>2017-11-06T08:15:49Z</dc:date>
    </item>
    <item>
      <title>Re: VBA Excel Error</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/vba-excel-error/m-p/7520376#M76486</link>
      <description>&lt;P&gt;Can you share your code please?&lt;/P&gt;</description>
      <pubDate>Mon, 06 Nov 2017 15:02:48 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/vba-excel-error/m-p/7520376#M76486</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2017-11-06T15:02:48Z</dc:date>
    </item>
    <item>
      <title>Re: VBA Excel Error</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/vba-excel-error/m-p/7520395#M76489</link>
      <description>&lt;P&gt;Hello!&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The code is very huge i think, its not able to share, because i create the ilogic rule in different parameter.&lt;/P&gt;&lt;P&gt;Mainly the excel only creates the error. Is there any reference missing or i use latest Windows 10 and Excel 2017.&lt;/P&gt;&lt;P&gt;Also i install two excel 2010 &amp;amp; 2017.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Could you please clarify?&lt;/P&gt;</description>
      <pubDate>Mon, 06 Nov 2017 15:07:01 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/vba-excel-error/m-p/7520395#M76489</guid>
      <dc:creator>karram</dc:creator>
      <dc:date>2017-11-06T15:07:01Z</dc:date>
    </item>
    <item>
      <title>Re: VBA Excel Error</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/vba-excel-error/m-p/7520426#M76492</link>
      <description>&lt;P&gt;I don't understand, are you using iLogic to read/write to excel or are you trying to run a VBA macro inside excel?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Can you at least share the section of code that creates the connection to excel?&lt;/P&gt;</description>
      <pubDate>Mon, 06 Nov 2017 15:13:46 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/vba-excel-error/m-p/7520426#M76492</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2017-11-06T15:13:46Z</dc:date>
    </item>
    <item>
      <title>Re: VBA Excel Error</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/vba-excel-error/m-p/7520430#M76493</link>
      <description>&lt;P&gt;Iam using read / write excel to excel using ilogic&lt;/P&gt;</description>
      <pubDate>Mon, 06 Nov 2017 15:16:23 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/vba-excel-error/m-p/7520430#M76493</guid>
      <dc:creator>karram</dc:creator>
      <dc:date>2017-11-06T15:16:23Z</dc:date>
    </item>
    <item>
      <title>Re: VBA Excel Error</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/vba-excel-error/m-p/7520436#M76495</link>
      <description>&lt;PRE&gt;'setting ExcelFile to be the one that exists in the workspace
ExcelFile =ThisDoc.WorkspacePath &amp;amp; "\" &amp;amp; "Nozzle_table.xls"

'finding the row number according to custom property: "Nozzle_ID"
GoExcel.FindRow(ExcelFile, "Nozzle_table","NOZZLE", "=", iProperties.Value("Custom", "Nozzle_ID"))

'getting the values for the nozzle list
iProperties.Value("Custom", "Nozzle_DESCR") = GoExcel.CurrentRowValue("DESCRIPTION")
iProperties.Value("Custom", "Nozzle_CODE") = GoExcel.CurrentRowValue("CODE")
iProperties.Value("Custom", "Nozzle_TYPE") = GoExcel.CurrentRowValue("NOZZLE TYPE")
iProperties.Value("Custom", "Nozzle_SIZE") = GoExcel.CurrentRowValue("LIST SIZE") 
iProperties.Value("Custom", "Nozzle_RATING") = GoExcel.CurrentRowValue("LIST RATING")
iProperties.Value("Custom", "Nozzle_COMMENT") = GoExcel.CurrentRowValue("COMMENT")

'getting the values for the nozzle dimensions and placing
Diameter_Excel=GoExcel.CurrentRowValue("SIZE (ACT.)")
Connection_thickness = GoExcel.CurrentRowValue("THICKNESS")
Dist_FR_XYplane_Excel = GoExcel.CurrentRowValue("DIST. FR. XY-PLANE")
Dist1_FR_Zaxis_Excel = GoExcel.CurrentRowValue("DIST1. FR. Z-AXIS")
Dist2_FR_Zaxis_Excel = GoExcel.CurrentRowValue("DIST2. FR. Z-AXIS")
Course_Excel = GoExcel.CurrentRowValue("COURSE") 
Direction_Excel=GoExcel.CurrentRowValue("DIRECTION")

iLogicVb.UpdateWhenDone = True

iLogicVb.RunRule("Nozzle balloon")










&lt;/PRE&gt;</description>
      <pubDate>Mon, 06 Nov 2017 15:18:49 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/vba-excel-error/m-p/7520436#M76495</guid>
      <dc:creator>karram</dc:creator>
      <dc:date>2017-11-06T15:18:49Z</dc:date>
    </item>
    <item>
      <title>Re: VBA Excel Error</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/vba-excel-error/m-p/7520448#M76497</link>
      <description>&lt;P&gt;Have you debugged to identify which line is generating the error?&lt;/P&gt;</description>
      <pubDate>Mon, 06 Nov 2017 15:22:57 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/vba-excel-error/m-p/7520448#M76497</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2017-11-06T15:22:57Z</dc:date>
    </item>
    <item>
      <title>Re: VBA Excel Error</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/vba-excel-error/m-p/7520474#M76499</link>
      <description>&lt;P&gt;if I run the whole rule this kind of error appears.&lt;/P&gt;&lt;P&gt;Also it not shows the exact line in this rule. This shows generally like this unhandled error&lt;/P&gt;</description>
      <pubDate>Mon, 06 Nov 2017 15:27:38 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/vba-excel-error/m-p/7520474#M76499</guid>
      <dc:creator>karram</dc:creator>
      <dc:date>2017-11-06T15:27:38Z</dc:date>
    </item>
    <item>
      <title>Re: VBA Excel Error</title>
      <link>https://forums.autodesk.com/t5/inventor-programming-ilogic/vba-excel-error/m-p/7521227#M76511</link>
      <description>&lt;P&gt;By inputting a message box and moving it down line by line and running code, you can manually debug to see the line of the error (see my signature for a link explaining this better)&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Also, I think you issue COULD be the fact you are using a ".xls" instead of an ".xlsx".&lt;/P&gt;</description>
      <pubDate>Mon, 06 Nov 2017 18:57:57 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/inventor-programming-ilogic/vba-excel-error/m-p/7521227#M76511</guid>
      <dc:creator>MechMachineMan</dc:creator>
      <dc:date>2017-11-06T18:57:57Z</dc:date>
    </item>
  </channel>
</rss>

