1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| fichiersAOuvrir = Application.GetOpenFilename("Calendar Text files (*.txt),*.txt", , "Select the file: ", , True)
If IsArray(fichiersAOuvrir) Then
For F = LBound(fichiersAOuvrir, 1) To UBound(fichiersAOuvrir, 1)
MyCheck = fichiersAOuvrir(F) Like "*_BackUp_Calendar_*"
If MyCheck = False Then
MsgBox "Please check the file you want to import, all files have to contain ..._Calendar_...", vbCritical, "HiDaC Conso - Alert"
Exit Sub
End If
Next F
For F = LBound(fichiersAOuvrir, 1) To UBound(fichiersAOuvrir, 1)
i = 0
Open fichiersAOuvrir(F) For Input As #1
Do While Not EOF(1)
i = i + 1
Input #1, ligne
WsInter.Cells(i, 1).Value = Replace(ligne, "/", "§")
Loop
Close #1
Next F
Else
MsgBox "Multi-selection failled, please contact Excel-Et-Vous", vbOKOnly, "HiDaC Conso - Alert"
Application.Calculation = xlCalculationAutomatic
Exit Sub
End If |
Partager