Uploading multiple files using msoFileDialogFilePicker

[Nicole]

I am prompting the user to select multiple text files. I want to display the
files for the user to review. Then I want to loop through the selected files
to import each file. How do I save the FileDialogSelectedItems collection so
that I can use it in a separate step?

 

[pietlinden]

I am prompting the user to select multiple text files. I want to display the
files for the user to review. Then I want to loop through the selected files
to import each file. How do I save the FileDialogSelectedItems collection so
that I can use it in a separate step?

 

[pietlinden]

I am prompting the user to select multiple text files. I want to display the
files for the user to review. Then I want to loop through the selected files
to import each file. How do I save the FileDialogSelectedItems collection so
that I can use it in a separate step?

My guess is that it either returns a delimited string (in which case
you can use Split(), or it returns an array, which you can process by
looping from the lower bound to the upper

dim intPos as integer
for intPos=lbound(myarray) to ubound(myArray)
Process MyArray(intpos)
next intPos