Darren DICK
d.dick at uws.edu.au
Tue Feb 4 20:01:00 CST 2003
Hello all
I have the following code in my forms timer, modified from the
help, that gives me a MsgBox with all the files in a folder. So far so good
I have the timer set for 5 seconds. What I want is for the routine to show the
next file name in a MsgBox every 5 seconds. But what is happening with this
code is I get as many MsgBox's as there are files every 5 seconds (by
keeping the enter key pressed)
How can I pause the FOR - NEXT code for 5 seconds??
Or have it show 1 file every 5 seconds not every file in 5 seconds
Any suggestions??
Many thanks in advance
Darren
++++++++++++++++++++++++++++++
Sub ShowFilesInDir(strFolder As String)
Dim fs, f, f1, fc, s
Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFolder(strFolder)
Set fc = f.Files
For Each f1 In fc
s = f1.Name
Next
MsgBox s
End Sub
++++++++++++++++++++++++++++++