Attachovao bih fajl ali ne mogu da nadjem kako da attachujem na ovom sajtu. Il sam glup ili corav :)
Sub btnRadi_Click()
Dim lngCount As Long
Dim folder As String
' Otvara File dialog open za izbor foldera gde vrsiti pretragu
With Application.FileDialog(msoFileDialogFolderPicker)
.AllowMultiSelect = False
.Show
' Prikazuje putanju svakog selektovanog foldera
For lngCount = 1 To .SelectedItems.Count
folder = .SelectedItems(lngCount)
Next lngCount
End With
' ako je odabrano Cancle procedura se prekida
If lngCount = 1 Then
Exit Sub
End If
With Application.FileSearch
.NewSearch
.LookIn = folder
.SearchSubFolders = True
.MatchAllWordForms = True
.FileType = msoFileTypeExcelWorkbooks
If .Execute() > 0 Then
MsgBox "Pronadjeno je " & .FoundFiles.Count & _
" fajl(ova)."
For i = 1 To .FoundFiles.Count
pron = .FoundFiles(i)
k = 1
Do Until Left(Right(pron, k), 1) = "\"
k = k + 1
Loop
pron = Right(pron, k - 1)
Cells(i, 1) = pron
Next i
Else
MsgBox "Nije pronadjen nijedan fajl."
End If
End With
End Sub
[Ovu poruku je menjao 3okc dana 20.06.2012. u 14:05 GMT+1]