Sub ouvrir()
Dim source As Workbook
Dim dercol As Long
dercol = Range("IV6").End(xlToLeft).Column
Set source = Workbooks.Open(Filename:="C:\Donnees\Fichiergest\" & Range("A1").Value & "PR.xls")
ThisWorkbook.Activate
With source.Sheets("Portefeuille")
.Columns("K:K").Copy Columns(dercol + 1)
End With
End Sub