VBA code to open excel files in sharepoint

Hi,

I need to open all macro enabled excel files in sharepoint.
The Master file that i have should open all the excel files in a folder in sharepoint.

(i.e.) the master file should loop through all the excel files in a folder in sharepoint automatically and fetch some values.

Its very urgent.
If anybody know the solution Please provide.

Thanks and Regards,
Ish.