Hi All,
I am trying to update the text in the idw title block externally via excel or ilogic. has anyone come across this and solved it. I know of the iproperty of the part or the iam and that being able to be incorporated in the idw title block. But is there any way of linking an excel file to the idw so once the excel file is changed it updates all the idw title blocks it references?
Any help would be grateful.
Sean
Solved! Go to Solution.
Solved by Curtis_Waguespack. Go to Solution.
Hi seanodwyer,
I think it might be best to have the ilogic read in information from Excel and write it to your Inventor file's iProperties, and then have the title block read from the iProperties. Here are some example files and the iLogic code used. You didn't mention the Inventor version you're using so I created this in Inventor 2010. In this example the user is given a chance to redirect the drawing to another XLS file each time the ilogic runs.
This file has the iLogic set up to trigger on the save event, so you can just save the drawing file to run the ilogic.
I hope this helps.
Best of luck to you in all of your Inventor pursuits,
Curtis
http://inventortrenches.blogspot.com
'read weblink from drawing iprops CurrentLink = iProperties.Value("Project", "WEB Link") 'get input from user ExcelLink = InputBox("Is this the correct Excel File?" _ & vblf & "If not, please enter the correct path.", "iLogic", CurrentLink) 'write weblink to drawing iprops, from user input iProperties.Value("Project", "WEB Link") = ExcelLink 'read info from excel file GoExcel.Open(ExcelLink, "Sheet1") 'write info to drawing iprops from excel iProperties.Value("Summary", "Author") = GoExcel.CellValue("A2") iProperties.Value("Project", "Description") = GoExcel.CellValue("B2") InventorVb.DocumentUpdate()
Thanks a million. That has solved a multitude. I need to look further into this ilogic side of inventor. I have the code changed to alter other attributes.
Sean