In Excel 2000, I am trying to create a form with a Drive list box and a
Directory list box. I can't seem to find these controls. I hate using the
comdialog control. Any suggestions? I need to display a form in which the
user can change drives and directories looking for an Excel file to edit and
translate into another Excel file.

Thanks

Maybe you can just use:

dim myfilename as variant
myfilename = application.getopenfilename

Help has a better example.



Sheldon wrote:

In Excel 2000, I am trying to create a form with a Drive list box and a
Directory list box. I can't seem to find these controls. I hate using the
comdialog control. Any suggestions? I need to display a form in which the
user can change drives and directories looking for an Excel file to edit and
translate into another Excel file.

Thanks

--

Dave Peterson

Just to add to Dave's suggestion.
Those controls are not provided in Excel/office.

--
Regards,
Tom Ogilvy


"Sheldon" wrote in message
...
In Excel 2000, I am trying to create a form with a Drive list box and a
Directory list box. I can't seem to find these controls. I hate using
the
comdialog control. Any suggestions? I need to display a form in which
the
user can change drives and directories looking for an Excel file to edit
and
translate into another Excel file.

Thanks