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
 

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

--
Message posted from http://www.ExcelForum.com