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
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