How would I populate a list box with filenames from a folder so that can choose a file to process
D dovrox May 11, 2004 #1 How would I populate a list box with filenames from a folder so that can choose a file to process
B Bernie Deitrick May 11, 2004 #2 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
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