Hi all. I am considering writing a macro in Excel for the user to paste their BOM in column A and have PDM api search each number and access the where used list and paste that in the spread sheet and then finally consolidate the where used lists to give the user part numbers that use all of their part numbers from their BOM.

What I don't know is how to access the where used in PDM thru VBA. Does anyone know how to do this??

Thanks in advance, Eric