opening directory from excel
 

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.

opening directory from excel
 

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.