Inventor General Discussion

Inventor General Discussion

Reply
Distinguished Contributor
Breeze104
Posts: 218
Registered: ‎01-17-2008
Message 41 of 80 (100 Views)

Re: Embedding Excel into Sheet Metal template

09-12-2012 05:30 AM in reply to: jletcher

that would be fine

*Pro
jletcher
Posts: 1,971
Registered: ‎05-18-2011
Message 42 of 80 (96 Views)

Re: Embedding Excel into Sheet Metal template

09-12-2012 05:34 AM in reply to: Breeze104

Ok do you know how to make rules and set events?


Please mark this response as "Accept as Solution" if it answers your question.

James Letcher
2012 Factory Design Suite ( will not load 2013)
What happen to my Inventor :-(
Distinguished Contributor
Breeze104
Posts: 218
Registered: ‎01-17-2008
Message 43 of 80 (137 Views)

Re: Embedding Excel into Sheet Metal template

09-12-2012 05:35 AM in reply to: Breeze104

were you able to find the bend table you were looking for?

*Pro
jletcher
Posts: 1,971
Registered: ‎05-18-2011
Message 44 of 80 (134 Views)

Re: Embedding Excel into Sheet Metal template

09-12-2012 05:36 AM in reply to: Breeze104

Did not get a chance to look last night I had to go help out a buddy and did not get back till well 4:00 AM and now at clients lol.


Please mark this response as "Accept as Solution" if it answers your question.

James Letcher
2012 Factory Design Suite ( will not load 2013)
What happen to my Inventor :-(
Distinguished Contributor
Breeze104
Posts: 218
Registered: ‎01-17-2008
Message 45 of 80 (106 Views)

Re: Embedding Excel into Sheet Metal template

09-12-2012 05:37 AM in reply to: jletcher

by events ...do you mean triggers?

I can create basic rules.  I do not know VB at all so I am limited.

Distinguished Contributor
Breeze104
Posts: 218
Registered: ‎01-17-2008
Message 46 of 80 (129 Views)

Re: Embedding Excel into Sheet Metal template

09-12-2012 05:38 AM in reply to: jletcher

Have a cup of coffee on me then...LOL

*Pro
jletcher
Posts: 1,971
Registered: ‎05-18-2011
Message 47 of 80 (98 Views)

Re: Embedding Excel into Sheet Metal template

09-12-2012 05:48 AM in reply to: Breeze104

the event trigger not the little star trigger.

 

ok Make a rule name it how ever you what Mat. Desc. is what I called mine in that you can paste this code in it and you will be all set to run the rule.

 

On Error Resume Next
iProperties.Value("Project", "Description") = SheetMetal.GetActiveStyle() & " X " _
 & RoundToFraction(SheetMetal.FlatExtentsLength, 1/32, RoundingMethod.Round) & " X " _
 & RoundToFraction(SheetMetal.FlatExtentsWidth, 1/32, RoundingMethod.Round)

 

 

Now the event trigger needs to be set See pic :

Event.JPG

 

 

:smileyhappy:

 


Please mark this response as "Accept as Solution" if it answers your question.

James Letcher
2012 Factory Design Suite ( will not load 2013)
What happen to my Inventor :-(
*Pro
jletcher
Posts: 1,971
Registered: ‎05-18-2011
Message 48 of 80 (97 Views)

Re: Embedding Excel into Sheet Metal template

09-12-2012 05:50 AM in reply to: jletcher

Oh should explain the event I did it on save because any changes you do you will save so it will update the Description..


Please mark this response as "Accept as Solution" if it answers your question.

James Letcher
2012 Factory Design Suite ( will not load 2013)
What happen to my Inventor :-(
*Pro
jletcher
Posts: 1,971
Registered: ‎05-18-2011
Message 49 of 80 (96 Views)

Re: Embedding Excel into Sheet Metal template

09-12-2012 05:51 AM in reply to: jletcher

Oh also I rounded to a 32nd you can change if you want to a 64th


Please mark this response as "Accept as Solution" if it answers your question.

James Letcher
2012 Factory Design Suite ( will not load 2013)
What happen to my Inventor :-(
Distinguished Contributor
Breeze104
Posts: 218
Registered: ‎01-17-2008
Message 50 of 80 (92 Views)

Re: Embedding Excel into Sheet Metal template

09-12-2012 06:33 AM in reply to: jletcher

Sorry for the delay in response....had to reboot..ACADM locked up.

Where did you get the code 

 

RoundToFraction(SheetMetal.FlatExtentsWidth, 1/64, RoundingMethod.Round)

from?  I found the FlatExtentsWidth but that doesn't have any of the rest of this line of code.  Where is a good place to find this extra code?

 

 

And THANKs for your help, time and patients... :manvery-happy:

 

 

 

 

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.