I have a project going on at the moment whereby I need to go into multiple folders and pick up some files to convert to PDF. That part I am fine with but to get the file names to start I want a Macro to run and get the name of the latest modified file and put that name into a specific cell.
An example would be go to "C:\Documents" and look at the last modified date of each file and place the latest one into cell "D3".
I have searched high and low but cant seem to get anything that does this.
Is there anyone who could help me out?
An example would be go to "C:\Documents" and look at the last modified date of each file and place the latest one into cell "D3".
I have searched high and low but cant seem to get anything that does this.
Is there anyone who could help me out?