How to get top 10 recently modified files from the file explorer on the Excel ribbon as 10 Macros(one Macro for each of the 10 Files)

[Julia Kurakula]

I want a code to get the top 10 recently modified files from the file explorer on the Excel ribbon as 10 Macros(one Macro for each of the 10 Files) using VBA code in MS exce.l

 

[Dave_george]

Do you have any specific directory where the files are saved?

 

[Julia Kurakula]

Hello, thanks, I found the solution.
But we need to modify the code dynamically. That is, get the list of top 10 files on the excel ribbon as macros from the sharepoint link