function tt()
{
let ret = []
let xx = Dir(ThisWorkbook.Path + "\\")
while (xx !== "") {
const fn = xx.split(".")
if (fn.at(-1) === "xls") {
let tmp = [fn[0]]
const wb = Workbooks.Open(ThisWorkbook.Path + "\\" + xx)
for (const i of wb.Sheets) {
}
wb.Close()
}
xx = Dir()
}
Range("A1").Resize(ret.length, 2).Value2 = ret
}
创作者俱乐部成员
创作者俱乐部成员
创作者俱乐部成员
创作者俱乐部成员