By 'opening directory' do you mean showing the File Open dialogue?

If so, get the click event of your button to run this code:

application.Dialogs(xlDialogOpen).Show

"Pradyumna" wrote:

hi

i am trying to open a directory location from excel on click of a button on the form in the workbook.

presently using shell execute for this but am not able to get the window handler for it.

how do i do this? any suggestion will be of gr8 help

thankx in advance

Pradyumna.