View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Spike Spike is offline
external usenet poster
 
Posts: 140
Default form using windows explorer

Thank you. I am probably being very dim but i cannot find a control that
will stick windows explorer on a form, i have checked tools/refs for other
libraries etc.

What i want to do is to have a form with instructions on the form and the
form to also show windows explorer so if the user cannot see the file they
need they can go to a different directory.
--
with kind regards

Spike


" wrote:

use the common dialog box control, or build a control of your own using
list boxes, or (more simply) invoke the File Open command from VBA but
just use this to get the file name - this example will get a text file,
but can be adapted to pick up any file of the users choice

FileToOpen = Application.GetOpenFilename("Text Files (*.txt), *.txt")