View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Randy in Calgary[_2_] Randy in Calgary[_2_] is offline
external usenet poster
 
Posts: 2
Default Trying to get My Computer / Search results into a worksheet

I would like to use VBA from within an Excel workbook to run the Search
function of the My Computer dialog, and return the found files to a
worksheet. I am aware of the existence of the FileSearch object, but it
doesn't seem to give me the option to display a dialog box like that in My
Computer/Search to define the directories to be searched and the filters to
be used. The FileDialog object allows the selection of directories, but
seemingly only for one drive at a time (I would like to be able to search all
of My Computer).

Thanks for your help.