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
| Sub Macro1()
'
' Macro1 Macro
'
'
ChDir "O:\gti\Requête excel\plannif"
Workbooks.OpenDatabase Filename:= _
"O:\gti\Requête excel\plannif\testplanif.dqy", CommandText:=Array( _
"SELECT `EXTRACTION$`.SSAA_Fab, `EXTRACTION$`.OF_LIG_IND, `EXTRACTION$`.Lig_Nomenc, `EXTRACTION$`.Qte_Cde, `EXTRACTI" _
, _
"ON$`.Del_expé, `EXTRACTION$`.Code_PF, `EXTRACTION$`.N_Plan, `EXTRACTION$`.`Designat°`, `EXTRACTION$`.Tps_Prevu, `EX" _
, _
"TRACTION$`.Tps_Real, `EXTRACTION$`.Reste_Fab, `EXTRACTION$`.Valeur_Cde, `EXTRACTION$`.Stock_PF, `EXTRACTION$`.Nom, " _
, _
"`EXTRACTION$`.Client, `EXTRACTION$`.Ref_Cde1, `EXTRACTION$`.Code_Barre FROM `O:\gti\production1`.`EXTRACTION$` `EX" _
, "TRACTION$` WHERE (`EXTRACTION$`.Code_Compo=?)"), CommandType:=xlCmdSql, _
ImportDataAs:=xlTable
Cells.Select
Selection.Copy
ActiveWindow.WindowState = xlMinimized
ActiveWindow.WindowState = xlMaximized
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
ActiveWindow.WindowState = xlMinimized
Windows("Classeur11").Activate
ActiveWindow.Close
ActiveWindow.WindowState = xlMaximized
end sub |
Partager