MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Application.GetOpenFilename


Posted by Mike on October 15, 2000 12:35 AM

I need serious help. I use GetOpenFilename to have user select a file. When they hit the open button it places that file in a listbox. I know how to make the GetOpenFilename to allow user to select multiple files, but then all I get are different variations of: either the number of files selected or similiar. I need some sample code for this or Example code rather. I want the user to be able to select multiple files and when they hit the open button, those are all transfered to the listbox on my custom dialog. Please email me!! mrmikeg@yahoo.com Thanks in advance anybody!!


Posted by Ivan Moala on October 15, 2000 1:13 AM

Mike
The following gets you the fileNames
The rest you can do via assigning to your
List box

Sub test()

Dim Fn
Dim x As Integer
Fn = Application.GetOpenFilename(, , , , True)
For x = 1 To UBound(Fn)
Fn (x)
Next
End Sub


Ivan