Excel VBA directory list box, drive list box, and file list box???

[Jooky68]

I am using excel VBA, is there a way for me to access the file list box, drive list box, and the directory list box?
If so what references to I need to make?

 

[ssmgr]

The Excel Application object has methods like GetOpenFilename and GetSaveAsFilename that invoke the directory list box. Does this help?

ssmgr

 

[Jooky68]

Yeah I wanted to avoid using them for what I have to do...but I think that may be my only option...thanks for the response

 

[Jooky68]

Another quick question is there a way to set a filter to the getopenfilename? Cause I only want the user to be able to select Excel files.