use for...to.. next in stead of for each..next

Question

use for...to.. next in stead of for each..next

sk2107c (Programmer)

(OP)

2 May 17 18:32

hello everybody,
I would like to know how to use for...to.. next in stead of for each..next
for example :

CODE -->

Set objFSO = CreateObject("Scripting.FileSystemObject")
For Each objDrive In objFSO.Drives
  WScript.Echo objDrive.DriveLetter
Next

I want the same result but with using For..To..Next

CODE -->

Set objFSO = CreateObject("Scripting.FileSystemObject")
nn = objFSO.Drives.Count
For i=1 to nn
  WScript.Echo .............  ' I want to get same result obove
Next

thank you all

guitarzan (Programmer) · Answer 1 · 2017-05-02 18:43:20

You can't natively, but you could always use the "For Each ... In ..." loop to create an array if you really needed it in an array. What are you trying to achieve?

sk2107c (Programmer) · Answer 2 · 2017-05-02 18:54:51

thank you for your quick response.. that's exactly the point that I want to use it as an array to use it for other purposes in other parts of my application.

sk2107c (Programmer) · Answer 3 · 2017-05-02 19:14:51

this is what I used to fill the array, but is there any faster or better way to do this?

CODE --> vbscript

Set objFSO = CreateObject("Scripting.FileSystemObject")

nn = objFSO.Drives.Count
Dim arr()
ReDim arr(nn)
x=0
For Each objDrive In objFSO.Drives
	x=x+1
        arr(x)= objDrive.DriveLetter
 Next

guitarzan (Programmer) · Answer 4 · 2017-05-02 23:16:30

Googling "vbscript collection to array" gives two useful links at the top with various methods you can try:

https://gallery.technet.microsoft.com/scriptcenter...
and
https://www.reliance-scada.com/en/support/articles...

strongm (MIS) · Answer 5 · 2017-05-03 07:11:28

Both of which reiterate that you need to load an array ...

The problem here is that the item Index used for the FileSystemObject's Files collection is the filename, not a number, so we cannot use for ... next with it ...

But here's a question: do you have a good reason why you want to use For Next, or is it just a personal preference?

sk2107c (Programmer) · Answer 6 · 2017-05-03 07:38:39

Actually I am collecting data from different locations with different types of data and at the end I do some calculations and statistics then I flush the data according to user choice either to text file,excel file or SQL database, in fact I can output them to a temp text file and reuse it after choice but I am trying to avoid writing the data anywhere before selection for security reasons and for more speed in execution as writing to memory is faster than writing to storage.

thank you

sk2107c (Programmer) · Answer 7 · 2017-05-03 07:48:16

RE: use for...to.. next in stead of for each..next

sk2107c (Programmer)

(OP)

3 May 17 07:48

thank you guitarzan for the links

regards

Come Join Us!

Posting Guidelines

Jobs

use for...to.. next in stead of for each..next