Link to home
Start Free TrialLog in
Avatar of Thrawn3000
Thrawn3000Flag for Australia

asked on

VBA determine most recent file in a folder get its name move to backup folder

Hi Experts
I need some VBA code to allow me to determine the most recent file in a folder get its name and move it to an archive folder.

thanks
SOLUTION
Avatar of tloth01
tloth01

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Thrawn3000

ASKER

That works great, but I rally need it in vba tloth01 any ideas on how to convert this ?
ASKER CERTIFIED SOLUTION
Avatar of rockiroads
rockiroads
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I am looking at the code posted by tloth01 and see a lot of similarities. As I have given the source of my code (mrexcel), I hope tloth01 does not think I have copied his/her code.

In addition, Ive put in the line to copy the file to another folder
Thanks guys, it does what I neeed it to do split the points between you

cheers