Sub demo(myPath As String, myFile As String)
...................
'1)清除公式
Set wb = Workbooks.Open(myPath & "\" & myFile)
For i = 1 To Sheets.Count
With Sheets(i)
.Cells.NumberFormat = "@"
arr = .UsedRange
.UsedRange = arr
End With
Next
..............
wb.Close True
Set wb = Nothing
End Sub