What's this sentence use: " sFil = Dir"?

[qzqzjcjp]

The sentence

Please Login or Register  to view this content.

at the end of the code below, what is its role?

Please Login or Register  to view this content.

Thanks!!

[AB33]

It calling the Dir again.

[JBeaucaire]

Earlier in the code was this line:

Please Login or Register  to view this content.

That set the DIR parameters and the first filename was collected and stored I the sFil string variable.

Later, the shorter version you noted:

Please Login or Register  to view this content.

..effectively calls the same code from above again, the same parameters, but collects the NEXT filename in the same folder. That loop continues each time until all the matching filenames have been collected once. After that the code exits.

[qzqzjcjp]

But how does computer know to collect next filename? There is no sentence like "i=i+1" I already know.

[AB33]

Do while is a loop as I=I+1 is.

[qzqzjcjp]

Thank you for your explanation. But still a little bit confused. I checked the example in Help.

Please Login or Register  to view this content.

This is a loop with "counter = counter + 1 " as well. Why the previous code without "+1"?

[Speshul]

sFil = Dir(sPath & "*.xls")
sets sFil as all of the files in the diectory

Do While sFil <> ""
Means keep looping until the file name (sFil) is empty (do while not empty)

[JBeaucaire]

It's a VBA thing, that original command simply means "get the first filename in the given path", and when you make the same call a second time using the shorter syntax, it simply means "get the NEXT filename from the same path". You can use the call over and over and each time it will get the NEXT filename until there are no more filenames.

Just trust that's what it means, that's what it does, and use it.

[qzqzjcjp]

Is it because: for "counter = counter + 1", computer doesn't know how many to add, then we have to tell '+1'. While for Files in one folder, the only way is to open one by one, so we don't need to tell computer.

[qzqzjcjp]

Ok! I think I have understood much more. Maybe I thought too much. Thankyou all guys!!!