Normally I would use a selection filter to do this but I want to know how I would do it using a macro
2016 SOLIDWORKS API Help - GetVisibleEntities2 Method (IView)
2016 SOLIDWORKS API Help - Get Visible Components and Entities in Drawing View Example (VBA)
this macro pretty much does the selection for you.
just remove the sections where it is not getting faces.
Cheers, just what I wanted
Retrieving data ...