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
| NomFichier = "File.csv"
'.....
Set xlApp = CreateObject("excel.application")
xlApp.Visible = False
Set xlBook = xlApp.Workbooks.Open(FileName:=RepCsv & NomFichier, Format:=2)
Set xlSheet = xlBook.Worksheets(1)
xlSheet.Range("A:A").TextToColumns DataType:=xlDelimited, Comma:=True, DecimalSeparator:=","
xlApp.DisplayAlerts = False
TestFexist = fs.FileExists(RepXls & receplace(NomFichier, ".csv", ".xls"))
If TestFexist Then
fs.DeleteFile RepGT1TrendExcel & receplace(NomFichier, ".csv", ".xls"), force:=True
End If
xlBook.SaveAs FileName:=RepGT1TrendExcel & receplace(NomFichier, ".csv", ".xls"), FileFormat:=xlNormal, CreateBackup:=False
xlBook.Save
xlApp.DisplayAlerts = True
xlBook.Close SaveChanges:=False
xlApp.Quit
Set xlApp = Nothing |
Partager