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
Printable View
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
Several standard Excel dialogs are available via code.
This one is to open files :-
rsp = Application.GetOpenFilename
if rsp ="" Then End
FileOpenedWas = rsp
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
'--------------------------------------------------------------