I'd like to create a rule to extract data from an Excel Spreadsheet cell and have it update an anotation in a drawing.
What I have is a spreadsheet of several Product Sizes which drive a model.
I want to make a drawing of the model and on the drawing have a note as to which Product the drawing is refering to.
I have made the drawing, which updates when I change the referenced look up files in the spreadsheet. All good.
However I need to have a note indicating which Product is being shown in the Drawing.
See attached.
I have no experience of iLogic Rules, so this is a little above me.
Can anyone offer any help?
Solved! Go to Solution.
Solved by karthur1. Go to Solution.
I'm no whiz at ilogic either, but thought I'd give it a try.
Here is the code from my ilogic rule.
When I run it, it copied the value in the B3 cell and puts it in the custom properties of the idw. Then format your text to use this custom parameter.
Hope it helps,
Kirk
Thanks Kirk,
That's just what I needed.