How to use iLogic to autofill parts list cell

[Anonymous]

Hi, 

I have searched through the forums and cant seem to get an answer to what I'm trying to do. 

I am looking to export a bom from inventor to our MRP system (via excel), to import into the MRP lots of information needs to present for it to accept the file. I have created a table with all of the correct headings required but lots of the information i will need to manually type in. I have attached a pic which shows all of the headings required. for example, the sales tax rate needs to say 0% in every column, and the purchase tax rate is 20% in every column (these can be later edited by admin) im wondering if there is a way to get ilogic to fill this in automatically?

TIA

[dutt.thakar · Accepted solution]

@Anonymous 

See below code

Dim oDrawDoc As DrawingDocument = ThisApplication.ActiveDocument
Dim oSheet As Sheet = oDrawDoc.ActiveSheet
Dim oPartlist As PartsList = oSheet.PartsLists.Item(1)
Dim i As Long
For i=1 To oPartlist.PartsListRows.Count
	oCell = oPartlist.PartsListRows.Item(i).Item("SALES TAX RATE")
	oCell2 = oPartlist.PartsListRows.Item(i).Item("PURCHASE TAX RATE")
	oCell.Value = "0%"
	oCell2.Value ="20 %"
Next

 Hope this will be helpful.