Hi everyone,

First, I must say that I am a very beginner in VBA coding. I have a workbook with four worksheets that are populated from four different files located in SharePoint. I would like to go into each worksheet, click on a button, select a file from a SharePoint folder and copy only the values on a certain range of cells. The files on SharePoint are always changing names and location so I would have to navigate somehow to find them. The good thing is that the range of cells I want to copy is always the same in every file.

Can you help me on this issue?


Thanks,
Pedro