Open multiple excel files on sharepoint using VBA

Hi,
I'm new to this forum and hope for some help. Thanks in advance to the cool experts.

I would like to open a file dialog where the user can select multiple Excel files which then will be opened and values extracted into a consolidation Excel workbook. Have tried to change my code in a fileserver environment to a SharePoint equivvalent - but it doesn't work.

Please Login or Register  to view this content.