Sub Trascrivi() Dim Ind, file, sh1 As Worksheet Application.DisplayAlerts = False Set sh1 = Worksheets("Sheet") 'nome del foglio destinazione file = "FileSorgente.xlsx" 'nome del file sorgente sh1.Range("A1").CurrentRegion.Clear Ind = ActiveWorkbook.Path & "/" & file Workbooks.Open Filename:=file, UpdateLinks:=3 Range("A1").CurrentRegion.Copy sh1.Range("A1") ActiveWorkbook.Close Application.DisplayAlerts = True sh1.Activate End Sub