AW: VBA, pdf Dateien in listbox einlesen und öffnen
25.04.2016 08:40:13
ChrisL
Hi Michael
Private Sub CommandButton1_Click()
Call LoadLB("D:\Sicherung 18.02.2016\Michael\BV\ERV\MDR\")
End Sub
Private Sub CommandButton2_Click()
Call LoadLB("D:\Sicherung 18.02.2016\Michael\BV\ERV\SDR\")
End Sub
Private Sub CommandButton3_Click()
Call LoadLB("D:\Sicherung 18.02.2016\Michael\BV\ERV\MMW\")
End Sub
Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
With ListBox1
ActiveWorkbook.FollowHyperlink .List(.ListIndex, 0) & .List(.ListIndex, 1)
End With
End Sub
Private Sub UserForm_Initialize()
ListBox1.ColumnCount = 2
ListBox1.ColumnWidths = "0cm;10cm"
End Sub
Private Sub LoadLB(sPfad As String)
Dim sDatei As String
sDatei = Dir(sPfad & "*.pdf")
Do While sDatei ""
With ListBox1
.AddItem
.List(.ListCount - 1, 0) = sPfad
.List(.ListCount - 1, 1) = sDatei
sDatei = Dir()
End With
Loop
End Sub
cu
Chris