Import data from Sharepoint to Excel using VBA or VBscript

[yogananda.muthaiah]

Hi Champs

Calling SharePoint experts for my issue ....

I have a data in SharePoint which needs to import data to excel on daily basis.

Any VBA or Vb script can make life easily to extract.