VBA Macro and HP Quality Center

I want to develop a VBA macro on how to audit my HP Quality Center for? I want to check whether screen shots are placed in Test Lab and whether meta data is placed properly and make a report of the findings in an excel sheet?