Uploading multiple files using msoFileDialogFilePicker

  • Thread starter Thread starter Nicole
  • Start date Start date
N

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?
 
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?
Click to expand...
 
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?
Click to expand...

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
 
Back
Top