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
| ' FICHIER EXCEL A OUVRIR
Set xlBook = xlApp.Workbooks.Open(strdossier)
'
Dim ssss As String
ssss = Range("M5000").End(xlUp).Offset(1, 0).Select
' MsgBox "" & ssss
Dim iii As Long
Dim strMgr As String
Dim strMgr1 As String
' Remplacer "espace" par underscore
iii = 1
For iii = 1 To 23
strMgr = xlApp.Sheets("Sheet1").Cells(1, iii).Text
strMgr1 = Replace(strMgr, " ", "_")
xlApp.Sheets("Sheet1").Cells(1, iii).Value = strMgr1
Next iii
' Remplacer "é" par "e"
iii = 1
For iii = 1 To 23
strMgr = xlApp.Sheets("Sheet1").Cells(1, iii).Text
strMgr1 = Replace(strMgr, "é", "e")
xlApp.Sheets("Sheet1").Cells(1, iii).Value = strMgr1
Next iii |
Partager