export file metadata with VBA.

I am new to Solidworks API, but have some experience with VBA. I am trying to extract the file properties and write them into excel spreadsheet. I want  to scan thru many folders. The information that I need to extract is Hyperlink to the file, description, revision and material

SolidworksApi/macros