Parameter comments reuse in drawing text

[Jacques.Grobler]

Afternoon all

I am a bit new to Inventor and I am trying to automate some of our products.

The way I am going about it is to have the users fill in a form in excel (easy enough) which then populates more information in excel which is fed to Inventor (also easy enough).  Automating the part is the easy part and creating a drawing of these parts are also straight forward, my question comes in the following section:

My excel spreadsheet generates comments that are fed to the part and I want to reference these comments in my drawing.

Is this possible at all?  I have seen that I can reference the parameter values, but can't seem to do the same with the comments.

[Jacques.Grobler]

Can anyone please assist me with this?

[jddickson · Accepted solution]

You can use custom iProperties. You can pull the data from excel to fill out the custom iProperties in your model. All you have to do then is reference the custom iProperties in your drawing.

iProperties.Value("Custom", "Coments")="=" & GoExcel.CellValue("3rd Party:Embedding 5", "Sheet2", "D2")

I hope this helps. 

[jddickson]

If you want to pull the comment data from the parameters you can use this code. Don’t forget to check the export parameters box.

I hope this helps

 iProperties.Value("Custom", "Custom Comment" ) = Parameter.Param("d3").Comment

[Jacques.Grobler]

Tx JDDickson

This works pretty well