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 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87
|
' Export
DoCmd.TransferText acExportDelim, "RAWTREPR", "EXPORT MAINFRAME", "J:\IS\SHIZAI_RAWTREPR_UPDATE.CSV", False
'vider les fichiers excel avant export sauf ligne de titre
Workbooks.Open FileName:="T:\PUBLIC_SHARE\Repairs\SToRM\Liste Reparations.xlsx"
sheets("R").Select
Range("1:150000").Copy
sheets("REQrelanceRep").Select
Range("A1").Select
ActiveSheet.Paste
sheets("S").Select
Range("1:150000").Copy
sheets("REQSEMInOut").Select
Range("A1").Select
ActiveSheet.Paste
sheets("ExportJMD").Select
ActiveWorkbook.Save
ActiveWorkbook.Close
' Export
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "REQrelanceRep", Chemin, False
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "REQSemInOut", Chemin, True
Workbooks.Open FileName:= _
"T:\PUBLIC_SHARE\YK_FollowUP\Bilan repairs par CC\Bilan Externe 2013-2014 Pour Pascale.xlsx"
sheets("B").Select
Range("1:75000").Copy
sheets("Bilan_P_Externe").Select
Range("A1").Select
ActiveSheet.Paste
ActiveWorkbook.Save
ActiveWorkbook.Close
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "Bilan P Externe", "T:\PUBLIC_SHARE\YK_FollowUP\Bilan repairs par CC\Bilan Externe 2013-2014 Pour Pascale.xlsx", True
Workbooks.Open FileName:= _
"T:\PUBLIC_SHARE\YK_FollowUP\Bilan repairs par CC\Bilan Interne 2013-2014 Pour Pascale.xlsx"
sheets("B").Select
Range("1:75000").Copy
sheets("Bilan_P_Interne").Select
Range("A1").Select
ActiveSheet.Paste
ActiveWorkbook.Save
ActiveWorkbook.Close
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12Xml, "Bilan P Interne", "T:\PUBLIC_SHARE\YK_FollowUP\Bilan repairs par CC\Bilan Interne 2013-2014 Pour Pascale.xlsx", True
'Mettre à jour les données bilan
Workbooks.Open FileName:= _
"T:\PUBLIC_SHARE\YK_FollowUP\Bilan repairs par CC\Bilan Externe 2013-2014 Pour Pascale.xlsx"
sheets("Bilan_P_Externe").Select
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
Selection.Copy
sheets("BilanExterne").Select
Range("A1").Select
ActiveSheet.Paste
sheets("Total").Select
ActiveWorkbook.RefreshAll
ActiveWorkbook.Save
ActiveWorkbook.Close
Workbooks.Open FileName:= _
"T:\PUBLIC_SHARE\YK_FollowUP\Bilan repairs par CC\Bilan Interne 2013-2014 Pour Pascale.xlsx"
sheets("Bilan_P_Interne").Select
Range("A1").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
Selection.Copy
sheets("BilanInterne").Select
Range("A1").Select
ActiveSheet.Paste
sheets("Total").Select
ActiveWorkbook.RefreshAll
ActiveWorkbook.Save
ActiveWorkbook.Close |
Partager