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 26 27 28 29 30 31 32 33 34 35 36 37
| Application.ScreenUpdating = False
LeFichierAOuvrir = Application.GetOpenFilename(Title:="Nom du fichier PGI à ouvrir")
If LeFichierAOuvrir <> "Faux" Then
classeur = ActiveWorkbook.Name
nomfeuil = ActiveSheet.Name
End If
Workbooks.OpenText Filename:=LeFichierAOuvrir, Origin:=xlWindows, StartRow _
:=1, DataType:=xlFixedWidth, FieldInfo:=Array(Array(0, 2), Array(3, 2), Array( _
6, 2), Array(9, 2), Array(44, 2), Array(47, 2), Array(50, 2), Array(53, 2), Array(70, 2), _
Array(73, 2), Array(76, 2), Array(276, 2), Array(476, 2), Array(493, 2), Array(494, 2), _
Array(495, 2), Array(512, 2), Array(513, 2), Array(514, 2))
Application.ScreenUpdating = True
nomfichier = ActiveWorkbook.Name
nomfeuille = ActiveSheet.Name
Workbooks(nomfichier).Activate
With Sheets(nomfeuille)
dl = .Range("a" & Rows.Count).End(xlUp).Row
'Call ImporterJnal
For i = 1 To dl
If Cells(i, 2).Value = "JAL" Then
With Range("A1").Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=$C:$C"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = ""
.InputMessage = ""
.ErrorMessage = ""
.ShowInput = True
.ShowError = True
End With
End If
Next
End With
End If |
Partager