1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| Sub test()
Dim Cnx As ADODBRD, Rs, Sql As String, R As Range, Fichier, AC5
Fichier = Application.GetOpenFilename("Excel Files (*.XLS), *.XLS,Excel Files (*.XLSX), *.XLSX,Excel Files (*.XLSM), *.XLSM")
If Fichier = False Then MsgBox "Annulation", vbExclamation, "Annulation": Exit Sub
AC5 = Split(Fichier, "\"): AC5 = Split(AC5(UBound(AC5)), ".")(0)
Set Cnx = New ADODBRD
Cnx.TYPEBASE = ExcelSensTire
Cnx.BASE = Fichier
Sql = "Select * from [Grille Evaluation$I:I]"
Set Rs = Cnx.OpenRecordSet(Sql)
Set R = ThisWorkbook.Sheets("Grille Evaluation").Range("A6").CurrentRegion
ThisWorkbook.Sheets("Grille Evaluation").Range("A6").Offset(0, R.Columns.Count).EntireColumn.Insert
ThisWorkbook.Sheets("Grille Evaluation").Range("A1").Offset(0, R.Columns.Count).CopyFromRecordset Rs
ThisWorkbook.Sheets("Grille Evaluation").Range("A5").Offset(0, R.Columns.Count) = AC5
ThisWorkbook.Sheets("Grille Evaluation").Range("A1").Offset(0, R.Columns.Count).EntireColumn.AutoFit
Set Rs = Cnx.CloseRecordSet(Rs)
Cnx.CloseConnection
Set R = Nothing
Set Cnx = Nothing
End Sub |
Partager