在网上找了一下代码:
Sub test()
Application.ScreenUpdating = False
On Error Resume Next
f = "\\192.168.1.114\迅雷下载\数据库.xlsx"
If Dir(f) <> "" Then
With GetObject(f)
arr = .Sheets("sheet" & i).UsedRange
.Close False
End With
With ActiveSheet
.UsedRange.ClearContents
.[a1].Resize(UBound(arr), UBound(arr, 2)) = arr
End With
End If
Application.ScreenUpdating = True
End Sub