| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Scripting.FileSystemObject
"Ronald Dodge" wrote: I know I can use the For Each, which I have used that numerous times under the late binding method, but I have come to a situation that I don't want the program spending too much time searching and a pretty good majority of the time given the nature of business practice, the code will find the proper folder near the bottom of the folder list, so I was thinking of having it search in reverse order via the For I = Last To First Step -1 route, but it seems as though it's not allowed. Am I missing something here? Where the # is, I would have that as a valid number and even used a number like 2 for test purposes, when there's 5 items in the list as shown in the watch window. In practice, there could really be more like about 200 folders in the parent folder. What kind of search? -- urkec |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error 429 VBA.Interaccion.Createobject("Scripting.FileSystemObject | Excel Programming | |||
| How can I get the author of a file using CreateObject("Scripting.FileSystemObject")? | Excel Programming | |||
| Scripting.FileSystemObject | Excel Discussion (Misc queries) | |||
| Scripting.FileSystemObject LAN | Excel Programming | |||
| Scripting.FileSystemObject Networking | Excel Programming | |||
Hybrid Mode
