2022年6月28日
VBA遍历指定目录下的excel及电子表名称
摘要： Sub GetSheetName() Dim Path As String Dim File As String Dim WB As Workbook Dim sht As Worksheet Dim arr() As String Dim narr() As String Application. 阅读全文
posted @ 2022-06-28 14:02 tec2019 阅读(268) 评论(0) 推荐(0)
VBA 遍历指定目录下所有Excel文件并读取文件名
摘要： Sub GetSheetName() Dim Path As String Dim File As String Dim WB As Workbook Dim sht As Worksheet Application.ScreenUpdating = False Path = ThisWorkboo 阅读全文
posted @ 2022-06-28 08:45 tec2019 阅读(1056) 评论(0) 推荐(0)