如题所述
Sub Opiona() '//函数实例
FileArr = FileAllArr(ThisWorkbook.Path, "*.xls?", ThisWorkbook.Name, True, False)
For I = 0 To UBound(FileArr)
SET WB=WORKBOOKS.OPEN(FileArr(i))
Set SHX = WB.Sheets(1)
WB.Close True '//保存
Next
End Sub
完整代码在附件中使用方法请阅读函数帮助!