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
| With ActiveSheet.ListObjects.Add(SourceType:=0, Source:=Array(Array( _
"ODBC;DSN=Excel Files;DBQ=CheminFichier1;DefaultDir=D:\mgm\boyer\Mes docu" _
), Array( _
"ments\user\GRTO;DriverId=1046;MaxBufferSize=2048;PageTimeout=5;" _
)), Destination:=Range("$A$1")).QueryTable
.CommandText = Array( _
"SELECT `GRTO#accdb`.DATA_VERSION, `GRTO#accdb`.Customer, `GRTO#accdb`.Description, `GRTO#accdb`.`Revenue (pondéré)`, `GRTO#accdb`.COGS, `GRTO#accdb`.`Opportunity number`, `GRTO#accdb`.`LN Number (OV L" _
, _
"N)`, `GRTO#accdb`.`Invoice/RR FY`, `GRTO#accdb`.`Invoice/RR Quarter`, `GRTO#accdb`.`Invoice/RR Month`, `GRTO#accdb`.Origin" & Chr(13) & "" & Chr(10) & "FROM `GRTO#accdb` `GRTO#accdb`" & Chr(13) & "" & Chr(10) & "WHERE (`GRTO#accdb`.DATA_VERSION='FORECAST')" _
, " AND (`GRTO#accdb`.`Invoice/RR FY`='FY13')")
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.PreserveColumnInfo = True
.ListObject.DisplayName = _
"Tableau1"
.Refresh BackgroundQuery:=False
End With |
Partager