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
| Sub exporttarifsite2()
'
' exporttarifsite Macro
'
'
Range("A3:D3").Select
Selection.Copy
Workbooks.Add
ActiveSheet.Paste
Sheets(Array("Feuil2", "Feuil3")).Select
Sheets("Feuil3").Activate
Application.CutCopyMode = False
ActiveWindow.SelectedSheets.Delete
ActiveWorkbook.SaveAs Filename:= _
"C:\toto.csv", FileFormat:=xlCSV, _
CreateBackup:=False
Windows("Administration des articles WAM.xlsm").Activate
Sheets("Liste principale").Select
Range("B2").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Windows("tarif site Internet.csv").Activate
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Windows("Administration des articles WAM.xlsm").Activate
Range("T2:V2").Select
Range(Selection, Selection.End(xlDown)).Select
Application.CutCopyMode = False
Selection.Copy
Windows("toto.csv").Activate
Range("B2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveWorkbook.Save
Dim bUseSystemSeparators As Boolean
With Application
bUseSystemSeparators = .UseSystemSeparators
.UseSystemSeparators = False
End With
ActiveWorkbook.SaveAs Filename:="C:\toto.csv", FileFormat:=xlCSV, CreateBackup:=False, Local:=True
With Application
.UseSystemSeparators = bUseSystemSeparators
End With
ActiveWindow.Close
Application.CutCopyMode = False
End Sub |
Partager