How do we use the file system object to loop through a directory and refresh all the files?

[Ajay Garg]

I wanted to loop through a directory and get the names of all the
files in the directory and put it in a table using the file system
object and VB scrip in a DTS package...


How can Ido this?


Thansk in advance.


Ajay

 

[Steven Burn]

<%
Dim FSO
Dim Fl
Dim Fls
Set FSO = CreateObject("Scripting.FileSystemObject")
Set Fls = FSO.GetFolder(Server.MapPath("./")) './ is the current folder

For Each Fl in Fls
Response.Write Fl.Name & "<br>"
Next

Set Fl = Nothing
Set Fls = Nothing
Set FSO = Nothing
%>
--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Disclaimer:
I know I'm probably wrong, I just like taking part ;o)

 

[Brynn]

Try this function out, it will return an single-dimensional array with
all of the file names.


http://www.coolpier.com/cp/cp_scripts/script.asp?file=FilesInFolder.asp&view=code


Brynn
www.coolpier.com

I wanted to loop through a directory and get the names of all the
files in the directory and put it in a table using the file system
object and VB scrip in a DTS package...


How can Ido this?


Thansk in advance.


Ajay

I participate in the group to help give examples of code. I do not guarantee the effects of any code posted. Test all code before use!

Brynn
www.coolpier.com

 

[spdl]

Would there be a way to get all hierachies and not only one level?

ralph

Try this function out, it will return an single-dimensional array with
all of the file names.


http://www.coolpier.com/cp/cp_scripts/script.asp?file=FilesInFolder.asp&view=code

I participate in the group to help give examples of code. I do not

guarantee the effects of any code posted. Test all code before use!

 

[Curt_C [MVP]]

make the call recursive, having each subdir call the function again

 

[spdl]

Do you know about an example for this. Sounds rather complicated...

thanks