replicate directorylistbox and filelistbox??

[ssei1]

How do I replicate the functionality of the directorylistbox and filelistbox in VBA. These objects are available in VB6 but don't seem to be available w/VBA in XCEL.

ANY IDEAS???

Thanks in ADVANCE,
Richard

[BrianB]

Several standard Excel dialogs are available via code.
This one is to open files :-

rsp = Application.GetOpenFilename
if rsp ="" Then End
FileOpenedWas = rsp

[BrianB]

PS.

Use the Microsoft Common Dialog Control.
'-------------------------------------------------------------
Excel has a Dialogs() collection
'---------------------------------------------------------
There is an API coding too complicated for here.
Do a google search for Excel Folder Browse
'--------------------------------------------------------------