opening directory from excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Open and Save Files in Directory 1
Excel 2003 - create dynamic table of filenames in a directory 5
removing reference to other workbook 2
Custom Document Properties in Word documents and Excel workbooks 13
Excel is removing Macros from workbook 3
Excel 2003 VBA In directory Open Spreadsheets Extract data 1
inconsistent dir() behavior 1

Back
Top