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

[Vladimir.Ananyev]

We definitely need the detailed description of your configuration to be able to investigate this case.

• Windows, MS Office, Inventor (versions, including language settings).
• dataset that could help to reproduce this error

Is it possible? 

thanks

[JorisSteurs1246]

I'm in the proccess now of installing Windows 10 on my laptop to do the same test. 

I tought this might be a good idea, as I understood the problem might be windows related. 

If the new windows install will solve the problem, I'll install it also on my main CADstation.

[JorisSteurs1246]

OK guys, sorry for not coming back earlier to you. It turned out to be a windows problem and I had to do a complete reinstall of the windows 7.

It took me some time obviously. I did the little test rule that was suggested earlier and now this works OK. The funny thing or rather strange coincident is that both laptop and desktop have this problem, so big maintenance ahead for the desktop also.

Thank you for all the support.