View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
urkec urkec is offline
external usenet poster
 
Posts: 131
Default 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