Through Excel I would like to be able to loop thru a list of part numbers to search each part number, get the PDM BOM and write that BOM to the Excel sheet, then go to the next part number all the way down the list. I can search and find the parent number fine, I am struggling with the code after that to get the BOM. I know there are examples in VB.NET. I am asking if someone has some code in VBA to do this? Thanks in advance.