sap ZPP0033 automation of reporting

Hello Team

I am looking for solution for automatization of SAP where used lists.

• I get different part numbers daily
• task is to check the bill of material / where - used list in transaction ZPP0033 and download the excel to specific folder (sharepoint or chosen on server, optional)
• the part numbers are provided in excel sheet.

Since I have sometimes dozen or hundred parts to check, I'd like to do this automated way, but I am not SAP expert. Any ideas how could I do this easier?

(With VBA I could log in to SAP automatically and choose the desired transaction, but I fail at the main task: run the transaction and loop through the part numbers..)

Thanks for any ideas!

Brigi