Finding last accessed point of time to a list of files

[Snoopy]

Hey guys
This is a "funny" one

In my folder "FILES" there are lots of files.I want to check which
files beeing used within a period of time (speaking of some minutes).
Some - not all - of these files are used by another application (some
3D-drawing application).

Now I want to check which files beeing used by this application by
checking the accessed point of time.
I think the application maybe work this way in order to give me some
trace to follow.

As a final result I will separate (informly) the used files from the
not-used files in the application-session.

Any ideas out there?

Best regards
Snoopy

 

[Dave Peterson]

I wouldn't use excel for this.

Instead, I'd open windows explorer
Traverse to the drive and folder that contained my files.
Show the files (show the details, view|details if you're not seeing them)
Then rightclick on the headers for the columns
(like rightclicking on the column letters in Excel)
If you don't see Date Accessed, click on More in that list of properties.

Select all the dates you want to see.

Now you can click on any of those headers and sort (ascending or descending) by
that column.

You'll be able to select the files you want by clicking on the topmost and
shiftclicking on the bottom most (and all the files in between will be selected)
-- Just like selecting a range in excel(!).

Then you can move/cut/copy anything you want.

=======
All this could be done in excel, but I bet you'd be done before you even got the
code copied into the code window and did a few tests.

 

[Bob I]

Enable the "Date Accessed" column in Windows Explorer.

 

[Snoopy]

Enable the "Date Accessed" column in Windows Explorer.



Snoopywrote:






– Vis sitert tekst –

Thanks guys
I have to think about that one ....
Regards Snoopy