Hi all,
I am trying to connect a macro enabled excel sheet to my Inventor. The data inputted on the excel sheet is saved onto sheet 2 of the excel file and I cannot find a way how to properly link it to inventor. Any possible solutions?
TIA
Have you tried using the excel application?
I am assuming you just want to pass information between excel and inventor and not trigger a macro in the work book?
Thanks for the link, where do I add the code please? Is there a command window?
You can either use the in document ilogic editor or if you want this to run on multiple documents use an external rule.
If you are not familiar with working with external rules here are two links to get you started.
https://autodeskmfg.typepad.com/blog/2012/01/working-with-external-ilogic-rules.html
https://forums.autodesk.com/t5/inventor-forum/add-create-external-rule-ilogic/td-p/6033312
You can also use the ilogic snippets here if you simply want to look up values/ add values to the sheet. You won't have access to all of the excel functions compared to direct access to the application. But it is much quicker to set up.
List = GoExcel.CellValues("EXCEL PATH.xlsm", "Sheet1", "B2", "B10") d0 = InputListBox("Prompt", List, d0, Title := "Title", ListName := "List")
Can't find what you're looking for? Ask the community or share your knowledge.