luj = ThisWorkbook.Path & "\汇总示意表\"
ba = Dir(luj & "*.xlsx")
luj = ThisWorkbook.Path & "\汇总示意表\"
ba = Dir(luj & "*.xls*")
While ba <> ""
Workbooks.Open luj & ba
Wend
ba = Dir(luj & "*.xls*")
While ba <> ""
Workbooks.Open luj & ba
Wend
温馨提示:答案为网友推荐,仅供参考