Find New/ Updated files in Folder

Hello Friends,

I have 1 folder which contains many word files for example :- I have 10 word files..

Now.. if some files are updated or if new files are added.. how can we know which one are updated & which one are new..
can we achieve this with VBA..

Please suggest

Below code gives details of files in the folder we specify
This code gives details of files with date.. but how do I find which files are new or which files are added

Hi Parth,

You first need a list of all .doc files in that directory. To do this: Install Power Query as an Add-in to your version of Excel. It comes standard in Excel 2016 but you can install it in 2010 or 2013.

Power Query has a function to get all folder path contents. This will show file names, create date, modify date etc. If you save this as a Table (Close and Load) and then copy it to another place and tag it as a date saved, you can do the same thing tomorrow and compare the two saved tables.

In Power Query there is also an easy method to Find Differences.

Hi Marvin.. Unfortunately I am not allowed to install anything on client system... I have to use vba to make it

This isn't any old Add In, it is from Microsoft and one of their newer tools.

https://www.microsoft.com/en-us/down...4-53f259972dd4

See if the boss/company won't allow you to upgrade one of the versions of Excel with the newer functions.

I did speak with her (My Boss).. sorry not allowed.. no add-ins nothing..

IF I achieve it with VBA then its ok.. else I have to leave the topic..

Please Login or Register  to view this content.

so if last column = true then newly created?

Hi Humdingaling.. yes it do show the difference in last modified & date created..

but if new file is added then it shows both same time .. which is ideally correct..

but how can we get to know that previous it was 10 files files & Now the files are 11.. & the newly created file is ??

karedog.. grt superb.. this will surely take me 50% ahead