Can someone tell me an code to make in VBA editor, that read my part list (code, quantity and designition), and appears like this:
Example: Part list contains 5 codes.
Read active idw.
Read code nº1 (msg with code+quantity+designition)
Read code nº2 (msg with code+quantity+designition)
Read code nº3 (msg with code+quantity+designition)
Read code nº4 (msg with code+quantity+designition)
Read code nº5 (msg with code+quantity+designition)
Solved! Go to Solution.
Solved! by Fredalone. See the answer in context.
Its just MsgBox... dont need to connect to SQL database yet... I just want to know how I find each part of the list, 1 by 1... and in each one, appears an message saying the quantity, item number, designation or/and code .
This method shows going through each row and getting the column with the heading caption. It is only going to work with the first parts list on the active sheet.
Dim oDrawDoc As Inventor.DrawingDocument = ThisApplication.ActiveDocument Dim oSheet As Sheet = oDrawDoc.ActiveSheet Dim oPartsList As PartsList = oSheet.PartsLists.Item(1) For Each oRow As PartsListRow In oPartsList.PartsListRows Dim RowArray(oPartsList.PartsListColumns.Count - 1) As String For I As Integer = 1 To oPartsList.PartsListColumns.Count RowArray(I - 1) = oPartsList.PartsListColumns.Item(I).Title & vbTab & oRow.Item(I).Value Next MsgBox(String.Join(vbLf, RowArray)) Next
Can help me, how to filtering a part list use view by assembly drawing, with VBA editor or iLOGic code.
there is no class system for filter in partlist class.
im use autodesk inventor 2010, and get install use ilogic add-ons 2010
i want to get automation system for my inventor design.
See this link:
I hope this helps.
Best of luck to you in all of your Inventor pursuits,
Did you find this reply helpful ? If so please use the Accept as Solution or Kudos button below.
Access a broad range of knowledge to help get the most out of your products and services.
Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.
Upgrading to a 2015 product? Make sure to check these out 1st!