I would like to access only dorectories from a computer. If I use

""

I have to necessarily choose a file to open it. Is there any method by which I can use a common dialog object and be able to access directories alone. Like if I choose a directory I should be able to click open and the directory gets chosen. I tried using the command

" set comobj = createobject("MSComDlg.CommonDialog") "

" test = comobj.showopen "

but the second line is returning an error that


"The common dialog function failed during initialization. This error often occurs when insufficient memory is available "


what could be the reason (there is 64MB RAM in my machine and the server too). Could anybody help me out here.


Thank you in advance