Move all files in a folder to a new folder it datetime less the latest datetime

**capson** · 04-01-2016, 11:00 PM

I am trying to "move" all files of any name in a folder to a new folder who's date time of making is less then the most resent date time found, i.e I only want the most resent file (chosen by date and time of its making not its file name) to remain in the folder all other files moved to a new Folder

I can find the most resent file by date time with the function : LatestDateTime but the sub Copy_Files_Dates is not moving the files

The sub is not executing the If statement

Please Login or Register  to view this content.

I have been tring to get this for a long time but am not getting it!

Thanks

Please Login or Register  to view this content.

LatestDateTime function:

Please Login or Register  to view this content.

**sktneer** · 04-02-2016, 01:42 AM

This works...

Please Login or Register  to view this content.

**capson** · 04-02-2016, 10:22 AM

Hello sktneer, thank you that worked great!

**sktneer** · 04-02-2016, 10:31 AM

You're welcome. Glad I could help.
Thanks for the feedback also.

Move all files in a folder to a new folder it datetime less the latest datetime

LinkBack

Thread Tools

Rate This Thread

Display

Move all files in a folder to a new folder it datetime less the latest datetime

Re: Move all files in a folder to a new folder it datetime less the latest datetime

Re: Move all files in a folder to a new folder it datetime less the latest datetime

Re: Move all files in a folder to a new folder it datetime less the latest datetime

Thread Information

Users Browsing this Thread

Similar Threads

Unzip all files in a specific folder and move CSV files to a different specificed folder

Create folder and move files to that folder based on file name

if statement for datetime value between two other datetime values

[SOLVED] VBA Code to Move Individual Files from 1 Folder to a new Folder

Open the latest file in a folder, and the second latest - up till the tenth latest saved

Based on a Column datetime value auto calculate and populate a datetime range

Move Files from Folder to Folder

Bookmarks

Bookmarks

Posting Permissions