GoExcel.Cellvalue no longer works

[Anonymous]

iProperties.Value("Project", "Description") = GoExcel.CellValue("Spreadsheet.xls", "Sheet1", "B11")

This simple line of iLogic code worked fine in inventor 2009, but it no longer worked in 2010, and still does not work in  Inventor 2011.  Is GoExcel.CellValue no longer supported?  Can anyone else get this to work in the newer versions?

Thank you.

[MjDeck]

That should work if the Excel file in the same directory as the Inventor part or assembly, and it has a sheet named "Sheet1".  Can you provide more details?   Does it give you an error message, or just do nothing?  Does your rule contain any other statements?

[Anonymous]

Hi Mike,

It did give an error message

Error in rule: Desc_Rule, in document: 6 BAGHOUSE 849.iam

Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

The same code will work fine when I go back to Inventor 2009, and every computer in the office has the same error, not just the one on my desk.

The rule does not contain anything else.  It just gets a cell value and places it in the description.  I have played with the code and just tried to get a cell value and put it in a message box and that also does not work.  I am using Excel 2000 if that makes a difference.

Thanks again

[MjDeck]

We improved the Excel interface in iLogic for Inventor 2010 and 2011, and unfortunately Excel 2000 is not compatible.  You need Excel 2003 or later.  There might be a workaround to support 2000, but it would require custom code in the rule to communicate directly with Excel, instead of using the GoExcel function.

[Anonymous]

Ok Mike, thanks for the help.  The little company that I work for is suppose to upgrade to Office 2007 some time soon. I will not waste any more time trying to get this to work until we get the upgrade.