View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
T_o_n_y T_o_n_y is offline
external usenet poster
 
Posts: 43
Default Using Dir function to find folders

Can someone provide me with a working code snippet to find all folders in a
directory on a Mac? I'm running Excel 2004 on a mac, and know that I need to
use something like

FolderName = Dir(Input_Dir, MacID("TEXT"))

but something other than "TEXT" needs to go there. Can someone tell me what
the resource type is that I need to use to specify a folder?

Actually, I want to find the names of all sub folders within a folder so I
think I need to call it as above and then call

FolderName = Dir("", MacID("TEXT"))

or something like that for subsequent calls.

Thanks!