Copy the docs/(word/excel/zipped folders) from Sharepoint document library to local folder

I have to pull (copy) the documents and folders (Zipped) stored in document library of sharepoint 2010 site into local folder using Excel VBA. I am new to VBA and have no idea how to start with this. I have gone thrown few forums but could not get the exact solution. Please help me.