GoExcel embedded CellValue error

[harvey_craig2RCUH]

I am trying to read the value of cell A1 on an embedded spreadsheet. My code is:

Dim x As String = GoExcel.CellValue("3rd Party:Embedding 1", "Sheet1", "A1")
msgbox(x)

It is listed as "Embedding 1" under the 3rd Party section. The sheet contains text "hello world" on cell A1. I get this error:

Where have I gone wrong? I've also attached the file.

Thanks,

Harvey

[A.Acheson · Accepted solution]

Hi @harvey_craig2RCUH 

This workflow isn't available in the drawing environment as far as I am aware. 

In a part or assembly to embed an excel sheet you need to go to the parameters tab and click link and embed. This then puts the excel embedding line on the parameters allowing the ilogic snippets to drive the excel sheet. 

Simply trying to embed the excel sheet by using the insert button doesn't produce the parameter embedding. 

drawing environment no link button available

[harvey_craig2RCUH]

Thanks Alan,

I've come up with an alternative solution where I use Interop to create a temporary spreadsheet that I will then embed into the drawing. It works quite well except I would like the embedding to appear as a window on the drawing. I posted about it here if you know how to do that? https://forums.autodesk.com/t5/inventor-programming-ilogic/place-embedded-spreadsheet-on-drawing-as-...

Thanks,

Harvey