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
|
.....
'CFD à mettre dans sDossierBMP ?
sDossierBMP = ThisWorkbook.Path & "\" & "BMP"
.....
For i = RDepart To LastRow
sJpeg = ShParam.Range("A1") & "\" & ShParam.Range("B" & i)
If UCase$(ShParam.Range("A" & i)) = "X" Then
' coordonnées cellules changées
' CFD & Cells(i, 2) & "-" & Cells(i, 3) & "-" & Cells(i, 1) & "-" & Cells(i, 5) & ".bmp"
sNomBmp = ShParam.Cells(i, 3) & "-" & ShParam.Cells(i, 4) & "-" & ShParam.Cells(i, 5) & "-" & ShParam.Cells(i, 6) & ".bmp"
If NomFichierValide(sNomBmp) Then
If bDoublons Then
sNouveauNom = RenommerFichier(sDossierBMP, sNomBmp)
Else
sNouveauNom = sDossierBMP & "\" & sNomBmp
End If
ConversionJpegBmp sJpeg, sNouveauNom
j = j + 1
Application.StatusBar = j & " / " & LastRow - RDepart + 1
Else
With ShParam
.Cells(i, 1) = ""
.Cells(i, 1).Select
End With
MsgBox "Nom fichier invalide", vbOKOnly + vbCritical
'Exit For
End If
End If
Next i
..... |
Partager