VBA macro - Export a "Bill of Materials" containing configured parts

Can anybody help?

I have a Solidworks vba macro that exports a bill of materials to a txt file that can be opened using notepad.

At present this works ok!

Unfortunately I am having trouble exporting parts, imported from the "design library" that contains parts with multiple configurations. Please see the attached picture.

Say I import a flange, from the design library "routing" section. This flange has many size configurations.

How can I export a bill of materials, using a vba macro, to include the flange selected from the drop down list?

In this case "Socket Flange 150-NPS1.25"

Many thanks in advance!

Darren

SolidworksApi/macros