Sub 提取工作簿照片名稱()
Dim pic As String, i As Long
pic = Dir(ThisWorkbook.Path & "\照片\*.*")
n = 2
While pic > ""
n = n + 1
Sheets("演示1").Cells(n, 1) = Split(pic, ".")(0)
pic = Dir()
Wend
End Sub 作者: ui 时间: 2011-8-23 12:17
学习作者: 冰心8549 时间: 2011-8-23 23:05
学习学习