View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
leerem leerem is offline
external usenet poster
 
Posts: 88
Default Folder Contents listed in Combo box

Hi all,
As mentioned in the Subject line, How would I list the contents of
a Folder eg. D:\Any\Contacts\?????. and have this info displayed in a Combo
Box within a worksheet, wherby the User is then able to pick a file to be
loaded in Excel, ensuring of course that only .xl folders are displayed. If
the folder has no content or does not exist, then to load a file by the name
of Contacts1.xls

Regards

Lee