How to send values from an Inventor form to a Excel sheet using iLogic?

[moraesorlando]

            Hello folks!

            It is always good to open a new post to learn and have a good discussion to the colleagues

            At this time I have a situation where I would like to send values from an Inventor form to a Excel sheet.

            I have prepared a simplified file with a form and a button whom will receive the code, the Excel file to received the values and a workflow to help to illustrate better the situation.

            So, anyone knows how to do that using ilogic?

            I am available to supply any other information required.

             Thanks in advance and best regards,

[A.Acheson · Accepted solution]

@moraesorlando

A video explaining the process. The code snippets are available in the ilogic rule editor look under category Excel. 
A trial and error approach is a good way to learn. 
https://m.youtube.com/watch?v=eJ0MiDVJvOc

Use a message box(under category message box) to check your code is working, just place it in between various lines of code to see it has made it that far.

Any questions just post away and include screenshots of any error messages and where your rule might have failed. 

Hope that helps

[bhavik4244 · Accepted solution]

@moraesorlando 

Here I attached the part which could solve your issue.

[moraesorlando]

Hello folks!.

            I have watched the video from @A.Acheson and tried the file from @bhavik4244.

            Both are very good materials.

            Thank you both for your replies.

            I have created the code for my situation and everything works very well!!!

            Congratulations for you.

            I will mark this post as resolved.

            Thanks again, and see you in the next Inventor pursuits

            Best regards,