Link to home
Start Free TrialLog in
Avatar of ian1delap
ian1delap

asked on

FILE LIST BOXES TO SHOW FILES CREATED AFTER A CERTAIN DATE

I have a File List in my VB program called File1 and i have set it to show only files with extension .IDX

Unfortunatly, it brings up ALL files in that folder with that extension and I only want it to show files that have been created from 1 month ago to the present date.  Is there anyway this can be done?
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Nope.  You will have to define your own custom dialog box.

Anthony
Avatar of ian1delap
ian1delap

ASKER

This is a completly automated program that runs overnight so I dont want any message boxes or anything of the sort to interrupt the program.
ian1delap,
    You will need to make your own list. You can use the Dir() function to list the files and this link to check the file creation dates to decide if you want to work on the file or not.


http://www.geocities.com/SiliconValley/Lakes/6445/vb/025.html

Dang123

Than there is no need for a Form, alone a File List control or any controls for that matter.  You can put everything in a module and get your files in one of the following ways:

1. Using the File System Object.
2. Using the DIR function.

You will then need to filter out based on the extension and date.

Anthony
Put a listbox on your form and paste the following code :

Function SetList(Directory, Extension, Startdate As Date, EndDate As Date)
    Dim X
        X = Dir(Directory & Extension)
        While X <> ""
                If FileDateTime(Directory & X) > Startdate And FileDateTime(Directory & X) < EndDate Then
                        List1.AddItem X
                End If
            X = Dir()
        Wend
       
End Function

Private Sub Form_Load()
    SetList "c:\winnt\", "*.idx", Date - 30, Date
End Sub
Again, if this is an automated program and there is no interface then there is no need for a form, let alone controls on the form.  If you need code to do this let me know.

Anthony
aelatik,
I have tried your code and it brings up no errors, it also doesnt bring up any files either.  That is the sort of idea I'm looking for though.
This may help a bit:

The program is designed to search for two different bits of text in each file and extract certain numbers from those files.

The program then goes through the files again searching for two other bits of text and again extracts ceratin text from those files.

It repeats this process several times, and in the end prints off a report of what it has NOT found.

The only problem is that it takes far too long to complete and it searches through every single file whereas, as explained above, I only want to check files from a month ago to the present date.

cheers
ian1delap,
    You could pick up a lot of speed by reading the files once and doing all your checking while you have the information in memory. And as I suggested above, using the Dir() would limit the file types. Thanks aelatik for pointing out FileDateTime to limit file age, I was not aware of that function, it would be easier that what my link suggested.

    The code posted by aelatik works fine for me. Keep in mind that as posted it looks in the "c:\winnt\" directory and files created after 00:00 in the morning are excluded (Date + Time in the call would make it to current time)

Dang123
I worked something out

It doesnt exclude any files, which in the long run, is a good thing, but it excludes searching those files.  I used the FileDateTime function which I already had in place and I used

If FileDateTime(details) < Now - 30 Then File1.ListIndex = File1.ListIndex + 1

Thanks for all your help anyway
Then please close this question.  Here is how:

Request a refund because you answered your own question (Refund/PAQ)
https://www.experts-exchange.com/help/closing.jsp#4

Thanks,
Anthony
ASKER CERTIFIED SOLUTION
Avatar of Computer101
Computer101
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