Form controls
 

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

Form controls
 

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

Form controls
 

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