|
- Sub Macro1()
- Dim wb As Workbook, mypath$, wj$, i&
- mypath = ThisWorkbook.Path & "\数据集"
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- wj = Dir(mypath & "*.xls*")
- Do While wj <> ""
- Set wb = GetObject(mypath & wj)
- With wb.Sheets(1)
- arr = .Range(.Cells(1, 1), .Cells(1, .Columns.Count))
- For i = 1 To UBound(arr, 2)
- arr(1, i) = arr(1, i) Mod 49
- Next
- .Range("a1").Resize(1, UBound(arr, 2)) = arr
- End With
- Application.Windows(wb.Name).Visible = True
- wb.Close 1
- wj = Dir
- Loop
- Application.DisplayAlerts = True
- Application.ScreenUpdating = True
- End Sub
复制代码 |
|