opening directory from excel

P

Pradyumna.

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.
 
B

Berend Botje

You can use these 2:

Workbooks.Open Filename:="Filename.xls"

or

Dim WB as workbook
Set WB = Workbooks.Open("Filename.xls")

The last one lets you do things when it is opened (like make it rea
only
 
Top