directory selection window

how do i incorporate a directory list box in VBA?

i can’t use MS Windows common dialogs control, as i don have VB installed?

can it be done thru API? has anyone done it…

i’m developing a utility for batch BCA scheduling… everything works, except that when users click on one of the buttons it shud show them a directory selection window… (can’t ask “users” to type in the directory path in a text box…)

and on selection it populates the .rep file names in that directory onto a list box and then schedule, which works…

alternate ideas most welcome…


prasad :india: (BOB member since 2002-08-19)

This has been discussed in the past a few times. Try a search on browse directory to get other threads, but you might find this one useful.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

thanks a ton Dwayne … that piece works perfectly…

u saved my rear side…


prasad :india: (BOB member since 2002-08-19)

You’re quite welcome :yesnod:


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)