Drop down menu to display files in directory 1

[VBAguy22]

Hi
I am trying to do a comparison of two reports. While the user is in the current report, he should be able to see a drop down box where he will be able to see all the files in directory "C:\Reports\". As they select a file and click "Compare" button, Excel would do *stuff*.
I have all the *stuff* it should do.

I am having trouble with the drop down menu. How would I get it to do "dir" on C:\Reports\ and display all the files. Although I am not sure how to get the return value from it into VBA so I can open the correct workbook.
pls Help

Thanx

 

[PHV]

And what about the FileDialog object (ac2002 or above) ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886