populate a list box with filenames

D

dovrox

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

Bernie Deitrick

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
 
Top