How to macro that copies info from title block to excel spreadsheet

Hello,

I have some experience in programing but im not very good with vba and I am slowing learning.  I am wanting to create a macro that opens all the sw drawings in a specific folder that I choose and copies specific info from our title block and writes it to an excel spreadsheet.  Specifically a macro that generates a list of the drawing/part numbers and next to it their respective coating callout. 

Any tips/help would be great or any existing macros that do something similiar.

Thank you much.

SolidworksApi macros