updating multiple idw file title blocks externally

[Anonymous]

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

[Curtis_Waguespack · Accepted 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()

[Anonymous]

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