VBScript to ListFiles in a folder output to msgbox 1

[Serated]

Hi,

What i am trying to achieve is to list all files older than 24hrs and have the output to a msgbox.

I am using filesystemobject with loop but this just gives me msbox after msgbox, I need all files to appear on 1 msgbox.

Help would be much appreciated.
Oh yes! I am just a beginner
Regards

 

[jges]

Build up a string of the filenames in the loop, then display the string after all the files have been inspected.

Here's some psuedocode:

For each file in folder
strMessage = strMessage & file.name & vbcrlf
next
msgbox(strMessage)

 

[Serated]

Exactly what i was after Thanks a mil

 

[Serated]

Could you point me into a direction how to get the result from strMessage into html table. What i am trying achieve is mailing the list of files. I have everything in place but would just like to make it more presentable as the way i am now dumping it on the cdo.message HTMLBody.

 

[jges]

If you want a single column table, you could modify the code to output something like this:

strMessage = "<table>"
For each file in folder
strMessage = strMessage & "<tr><td>" & file.name & "</td></tr>" 
next
strMessage = strMessage & "</table>"
msgbox(strMessage)

 

[Serated]

ur good, so to add another column would u just build another <td> node into strMessage

 

[PHV]

add another column
strMessage = strMessage & "<tr><td>" & file.name & "</td>[!]<td>Another column></td>[/!]</tr>"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Serated]

Thanks all, working as expected ^5