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
|