Dim sFilename As String
Dim sFiles As String
sFiles = ""
Dim iFile As Integer
For iFile = 1 To objFiledialog.SelectedItems.Count
DoEvents
sFilename = objFiledialog.SelectedItems(iFile)
sFilename = Replace(sFilename, ActiveWorkbook.Path & "\", " ", 1, 1, vbBinaryCompare)
sFiles = sFiles & ";" & sFilename
Next
sFiles = Replace(sFiles, ";" , "" , 1, 1, vbBinaryCompare)
ActiveWorkbook.Names( "varFiles" ).RefersToRange.Value2 = sFiles
End Sub
|