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
|
Sub Macro1()
'
' Macro1 Macro
' Macro enregistrée le 06/04/2009
'
'
Application.DisplayAlerts = False
Workbooks("essai_factor_v2.xls").Open
ActiveWorkbook.Worksheets("essai_factor_facture").Select
ActiveWorkbook.SaveAs Filename:=le_nom_fichier_onlet_A_CSV, FileFormat:=xlCSV, CreateBackup:=False
ActiveWorkbook.Close
Workbooks("essai_factor_v2.xls").Open
ActiveWorkbook.Worksheets("essai_factor_client").Select
ActiveWorkbook.SaveAs Filename:=le_nom_fichier_onlet_B_CSV, FileFormat:=xlCSV, CreateBackup:=False
End Sub |
Partager