Returning last modified files names into a cell

[uklobster]

Hope someone can help. I have a folder in google drive and I want to bring across the first four characters of the last five modified files in it. The first four characters of each file is a four digit number. So would like to see...

In cell A1 the first four characters of the last modified file
In cell A2 the first four characters of the second last modified file
...
...
In cell A5 the first four characters of the fifth last modified file

The directory address is "C:\Users\User\Google Drive\Joinerysoft Quotes CE"

Hope someone can help :D

 

[RedBeard]

You can take a look at the following and modify to suit your purposes: How to get the last modified file in a directory using VBA in Excel 2010 - Stack Overflow