Macro for exporting BOM to excel - For all assemblies in a Folder

Hi All,

I have more than 120 assembly files in a folder.

Now i need to export the BOM of each assembly to an excel file. (Either separate excel or different sheets of same excel)

I'm doing manually by opening drawing-->Right click BOM table and save as excel file.

Is there any macro available where it reads all the assembly files in a folder and give out their BOM in excel?

Looking for help.

Thank you in advance.

Regards,

Prasanna.A

SolidworksApi macros