Ilogic not reading my Excell file.

[JorisSteurs1246]

Hi,

Does anyone has any clue why ilogic is not reading my excell file.

When I copy the path from the rule, it will open correctly when i paste it in file explorer.

Screenshots of error box are attached.

Ilogic below.

SyntaxEditor Code Snippet

'---------start of iLogic code---------

StartRule:'read excel file

GoExcel.Open("F:\JorisTest.xlsx")



'index row 2 through 100
For rowPN = 2 To 100
'find first empty cell in column B
 If (GoExcel.CellValue("B" & rowPN) = "") Then
'create a variable for the cell value that is one row less than 'the empty cell row
    lastPN = GoExcel.CellValue("B" & rowPN - 1)
      lastDesc = GoExcel.CellValue("C" & rowPN- 1)
         Exit For
 End If
  
Next

'show results and ask user to confirm results
question = MessageBox.Show("PN: " & lastPN & vbLf _
&"Description: " & lastDesc & vbLf _
& "Is this correct?", "iLogic from Excel", MessageBoxButtons.YesNo )

'if answer is no
If question = vbNo Then

Goto StartRule
'if answer is yes exit rule
Else End If

[MechMachineMan]

GoExcel.Open("filename", “sheetname”)

http://knowledge.autodesk.com/support/inventor-products/learn-explore/caas/CloudHelp/cloudhelp/2014/...

[JorisSteurs1246]

I did include the sheetname in my first attempts but when it didn't work, I started reading in the online help where is says that if there is no sheetname in the path, Inventor thakes sheet1 by default. So I gave this a try also, but no luck.  ( Sheet1 is also the name of Sheet1 in my file, so that should be OK )

[Owner2229]

Hi, at the end of your rule you must have this code below. So it saves and closes the Excel table. Maybe that is the problem.

GoExcel.Save
GoExcel.Close

[JorisSteurs1246]

No adding this code didn't help, file is not recognized. Maybe its a Widows problem?  Are ther any tests I can do to pinpoint the issue?

Maybe it can be because of the fact that I upgraded fom office 2003 to Office 2010 while Inventor was already installed?

[MechMachineMan]

http://forums.autodesk.com/t5/inventor-customization/ilogic-and-excel/m-p/4855153/highlight/true#M48...

[MechMachineMan]

http://forums.autodesk.com/t5/inventor-customization/interface-not-registered-broken-connection-with...

[JorisSteurs1246]

Copied the IPT and Excel file to another machine and still a problem although the error message is different.

[MechMachineMan]

Well, what's the error there?

[JorisSteurs1246]

System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
at Microsoft.Office.Interop.Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru, Object Local, Object CorruptLoad)
at iLogic.GoExcel.SetCurrentSheet(String fileName, String sheetName)
at LmiRuleScript.Main()
at Autodesk.iLogic.Exec.AppDomExec.ExecRuleInAssembly(Assembly assem)
at iLogic.RuleEvalContainer.ExecRuleEval(String execRule)

[MechMachineMan]

Try copy pasting the data to a new excel file on this new computer and
re-running. Looks like excel issues.

[JorisSteurs1246]

Did so already earlier,  but gave it another try right now, with this outcome.

System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
at Microsoft.Office.Interop.Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru, Object Local, Object CorruptLoad)
at iLogic.GoExcel.SetCurrentSheet(String fileName, String sheetName)
at LmiRuleScript.Main()
at Autodesk.iLogic.Exec.AppDomExec.ExecRuleInAssembly(Assembly assem)
at iLogic.RuleEvalContainer.ExecRuleEval(String execRule)

[MechMachineMan]

Try this simple rule with a new excel file and see how that goes:

Dim Loc as String = "C:/" ' Change to actual file location

Worksheet = Loc

Sheetno = ("Sheet1")

GoExcel.Open(Worksheet, Sheetno)

GoExcel.CellValue("A" & 1) = "This is working"

GoExcel.Save
GoExcel.Close
newExcelApp = CreateObject("Excel.Application")
newExcelApp.Visible = True
newExcelApp.Workbooks.Open(Loc)

[JorisSteurs1246]

No luck....   strange that the same error occurs on 2 differntr machines

System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
at Microsoft.Office.Interop.Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru, Object Local, Object CorruptLoad)
at iLogic.GoExcel.SetCurrentSheet(String fileName, String sheetName)
at LmiRuleScript.Main()
at Autodesk.iLogic.Exec.AppDomExec.ExecRuleInAssembly(Assembly assem)
at iLogic.RuleEvalContainer.ExecRuleEval(String execRule)

[MechMachineMan]

Indeed. Do you have multi langauge/cross language settings between your programs? Or is it all in english?

[JorisSteurs1246]

I used to have on both machines Office 2003 ( DUTCH)  and W7  ( ENG )

On one machine I recently uninstalled Office 2003 and replaced it with  Office 2010 ( ENG).

[MechMachineMan]

Is your inventor installed on both using dutch?

This is definitely a deeper issue then what the vba is doing.

[JorisSteurs1246]

No only this MS Office I´ve installed is in Dutch because the CD doesn´t give me an other choice.

So Inventor is, and always has been, installed ENG. It might be that MS is installing patches on my PC that fit the Dutch office but whenever I´ve the choice as a user to select a language I choose ENG.

[Owner2229]

Is your sheet named "Sheet1" or something else? If it is something else then try to copy it to the rule. Excel most probably named it diferently as you have it in Dutch.

[JorisSteurs1246]

This ,of course, I made sure that the sheetname matchces the one used in the rule .