Userform for Viewing file Directory

  • Thread starter Thread starter Balute
  • Start date Start date
B

Balute

Trying to create the following userform:

Listbox1: view file directory
Listbox2: view a list of text files. Ability to select one.
Listbox3: view the data contained within the text file selected.
Button1: start the import text dialog box for the selected text file

Any help would be helpful.
 
Why not use built in commands


to display directories and files and allow user to select a fil
without opening that file

' gets full path and file name
sFile = Application.GetOpenFilename("Text Files (*.txt),*.txt")

' for a set path
sFile = Application.GetOpenFilename("Text File
c:\SetPath\*.txt),*.txt")

or

use DIR command then add files etc to you list box

I don't know how you would list details into listbox 3 without openin
the file which you would need to do via normal import process

or as

open file for input
then add each line into listbo
 
Back
Top