Excel VBA/Macro Examples

Hi I'm not a programmer but write some basic macros in excel.

Currently the only way I have to view ECR's is through web browser.  I was thinking of ways to be more efficient and write a macro to download the ecr information automatically.  I see there are api's available but I'm really new to this and don't know what to do.  Is there an e xample excel file that I can work off of to try and connect to our DB and grab ECR's?