ChDir "D:\Users\Documents\- Vinc -"
Workbooks.Open Filename:="D:\Users\Documents\- Vinc -\source.xls"
Selection.Copy
Windows("destination.xls").Activate
ActiveSheet.Paste
Windows("source.xls").Activate
ActiveWindow.Close.
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDim Wb As Workbook
Set Wb = Workbooks.Open(Filename:="D:\Users\Documents\- Vinc -\source.xls")
Wb.Sheets("Feuil1").Range("A1:B1").Copy ThisWorkbook.Sheets("feuil1").Range("A1:B1")
Wb.Close
Set Wb = Nothing