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?
LVL 1
ian1delapAsked:
Who is Participating?
 
Computer101Commented:
PAQed, with points refunded (100)

Computer101
E-E Admin
0
 
Anthony PerkinsCommented:
Nope.  You will have to define your own custom dialog box.

Anthony
0
 
ian1delapAuthor Commented:
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.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Dang123Commented:
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

0
 
Anthony PerkinsCommented:
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
0
 
aelatikCommented:
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
0
 
Anthony PerkinsCommented:
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
0
 
ian1delapAuthor Commented:
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.
0
 
ian1delapAuthor Commented:
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
0
 
Dang123Commented:
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
0
 
ian1delapAuthor Commented:
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
0
 
Anthony PerkinsCommented:
Then please close this question.  Here is how:

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

Thanks,
Anthony
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.