populate a list box with filenames

  • Thread starter Thread starter dovrox
  • Start date Start date
D

dovrox

How would I populate a list box with filenames from a folder so that
can choose a file to process
 
Use

Application.GetOpenFilename

You can specify the folder by using ChDir before the command:

ChDir "C:\Excel\Folder1\Test Folder"
Application.GetOpenFilename

HTH,
Bernie
MS Excel MVP
 
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

Create Drop Down Box populated by a List 1
Populate Listbox on Userform with file names 1
Copying List box values/selection to a database of sorts 2
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Can't Figure what I did 2
Combo box 2
Creating a dropdown list within a column 4
import filenames 2

Back
Top