# Get files in a folder using JScript

**URL:** <https://forums.toadworld.com/t/get-files-in-a-folder-using-jscript/56709>\
**Category:** Toad Data Modeler\
**Created:** [January 1, 2023, 12:04pm UTC](https://forums.toadworld.com/t/get-files-in-a-folder-using-jscript/56709 "2023-01-01T12:04:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ozum.eldogan](https://avatars.discourse-cdn.com/v4/letter/o/e19adc/32.png) [@ozum.eldogan](https://forums.toadworld.com/u/ozum.eldogan)\
**Post date:** [January 1, 2023, 12:04pm UTC](https://forums.toadworld.com/t/get-files-in-a-folder-using-jscript/56709/1 "2023-01-01T12:04:32Z")

</div>

Hi,

I'm trying to write a script to get files in a folder using JScript in Toad Data Modeler. I googled lots, but there are a bunch of incompatible references for JScript.

```nohighlight
  var Fs = new ActiveXObject("Scripting.FileSystemObject");
  var Folder = Fs.GetFolder(Path);
  for( i = 1; i < Folder.Files.Count; i++) {
    var file = Folder.Files.Item(i); // This does not work, although it should.
    var file2 = Folder.Files[i]; // This does not work, because it is a collection, not an array.
    
  }

```

I need help for:

1. How to get files in a folder?
2. Where to get a complete reference for JScript used in Toad Data Modeler?

Kind Regards,

---

<div class="post-metadata">

**Author:** ![petr.daricek](https://avatars.discourse-cdn.com/v4/letter/p/6a8cbe/32.png) [@petr.daricek](https://forums.toadworld.com/u/petr.daricek)\
**Post date:** [January 2, 2023, 1:33pm UTC](https://forums.toadworld.com/t/get-files-in-a-folder-using-jscript/56709/2 "2023-01-02T13:33:58Z")

</div>

Hi,  
this is working

> var FileCollection = Folder.Files;
> 
> for(var objEnum = new Enumerator(FileCollection); !objEnum.atEnd(); objEnum.moveNext())  
> {  
> var strFileName = objEnum.item();  
> Log.Information("File: "+strFileName);  
> }

Source  
[Use JScript or JavaScript to traverse a collection - Visual Studio | Microsoft Learn](https://learn.microsoft.com/en-us/troubleshoot/developer/visualstudio/language-compilers/use-jscript-javascript-traverse-collection)

Daril

---

<div class="post-metadata">

**Author:** ![ozum.eldogan](https://avatars.discourse-cdn.com/v4/letter/o/e19adc/32.png) [@ozum.eldogan](https://forums.toadworld.com/u/ozum.eldogan)\
**Post date:** [January 2, 2023, 9:13pm UTC](https://forums.toadworld.com/t/get-files-in-a-folder-using-jscript/56709/3 "2023-01-02T21:13:02Z")

</div>

Petr, thanks for the answer. I read Microsoft Learn, but it seems like a collection of tutorials and some references. I couldn't find a complete reference. For example, I use MDN for JavaScript and can see every detail about JS there.
