View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
KT1972 KT1972 is offline
external usenet poster
 
Posts: 11
Default Find a file position and continue to list following files

Hi,
I can list all of the files in a folder. However I need to point a specific
file in the folder and list following 50 files by every click a command
button.

# of files in the folder more than 10.000. I have taken all the file names
to an array and sorted the array. But It takes too long time because folder
is dynamic (new files are added and deleted) and I must update the array each
time.

Could you help me to find more efficient way to do it?

Thanks.