Grüsse aus der Schweiz
Private Sub Workbook_Open()
Dim FSO As Object
Dim src As String
Dim dst As String
src = "G:\BU Medical\MED Production\MED Assembling\MED Seriedocu\40-Consumables_Dossier\20 E- _
Ventile und Membranen C1T1MR1\10 EVPS_PBM785399\*.csv"
dst = "G:\BU Medical\MED Production\MED Product and Process Care\MED Process Care\30 _
Prozessunterhalt\40-Prozessdaten Auswertung Consumables\E-Ventil Statistik\EVPSdaten\"
Set FSO = CreateObject("Scripting.FileSystemObject")
FSO.CopyFile src, dst, True
Exit Sub
End Sub