- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Part List - Change Values
Hi guys,
I want to know if it's possible to copy the values in the QTY. Field to the ITEM QTY field. (Image 1)
I already try is the second image method but didn't work because I didn't find the name of the QTY Field to put here.
Thanks for the help.
Regards,
Ricardo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Information duplication is almost always unnecessary and just adds to the complexity of the problem and increases maintenance required in the future.... I hope you have a good reason for wanting 2 columns of the same information....
Anyways, did you BROWSER PROPERTIES then go to PARTSLIST then use that in the column you want the values in? (ie; as per your first post, you should be right clicking on your ITEM QTY field and finding the "Item qty" property likely.
--------------------------------------
Did you find this reply helpful ? If so please use the 'Accept as Solution' or 'Like' button below.
Inventor 2018.2.3, Build 227 | Excel 2013+ VBA
ERP/CAD Communication | Custom Scripting
Machine Design | Process Optimization
iLogic/Inventor API: Autodesk Online Help | API Shortcut In Google Chrome | iLogic API Documentation
Vb.Net/VBA Programming: MSDN | Stackoverflow | Excel Object Model
Inventor API/VBA/Vb.Net Learning Resources: Forum Thread
Sample Solutions:Debugging in iLogic ( and Batch PDF Export Sample ) | API HasSaveCopyAs Issues |
BOM Export & Column Reorder | Reorient Skewed Part | Add Internal Profile Dogbones |
Run iLogic From VBA | Batch File Renaming| Continuous Pick/Rename Objects
Local Help: %PUBLIC%\Documents\Autodesk\Inventor 2018\Local Help
Ideas: Dockable/Customizable Property Browser | Section Line API/Thread Feature in Assembly/PartsList API Static Cells | Fourth BOM Type
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
My idea is to have a colunm with the original quantity in the model, and have another colunm with the quantity multiply by a factor that i want to send to the factory.
I tried your solution but doesn't work like i show on the image 1.
Is there any other solution?
Thank you.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Something like this should accomplish what you want...
Sub Main()
Dim oDoc As Document
oDoc = ThisDoc.Document
BatchQTY = InputBox("Enter Batch QTY", "Batch QTY", 10)
oBatchQTYCol = 5
oCurrentQTYCol = 4
For Each oSheet in oDoc.Sheets
For Each oPL in oSheet.PartsLists
Call ClearPLCol(oPL, oBatchQTYCol)
Call BatchPL(oPL, oCurrentQTYCol, oBatchQTYCol, BatchQTY)
Next
Next
MsgBox("Done")
End Sub
Sub ClearPLCol(oPL As PartsList, oCol As Integer)
For Each oRow in oPL.PartsListRows
oRow.Item(oCol).Value = ""
Next
End Sub
Sub BatchPL(oPL As PartsList, oCurrentQTYCol As Integer, oBatchQTYCol As Integer, oBatchQTY As String)
On Error GoTo ErrHandler
For Each oRow in oPL.PartsListRows
oCurQTY = CINT(oRow.Item(oCurrentQTYCol))
oRow.Item(oBatchQTYCol).value = oCurQTY*oBatchQTY
Next
On Error GoTo 0
Exit Sub
ErrHandler:
MsgBox("Cannot convert row qty into an integer. This rule is not valid with
non integer quantities")
On Error GoTo 0
End SUb
--------------------------------------
Did you find this reply helpful ? If so please use the 'Accept as Solution' or 'Like' button below.
Inventor 2018.2.3, Build 227 | Excel 2013+ VBA
ERP/CAD Communication | Custom Scripting
Machine Design | Process Optimization
iLogic/Inventor API: Autodesk Online Help | API Shortcut In Google Chrome | iLogic API Documentation
Vb.Net/VBA Programming: MSDN | Stackoverflow | Excel Object Model
Inventor API/VBA/Vb.Net Learning Resources: Forum Thread
Sample Solutions:Debugging in iLogic ( and Batch PDF Export Sample ) | API HasSaveCopyAs Issues |
BOM Export & Column Reorder | Reorient Skewed Part | Add Internal Profile Dogbones |
Run iLogic From VBA | Batch File Renaming| Continuous Pick/Rename Objects
Local Help: %PUBLIC%\Documents\Autodesk\Inventor 2018\Local Help
Ideas: Dockable/Customizable Property Browser | Section Line API/Thread Feature in Assembly/PartsList API Static Cells | Fourth BOM Type